经常创建了数据库数据表之后,需要上线修改数据表字段,总结了一下修改表的语句:
1.创建使用数据库;
2. 创建数据表;
CREATE DATABASE IF NOT EXISTS database_name
DEFAULT CHARACTER SET = utf8
DEFAULT COLLATE = utf8_general_ci;
USE database_name;
-- ----------------------------
-- TABLE structure for `table_name`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `table_name` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'auto increase',
`test` int(10) NOT NULL DEFAULT '' COMMENT 'test',
`string` varchar(20) NOT NULL DEFAULT '' COMMENT 'string',
`date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'yyyy-MM-dd HH:mm:ss',
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'last_update time',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'data create time',
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_test` (`test`),
KEY `indx_test_string` (`test`,`string`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='table just for test';
该示例创建了数据表table_name,有从1开始自增的主键id,数字类型test,字符串类型string&