What is the meaning of the letter 't' in mysql query

Question

SELECT * FROM (SELECT * FROM my_table ORDER by row_id DESC LIMIT 8) t ORDER BY RAND()

I saw this in an answer, What does the 't' mean before ORDER BY?

Possible duplicate of [Nested select statement in SQL Server](http://stackoverflow.com/questions/4629979/nested-select-statement-in-sql-server) — Aurora0001, Feb 26 '17 at 20:48

score 3 · Accepted Answer · answered Feb 26 '17 at 20:46

3

Subqueries need an alias name. In this case it is t.

With this name you can refer to the result of the subquery and its columns.

answered Feb 26 '17 at 20:46

juergen d

1

*With this name you can refer to the result of the subquery and its columns.* Also without it. – shmosel Feb 26 '17 at 20:53

score 0 · Answer 2 · edited Feb 14 '22 at 18:52

0

In order to make the aliasing even clearer, you should use AS and also use accent grave. This re-written query would be easier to read

SELECT * FROM (SELECT * FROM `my_table` ORDER by `row_id` DESC LIMIT 8) AS `t` ORDER BY RAND()

edited Feb 14 '22 at 18:52

Syscall

answered Feb 14 '22 at 18:14

LGE

2 Answers2