standard format
CREATE DATABASE [IF NOT EXISTS] db_name
[create_specification [, create_specification] ...]
create_specification:
[DEFAULT] CHARACTER SET charset_name
| [DEFAULT] COLLATE collation_name
Create DATABASE db_name
create table
CREATE TABLE `tester` (
`my_id` int(10) NOT NULL auto_increment,
`url` varchar(50) NOT NULL default '',
`no_sequence` varchar(50) NOT NULL default '',
PRIMARY KEY (`my_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;