创建表:
CREATE TABLE `tbtest` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'student id',
`name` VARCHAR(32) NOT NULL COMMENT 'student name',
`score` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'student score'
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='student tb'
看下:
mysql> show create table tbtest;
+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table