mysql 错误集

1.

create table t(
     id int auto_increment,      #it must be define as a key 
     name varchar(20),
     age int)；<span style="font-size:18px;"></span>

Error：Incorrect table definition,there can be only one auto column and it must be define as a key。把id定义为primary key 或者其他key 就可以了

2.select count(*), age from t where age>20 group by school  和 select count(*) ,age from t group by school having age>20的差别

          第一个是对所有age>20的查询结果按字段school分组，第二个是先按字段school分组，然后把每一组中age都大于20的组返回出来

3.insert tablename(column1, column2) select column1, column2 from t;

         讲一个表中的某个字段的值复制到另一个表中