MySQL | 数据库的基本查询

SELECT * FORM t_emp;
SELECT empnpo, ename, sal FROM t_emp;

USE demo;
SELECT * FROM t_emp;
SELECT empno,ename,sal FROM t_emp;

SELECT
	empno,
	sal*12 AS "income"
FROM t_emp;

SELECT empno,sal*12 AS "icome" FROM t_emp;

SELECT
	empno,
	sal*12 AS "income"
FROM t_emp;

SELECT ...... FROM ... LIMIT 起始位置, 偏移量;

SELECT empno, ename FROM t_emp LIMIT 10, 5;

SELECT empno, ename FROM t_emp LIMIT 10;
SELECT empno, ename FROM t_emp LIMIT 0,10;