CODEWITHSUNDEEP
mysql
Jim
Jim

Reputation: 1

Can "AS" be skipped in MySQL queries?

Instead of table1 AS t1, can I write table1 t1 ?

So, is JOIN table1 t1 on table2.userid = t1.userid?

Thanks

Upvotes: 0

Views: 39

Answers (1)

Thorsten Kettner
Thorsten Kettner

Reputation: 94894

Yes. You could have looked that up yourself.

http://dev.mysql.com/doc/refman/5.7/en/select.html

tbl_name [[AS] alias] [index_hint]

Upvotes: 1

Related Questions