Create alias in MySQL?

JockVSJock · 02-23-2006, 08:58 PM

I'm stumped...

How do I create an alias in MySQL?

In Oracle, I do the following:

Code:

tbl.foo t

If I do this in MySQL, I get an error.

gbonvehi · 02-23-2006, 09:12 PM

Maybe you could explain a little bit more, I guess tbl.foo is a column from tbl table, in MySQL you could do: SELECT foo AS t FROM tbl;

Also, there's a programming forum here in LQ, next time you may have more chance of finding a good answer there.

mdarby · 02-23-2006, 09:15 PM

Oracle is has many more features than MySQL. As gbonvehi has posted, this is the only aliases I've ever heard of in MySQL.