create table `test` (
`id` int not null auto_increment,
`name` varchar(255) not null,
`color` enum('black', 'cyan', 'magenta', 'yellow', 'mix') default 'black',
`enabled` enum('yes','no') default 'no',
primary key(`id`),
key(`enabled`)
) Engine=InnoDB default charset=utf8 collate=utf8_unicode_ci;
create table `test` (
`id` int not null auto_increment,
`name` varchar(255) not null,
`color` enum('black', 'cyan', 'magenta', 'yellow', 'mix') default 'black',
`enabled` enum('yes','no') default 'no',
primary key(`id`),
key(`enabled`)
) Engine=InnoDB default charset=utf8 collate=utf8_unicode_ci;
To copy to clipboard, switch view to plain text mode
Bookmarks