How to create a table in mysql for containing 3 columns?

Question

I want to create a table containing three string columns:

1. The JSP page
2. Part of JSP page (like footer, header, text)
3. Actual value text

How do I do that:

1. from the command prompt
2. from a Java application (Create if it doesn't exist -- how common is that?)

Thanks

Answer 1

It is not likely you would want to create a table dynamically, especially if you need to save data and get it during other sessions. It's best to use mysql command prompt or a graphical tool like SQL Yog to create a table that you will later access at JSP page.

The command to create table will look like this

CREATE TABLE `pages` (
  `id` int(11) NOT NULL auto_increment,
  `part_of_page` varchar(30) NOT NULL,
  `actual_text` varchar(300) NOT NULL,
  PRIMARY KEY  (`id`)
) CHARACTER SET `utf8`;

Answer 2

As PHP Thinker says, you rarely want to create a table dynamically within a program. But if you have a legitimate reason, you just submit the "create" statement like an update query:

try
{    
Statement st=conn.createStatement();
    st.executeUpdate("create table mytable ... whatever ...");
    st.close();
}
catch (SQLException oops)
{
   ... query had syntax errors or something  ...
}

This is an update and not a query so there is no ResultSet returned. The return value is the number of records updated, which for a "create table" is always zero so no point bothering with it. If there's an error in