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