lanxingmo的专栏

create table test(id int auto_increment primary key ,a varchar(60),unique index(a)); MySQL [msg_center_dev]> select * from test; +----+------+| id | a |+----+------+| 1 | a |+----+------+1 row in set (0.004 sec)MySQL [msg_center_dev...

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.行的长度不能超过65535，即列的大小总和除了BLOBs longtext类型，总大小不能超过65535，修改列的大小，并将部分列修改为longtext...

mysql> select id from topic group by update_time having count(update_time) > 1;ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imdb.topic.id' which is not functionally dependent on co...

6位小数：CREATE TABLE `topic2`(`update_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),`detail_location` varchar(1024) DEFAULT '' COMMENT '详细地址');mysql> insert into topic2(detail_location)values('dddd');Query OK

导出表结构及数据mysqldump -uroot -hxxx.com -pxxx dbname tablename > tablename.txt仅导出表结构加 -dmysqldump -uroot -hxxx.com -pxxx -d dbname tablename > tablename.txt备份所有数据库mysqldump -u root -p --all-databases > database_dump.txt导出库mysqldump -u...