MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

@@version

5.6.47

create table t (a int);
insert into t (a) values (1), (2) ;
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

select 5 as five, t.* from t ;

five
a

5
1

5
2

select *, 5 as five from t ;

a
five

1
5

2
5

select t.*, 5 as five from t ;

a
five

1
5

2
5

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