clear markdown feedback
clear markdown feedback
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
a a a a a
5 1 1 7 1
5 2 2 7 2
 hidden batch(es)