sql语句问题

Question

大家帮我看看下面出错在哪里?
先是创建表
create table teacher(id int(2) primary key auto_increment,name varchar(20));然后我想插出一条记录
insert into teacher('teacherzhang');
这样会出错.指定了id是自动递增的主键后,在插入的时候也一定要指出吗?
一定要用insert into teacher(1,'teacherzhang'); 吗?

Answer 1

insert into teacher(name) values('teacherzhang'); 

Answer 2

mysql> insert into teacher select null,'teacherzhang';
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0mysql> select *from teacher;
+----+--------------+
| id | name         |
+----+--------------+
|  1 | teacherzhang |
+----+--------------+
1 row in set (0.00 sec)