A
A
AnEthereal2020-08-31 16:53:17
SQL
AnEthereal, 2020-08-31 16:53:17

What does the t mean after a table name in an SQL query?

SELECT t.* FROM obraz.DATAZ t
       WHERE ........

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vladimir, 2020-08-31
@FFOX

Alias, a short synonym for the table name
so as not to write long table names before the name of each field, but there can be many tables in a query,
and it is more convenient to use aliases rather than physical table names

A
Alexander Latukhin, 2020-08-31
@aleksandr97

The character t is an alias for your table name, you can use it as a table abbreviation
Aliases in MySQL

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question