USE ` myemployees` ;
SELECT
last_name,
` email` ,
` phone_number` ,
` salary`
FROM
employees ;
SELECT * FROM ` employees` ;
SELECT last_name AS 姓 FROM ` employees` ;
SELECT salary AS 'OUT put' FROM ` employees` ;
SELECT DISTINCT ` department_id` FROM ` employees` ;
SELECT NULL + 5 ;
SELECT 'aaa' + 5 AS '和' ;
SELECT CONCAT( last_name, first_name) AS '姓名' FROM ` employees` ;
SELECT
CONCAT(
` first_name` ,
',' ,
` last_name` ,
',' , ` job_id` ,
',' ,
IFNULL( ` commission_pct` , 0.5 )
)
FROM
` employees` ;
ike
between and
in
is null
SELECT * FROM ` employees`
WHERE salary> 12000 ;
SELECT last_name FROM ` employees` ;
SELECT * FROM ` employees`
WHERE last_name LIKE '%a%' ;
SELECT last_name, salary FROM ` employees`
WHERE last_name LIKE '__e_a%' ;
SELECT
*
FROM ` employees`
;
SELECT * FROM ` employees` WHERE job_id NOT IN ( 'ad_pres' , 'ad_vp' , 'fi_mgr' ) ;
SELECT COUNT ( last_name) FROM ` employees` WHERE ` commission_pct` IS NULL
;
SELECT COUNT ( last_name) FROM ` employees` WHERE ` commission_pct` <=> NULL ;
SELECT DISTINCT
CONCAT( first_name, last_name) AS 姓名,
salary * 12 * ( 1 + IFNULL( ` commission_pct` , 0 ) )
AS 年工资
FROM ` employees` ;
SELECT last_name, salary FROM ` employees`
WHERE salary< 18000 AND ` commission_pct` IS NULL ;
DESC ` employees` ;
SELECT * FROM ` employees`
WHERE ` employee_id` >= 90 ORDER BY hiredate;
SELECT * , salary* 12 * ( 1 + IFNULL( ` commission_pct` , 0 ) ) AS 年薪
FROM ` employees` ORDER BY 年薪 DESC ;
SELECT * FROM ` employees`
ORDER BY salary ASC , ` employee_id` DESC LIMIT 1 , 1 ;
SELECT
last_name,
` department_id` ,
salary * 12 * ( 1 + IFNULL( ` commission_pct` , 0 ) ) AS 年薪
FROM ` employees` ORDER BY 年薪 DESC , ` department_id` ;
SELECT last_name, salary FROM ` employees` WHERE salary NOT BETWEEN 8000 AND 17000 ORDER BY salary DESC ;
SELECT * , LENGTH( ` email` ) FROM ` employees` WHERE ` email` LIKE '%e%'
ORDER BY LENGTH( ` email` ) DESC , ` department_id` ASC ;
SELECT LENGTH( TRIM( ' 张翠山 ' ) ) AS output;
SELECT TRIM( 'a' FROM 'aaaa张翠山aaaaa' ) AS output;
SELECT LPAD( '殷素素' , 10 , 'a' ) AS put;
SELECT REPLACE ( 'aaaaa' , 'a' , 'b' ) ;
SELECT ROUND ( 1.5 ) ;
SELECT ROUND ( - 1.4 ) ;
SELECT CEIL( 1.005 ) ;
SELECT ABS( - 5 ) ;
SELECT FLOOR( 9.99 ) ;
SELECT TRUNCATE ( 1.65 , 1 ) ;
SELECT NOW ( ) ;
SELECT CURDATE( ) ;
SELECT YEAR ( ` hiredate` ) AS 年 FROM ` employees` ;
SELECT MONTHNAME( NOW ( ) ) ;
SELECT STR_TO_DATE( '1998-3-2' , '%Y-%c-%d' ) AS PUT;
SELECT DATE_FORMAT( CURDATE( ) , '%Y年-%m月-%d日' ) AS put;
SELECT ` hiredate` FROM ` employees` ;
SELECT last_name, DATE_FORMAT( ` hiredate` , '%m月-%d日 %y年' ) AS 日期 FROM
` employees` WHERE ` commission_pct` IS NOT NULL ;
SELECT USER ( ) ;
SELECT IF ( 10 > 5 , 1 , 0 ) AS put;
SELECT last_name, ` commission_pct` , IF ( ` commission_pct` IS NULL , '没奖' , '有奖' ) AS put FROM ` employees` ;