MySQL学习笔记——04

MySQL学习笔记——04.DQL语言学习.基础查询

• 查询表中单个字段

  SELECT ‘first_name’ FROM ‘employees’;

• 查询表中多个字段

  SELECT ‘first_name’,‘last_name’,‘email’ FROM ‘employees’;

• 查询常量

  SELECT 100;

• 查询表达式

  SELECT 9*10;

• 查询函数

  SELECT version();

• 起别名

  SELECT ‘first_name’ AS 名 FROM ‘employees’;

• 去重

  SELECT DISTINCT ‘job_id’ FROM ‘employees’;

• “+”作用

  SELECT ‘first_name’+‘last_name’ AS 姓名 FROM ‘employees’;

• concat连接

  SELECT CONCAT(‘first_name’,‘last_name’) AS 姓名 FROM ‘employees’;