回顾
代码改错
1 、 INSERT INTO Students
(SName,SAddress,SGrade,SEmail,SSEX)
VALUES (' 张青裁 ',' 上海松江 ',6,'ZQC@Sohu.com')
2 、 INSERT INTO Students (SCode,
SName,SAddress,SGrade,SEmail,SSEX)
VALUES (100,' 张青裁 ',' 上海松
江 ',6,'ZQC@Sohu.com',0)
3 、 INSERT INTO StudentsInfo (' 姓名 ', ' 地址 ', ' 电子邮件 ')
SELECT SName,SAddress,SEmail
FROM Students
4 、 Update Students Set SName = ‘ 胡斐’ Set SSex = ‘1‘
Where SName = ‘ 胡非 '
1、INSERT INTO Students
(SName,SAddress,SGrade,SEmail,SSEX)
VALUES (' 张青裁 ','上海松江 ',6,'ZQC@Sohu.com‘,0)
2、INSERT INTO Students (
SName,SAddress,SGrade,SEmail,SSEX)
VALUES (' 张青裁 ','上海松江 ',6,'ZQC@Sohu.com',0)
3、INSERT INTO StudentsInfo ( 姓名, 地址 , 电子邮件)
SELECT SName,SAddress,SEmail
FROM Students
4、Update Students Set SName = ‘ 胡斐’,SSex = ‘1‘
Where SName = ‘胡非 '
第 1 页 / 共 30 页