clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798776 fiddles created (41855 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)