SQL小记

1.复制表

create table book2 as select * from book;

create table book2 like book;

insert into book2 select *from book;

2. 插入datetime类型数据报错

错误类型：Incorrect datetime value: '1967' for column 'sbirthday' at row 1

解决方法：SET SESSION sql_mode=NO_ZERO_IN_DATE;

具体原因：http://www.databasejournal.com/features/mysql/article.php/10897_3577131_2/Date-and-Time-in-MySQL-5.htm