MySQL WHERE：如何写“！=”或“不等于”

MySQL WHERE：如何写“！=”或“不等于”？

sql
SELECT * FROM employees WHERE age != 30;

sql
SELECT * FROM products WHERE price <> 10.99;

sql
-- 创建一个名为"employees"的表
CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);
-- 向"employees"表插入一些记录
INSERT INTO employees (id, name, age) VALUES
(1, 'Alice', 25),
(2, 'Bob', 30),
(3, 'Charlie', 35),
(4, 'David', 40);
-- 使用"!="运算符过滤不等于30的记录
SELECT * FROM employees WHERE age != 30;
-- 使用"<>"运算符过滤不等于10.99的记录
SELECT * FROM products WHERE price <> 10.99;