❤️“大数据”❤️：第七课：数据库的使用❤️

数据库的使用

数据库脚本如下：

SQL的常用语句示例：
– 查询mysql的版本
SELECT VERSION();
– 查询当前时间
SELECT NOW();
– 查看员工表的所有信息
SELECT * FROM employee;
– 只看编号名字，性别，电话
SELECT eid,ename,esex,etel FROM employee;
– 只看女生，编号名字，性别，电话
SELECT * FROM employee WHERE esex=‘女’;
– 查看姓张的员工信息
SELECT * FROM employee WHERE ename LIKE ‘张%’;
– 插入一个新的员工
INSERT INTO employee(eName,ePass,eSex,eAge,eTel,eAddr,eInputDate,eFlag,eAdmin,dId) VALUES (‘张三丰’,‘000000’,‘男’,19,‘18254869553’,‘西安高新区’,‘2015-08-04 00:00:00’,‘0’,‘0’,1)
– 更新员工的性别
UPDATE employee SET esex = ‘男’ WHERE eid = 10019;
– 删除一个员工
DELETE FROM employee WHERE eid = 10029;
– 删除语句
DELETE FROM employee WHERE eid = 10033 OR eid = 10031;
DELETE FROM employee WHERE eid IN (10033,10031);