Jul 28, 2010 #1 dagoat10 Programmer Jun 3, 2010 74 US is there a way to query all the tables in mysql database. Rather than just listing all the tables in the query Something like: SELECT * from *.*; I have a feeling there is a way but i can't remember
is there a way to query all the tables in mysql database. Rather than just listing all the tables in the query Something like: SELECT * from *.*; I have a feeling there is a way but i can't remember
Jul 28, 2010 #2 r937 Technical User Jun 30, 2002 8,847 CA there is no easy way to do what you're asking to begin with, you don't really want to retrieve all possible columns for all possible rows, right? that would be like dumping the entire contents of the database can you be more spcific about what you want? r937.com | rudy.ca Buy my new book Simply SQL from Amazon Upvote 0 Downvote
there is no easy way to do what you're asking to begin with, you don't really want to retrieve all possible columns for all possible rows, right? that would be like dumping the entire contents of the database can you be more spcific about what you want? r937.com | rudy.ca Buy my new book Simply SQL from Amazon
Jul 28, 2010 Thread starter #3 dagoat10 Programmer Jun 3, 2010 74 US True it's more like one of these: Select Name from *.*; Or Select Name from (like=%); Upvote 0 Downvote
Jul 28, 2010 Thread starter #4 dagoat10 Programmer Jun 3, 2010 74 US Cause I have 40 tables with the same column that I want to retrive Upvote 0 Downvote
Jul 28, 2010 #5 r937 Technical User Jun 30, 2002 8,847 CA I have 40 tables with the same column Click to expand... the bad news is that you need to write a separate SELECT statement for each table the good news is that you can combine them with UNION why do you have 40 tables with the same column? i have the feeling they should maybe be just one table r937.com | rudy.ca Buy my new book Simply SQL from Amazon Upvote 0 Downvote
I have 40 tables with the same column Click to expand... the bad news is that you need to write a separate SELECT statement for each table the good news is that you can combine them with UNION why do you have 40 tables with the same column? i have the feeling they should maybe be just one table r937.com | rudy.ca Buy my new book Simply SQL from Amazon