摘要: 增加一列alter table tableName add fieldName 字段类型修改一列alter table tableName modify (column) fieldName 字段类型删除一列alter table tableName drop columnfieldName建表语句最简单的:CREATE TABLE t1( id int not null, name char(20))ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='数据采集日志'; 2.带主键的:a:CREATE TA 阅读全文
posted @ 2013-08-21 09:40 rainbowi 阅读(283) 评论(0) 推荐(0) 编辑