clear markdown help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1579854 fiddles created (21375 in the last week).

select version();
version()
8.0.20
version()
8.0.20
 hidden batch(es)


CREATE TABLE a (b VARCHAR(10), c INT);
 hidden batch(es)


INSERT INTO a VALUES ('aaa', 999), ('bbb', 888), ('ccc', 777);
 hidden batch(es)


CREATE TABLE x (y VARCHAR(10), z INT);
 hidden batch(es)


INSERT INTO x VALUES ('ccc', 777), ('bbb', 888), ('aaa', 999);
 hidden batch(es)


SELECT * FROM a; -- this *_MIGHT_* be an ASCII sort?
b c
aaa 999
bbb 888
ccc 777
b c
aaa 999
bbb 888
ccc 777
 hidden batch(es)


SELECT * FROM x; -- but this *_ISN'T_*!
y z
ccc 777
bbb 888
aaa 999
y z
ccc 777
bbb 888
aaa 999
 hidden batch(es)