awei19950103的博客

MySql专项练习题②CREATE DATABASE db01;USE db01;– 学生表CREATE TABLE student (Sno VARCHAR(20),Sname VARCHAR(20),Ssex VARCHAR(20),Sbirthday DATETIME,Class VARCHAR(20));– 添加学生数据INSERT INTO student VALUE (‘108’,‘曾华’,‘男’,‘1977-09-01’,‘95033’);INSERT INTO student

MySql专项练习题①CREATE DATABASE db10;use db10;– 员工信息表CREATE TABLE emp(empno INT,ename VARCHAR(50),job VARCHAR(50),mgr INT,hiredate DATE,sal DECIMAL(7,2),comm DECIMAL(7,2),deptno INT) ;INSERT INTO emp VALUES(7369,‘SMITH’,‘CLERK’,7902,‘1980-12