2021-03-03
1 查询所有数据行和列
SELECT * FROM student02
SELECT SCode, SName, SGrade, SEmail, SSex, SAddress
FROM student02
2 查询部分行或列
SELECT SName, SGrade, SEmail
FROM student02
SELECT SName, SGrade, SEmail
FROM student02
WHERE SName = '李四'
选择不是的内容(排除查询)不等于符号!=和<>
原创
2021-03-03 15:22:55 ·
71 阅读 ·
2 评论