create table `table name`( `field name1` type1 not null default 'x', `field name2` type2 default null, ... primary key (`pk name`), key `key name` (`field name1`, `field name2`) ) engine=other things here; #### create table `table_name`( `field_name1` type1 not null default 'x', `field_name2` type2 default null, ... primary key (`pk_name`), key `key_name` (`field_name1`, `field_name2`) ) engine=other things here; #### m/`\w+\s+\w+[\s+\w+]+`/ # backticks