Create mysql datbase table example

Here is an example on how to create a table using mysql:

mysql> use testdb;

mysql> create table mytable (
    myid integer not null,

    mynumber integer,
    mystring varchar(255),
    myboolean boolean,

    myblob blob,
    primary key (myid)
);



This table is used for some of the examples found at:
http://www.javacodex.com/JDBC