What does a char at the end of a select from statement means?

Question

What does a char at the end of a select from statement means? eg: select *from table1 t <what is the 't' good for? the result is the same as without 't', the query returns all records of table table1.

Answer 1

Syntactically correct this is a shorter form of: SELECT * FROM table1 AS t

AS can be skipped in most SQL flavors.

Answer 2

for shorten your tableName if you want to work with 2 or more tables, sometimes you have to deal with same columnName like "select m.id, t.id from member m, transaction t"

which is can also written "select member.id, transaction.id from member, transaction"

better use m.id than member.id

hope this will help you :)

Answer 3

Now i got it :) thx