By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798988 fiddles created (41856 in the last week).
select @@version;
@@version
5.6.47
…
hidden batch(es)
create table t (a int);
✓
hidden batch(es)
insert into t (a) values (1), (2) ;
✓
hidden batch(es)
select 5 as five, * from t ;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from t' at line 1
hidden batch(es)
select 5 as five, t.* from t ;
five
a
5
1
5
2
…
hidden batch(es)
select *, 5 as five from t ;
a
five
1
5
2
5
…
hidden batch(es)
select t.*, 5 as five from t ;
a
five
1
5
2
5
…
hidden batch(es)
SELECT 5 as a, a, a, 7 as a, t.* FROM t ; -- works just fine
