如:表(table) studnet表中含有2个字段 id,name(id主键又称唯一标识符)
创建表 create table student
删除表 drop table student
在表中进行操作:
查询语句: 1.查询所有 select * from student where id=1;
2.查询单个字段 select id from student where id=2;或者select name from student where id=2;
添加语句: insert into student(id,name) values(3,"Tom");
删除语句: delete from student where id=2;
修改语句: update student set name="tom" where name="Tom";