MySQL Forums
Forum List  »  Newbie

SQL SELECT * FROM
Posted by: Meh Blah
Date: May 18, 2014 06:14PM

Well, first of all, good morning everyone.

Now, i got a quite problem, i started veery short ago, and i got a problem when doing a Query.

How can i return all the tables?

Eg:
SELECT City FROM *;

This will give an error, since * isnt a table, but how could i represent this, and loop all existing tables? Since i'm creating then based on a variable wich depends on the current user of the database, wich i cannot retrive.

Greetings

Options: ReplyQuote


Subject
Written By
Posted
SQL SELECT * FROM
May 18, 2014 06:14PM
May 19, 2014 06:14AM
May 19, 2014 04:11PM
May 19, 2014 10:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.