CREATE DATABASE testtest
-- 员工表
DROP TABLE IF EXISTS users;
CREATE TABLE users(
id INT AUTO_INCREMENT,
NAME VARCHAR(15),
PRIMARY KEY (`id`)
)
-- 薪资表
DROP TABLE IF EXISTS money;
CREATE TABLE money(
id INT AUTO_INCREMENT,
salary VARCHAR(15),
PRIMARY KEY (`id`)
)
-- select users.name,max(salary) from money left join users on money.id=users.id
SELECT COUNT(*) FROM users-- 为null也会取 4
SELECT COUNT(1) FROM users-- 为null也会取 4
-- 都是4 1或者*
-- count的含义是取后面表达式为不是null的 1和*都是常数肯定不为null
SELECT COUNT(NAME) FROM users-- 为null不会取 3