摘要:
MySQL常用关键词 1. 显示表departments的结构:DESC DESC departments; 2. 显示出表employees中的全部job_id(不能重复):DISTINCT SELECT DISTINCT job_id FROM employees; 3. 起别名:AS/空格 S 阅读全文
摘要:
MySQL常用函数 1. CONCAT字符拼接 SELECT CONCAT(`first_name`,',',`last_name`,',',`job_id`,',',IFNULL(commission_pct,0)) AS out_put FROM employees; 2. IFNULL字符判空 阅读全文