テーブルを作成するmysql文

478 ワード


CREATE TABLE `proxy` (
   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
   `type` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '   ',
   `con` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL COMMENT 'host:port',
   `state` INT(1) NOT NULL COMMENT '1    ,0     ',
   PRIMARY KEY  (`id`)
 ) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci