create table teacher
(address char(50),name char(50))//添加表
INSERT INTO student(address,name)
VALUES('nanjing','unary')//插入元素
SELECT *FROM student//查询表内部元素,验证
DELETE student
where address='nanjing'//删除元素
SELECT *FROM student//再次查询,验证
DROP table student //删除表
SQL基本语句:创建表,添删元素,查询表。
最新推荐文章于 2024-05-08 23:27:53 发布