E
E
Enniack2016-02-19 15:43:25
MySQL
Enniack, 2016-02-19 15:43:25

What does 't' mean in a query?

CDbCommand failed to execute SQL query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'where clause'. The SQL statement executed was: SELECT * FROM `eps_gallery` `t` WHERE type = 1 ORDER BY id DESC
What does 't' mean?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Peter, 2016-02-19
@Enniack

This is a table alias.

SELECT t.* FROM eps_gallery t WHERE t.type = 1 ORDER BY t.id DESC

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question