首页 > 解决方案 > 为什么在我的 sql 中这是错误的?它说检查版本

问题描述

错误说我必须检查mysql的版本,但我检查了它是正确的..

    CREATE TABLE Persons (
    person_id int,
    first_name varchar(20),
    last_name varchar(20),
    address varchar(20),
    city varchar(20)
);


INSERT INTO Persons VALUES (1, "keene", "basence", "escarlata", "makati");
INSERT INTO Persons VALUES (2, "kyle", "basence", "escarlata", "makati");
INSERT INTO Persons VALUES (3, "kieffer", "basence", "escarlata", "makati");

SELECT * FROM Persons;

DELETE FROM Persons WHERE person_id = 1;

UPDATE Persons SET address = "comembo" WHERE person_id = 1;

SELECT person_id, first_name FROM Persons GROUP BY person_id DESC; -- this is the wrong one 

标签: mysql

解决方案


推荐阅读