以下是MySQL中基本的增删改查语句:
插入数据
插入数据可以使用INSERT INTO
语句,示例:
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
示例:
INSERT INTO students (name, gender, age)
VALUES ('Lucy', 'Female', 20);
查询数据
查询数据使用SELECT
语句,示例:
SELECT column1, column2, ...
FROM table_name
WHERE condition;
示例:
SELECT * FROM students WHERE gender = 'Female';
更新数据
更新数据使用UPDATE
语句,示例:
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
示例:
UPDATE students SET age = 21 WHERE name = 'Lucy';
删除数据
删除数据使用DELETE FROM
语句,示例:
DELETE FROM table_name
WHERE condition;
示例:
DELETE FROM students WHERE age > 25;
以上是MySQL中基本的增删改查语句,需要注意语句的语法和条件的正确性。