mysql使用count語句注意什麼?數據操作語言:插入: insert，接下來我們就來聊聊關于mysql使用count語句注意什麼?以下内容大家不妨參考一二希望能幫到您!

mysql使用count語句注意什麼

數據操作語言:

插入: insert

修改: update

删除: delete

語法一:

insert into 表名 (列名, ...) values (值1, ...) ;

student表

insert into student (id,name,sex,age,subject,score,teacher_id)

values(10,'柳芳','女',15,'語文',83,2)

方式一:

insert into student (id,name,sex,age,subject,score,teacher_id)

values(11,'徐新','女',15,'語文',null,1)

方式二:

insert into student (id,name,sex,age,subject,teacher_id)

values(12,'楚軒','男',15,'語文',1)

insert into student (name,id,sex,age,subject,teacher_id,score)

values('楚軒',13,'男',15,'數學',1,80)

insert into student (id,name,sex,age,subject,score,teacher_id)

values(10,'柳芳','女',15,'語文',83,2)

insert into student

values(10,'柳芳','女',15,'語文',83,2)

語法二:(此語法SQL SERVER不支持)

insert into 表名

set列名=值,列名=值, ...

案例:

insert into student

set id =15,name ='柳芳',sex ='女', age =15,subject ='數學',score =98, teacher =3)

兩種語法的比較

1.語法一支持插入多行,語法二不支持

insert into student (id,name,sex,age,subject,score,teacher_id)

values(14,'柳芳','女',15,'英語',78,3),(15,'楚軒','男',15,'英語',71,4)

2.語法一支持子查詢，語法二不支持

insert into student

select * from student where id =6