INSERT INTO 表的名字(列名a,列名b,列名c) VALUES(值1,值2,值3);
例子:INSERT INTO employee(id,name,phone) VALUES(01,'Tom',110110110);
SELECT * FROM employee;#查看是否插入到了表中
三、约束分类
约束类型
主键
默认值
唯一
外键
非空
关键字
primary key
default
unique
foreign key
not null
三、查询语句
写法: SELECT 要查询的列名 FROM 表名字 WHERE 限制条件; 例子: SELECT name,age FROM employee WHERE age>25; SELECT name,age,phone FROM employee WHERE name=’Mary’; “AND”与“OR”的应用: #筛选出 age 小于 25,或 age 大于 30 SELECT name,age FROM employee WHERE age<25 OR age>30;
#筛选出 age 大于 25,且 age 小于 30
SELECT name,age FROM employee WHERE age>25 and age<30;
#筛选出 age 大于 25,且 age 小于 30
SELECT name,age FROM employee WHERE age betwenn 25 and 30;
SELECT name,age,phone,in_dpt FROM employee WHERE in_dpt IN ('dpt3','dpt4');