mysql练习3

CREATE DATABASE gjp CHARSET utf8;CREATE TABLE gjp_sort( sid INT PRIMARY KEY AUTO_INCREMENT, sname VARCHAR(100), parent VARCHAR(100), sdesc VARCHAR(10000));CREATE TABLE gjp_ledger( lid INT PRIMARY KEY ...

MySQL练习2

#查询员工的姓名SELECT ename FROM emp;#查询员工的薪水以及姓名SELECT ename,sal FROM emp;#插叙员工表所有的数据SELECT * FROM emp;#查询每一个员工的年薪（包含补助）SELECT ename,(sal + IFNULL(comm,0)) * 12 AS 年薪 FROM emp;#查询薪水为5000的员工SEL...

mySQL练习day1

/*创建表格*/CREATE TABLE dept( DEPTNO INT PRIMARY KEY AUTO_INCREMENT, `NAME` VARCHAR(20), LOC VARCHAR(20));CREATE TABLE emp( EMPNO INT PRIMARY KEY AUTO_INCREMENT, ENAME VARCHAR(20), JOB VARCHAR(20), MGR I...