数据库命令

用MySQL数据库实现以下内容

CREATE DATABASE `STUDENT`;

USE `STUDENT`;

DROP TABLE IF EXISTS `student_web`;

CREATE TABLE `student_web`  (

  `s_id` int(0) NOT NULL,

  `s_name` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `s_fenshu` int(0) NULL DEFAULT NULL,

  `s_hometown` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `s_tuition` int(0) NULL DEFAULT NULL,

  PRIMARY KEY (`s_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

INSERT INTO student_web VALUES(2,'Javk Tomas',89,'郑州进水',2800);

INSERT INTO student_web VALUES(2,'Tom Joe',88,'洛阳涧西',3000);

INSERT INTO student_web VALUES(3,'Smiths',87,'郑州中原',2700);

SELECT *FROM student_web;

SELECT *FROM student_web WHERE s_name like '%J%';

SELECT *FROM student_web WHERE s_hometown like '郑州%';

SELECT *FROM student_web WHERE s_tuition<(SELECT sum(s_tuition)/(SELECT COUNT(*) FROM student_web) FROM student_web);

数据库中会员表

SELECT *FROM huiyuan WHERE h_name !='小七';

有一张user表

DELETE FROM user WHERE id is null;

UPDATE user SET name = '匿名'WHERE name is null;

数据库中有student表

SELECT *FROM STUDENT WHERE CLASS=3;

部门表dept和员工表employee

SELECT * FROM DEPT d WHERE d.DEPTID in(SELECT e.deptid FROM employee e WHERE e.age>21);

SELECT * FROM employee e WHERE e.deptid in(SELECT e.deptid FROM employee e WHERE e.name='王红')

send表中日期(sendtime 字段)

send表中日期(sendtime 字段)

select *FROM send where  TO_DAYS(sendtime) = TO_DAYS(NOW())

启动暂停卸载

net start mysql

Net stop mysql

备份数据库

Use db_test

Select into outfile ‘c:backup/backupcontent.txt from content