mysql 警告

CREATE TABLE example (
    id INT,
    name VARCHAR(255)
);

INSERT INTO example (id, name) VALUES (1, 'John Doe');
INSERT INTO example (id, name) VALUES ('2', 'Jane Doe'); -- 这里会发出警告

INSERT INTO example (id, name) VALUES (2, 'Jane Doe'); -- 正确的插入方式

SET GLOBAL sql_mode = 'ONLY_FULL_GROUP_BY';
SELECT name, AVG(score) FROM students GROUP BY name; -- 这里会发出警告

SET GLOBAL sql_mode = '';
SELECT name, AVG(score) FROM students GROUP BY name; -- 关闭 ONLY_FULL_GROUP_BY 模式

CREATE TABLE example (
    id INT PRIMARY KEY,
    data TEXT
) ENGINE=MyISAM;

CREATE TABLE example (
    id INT PRIMARY KEY,
    data TEXT
) ENGINE=InnoDB; -- 使用 InnoDB 存储引擎

CREATE TABLE example (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

SELECT * FROM example WHERE name = 'John Doe'; -- 这里会发出警告

CREATE INDEX idx_name ON example(name);
SELECT * FROM example WHERE name = 'John Doe'; -- 添加索引后，警告消失