By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.36 |
CREATE TABLE users
(id INT,
name VARCHAR(50));
INSERT INTO users VALUES
(1,'sdgfafa'),
(8,'jhkjhlhjl'),
(5,'erertrz'),
(7,'cvcvnvcn'),
(2,'qweqwe'),
(9,'iopoipi');
CREATE temporary TABLE aa AS (SELECT * FROM users limit 3);
CREATE temporary TABLE bb AS (SELECT * FROM users limit 3,3);
Records: 6 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
SELECT * FROM users
| id | name |
|---|---|
| 1 | sdgfafa |
| 8 | jhkjhlhjl |
| 5 | erertrz |
| 7 | cvcvnvcn |
| 2 | qweqwe |
| 9 | iopoipi |
SELECT * FROM aa;
SELECT * FROM bb;
| id | name |
|---|---|
| 1 | sdgfafa |
| 8 | jhkjhlhjl |
| 5 | erertrz |
| id | name |
|---|---|
| 7 | cvcvnvcn |
| 2 | qweqwe |
| 9 | iopoipi |
select a.id, b.name from aa as a, bb as b group by a.id
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiddle.b.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by