How to select from MySQL where Table name is Variable

by

You’d have to do this with a prepared statement. Something like:

SET @s = CONCAT('select * from ', @Cat, ' where ID = ', @ID_1); 

PREPARE stmt1 FROM @s; 
EXECUTE stmt1; 
DEALLOCATE PREPARE stmt1;

More Related Contents:

  1. How can I simulate an array variable in MySQL?
  2. How to store Query Result in variable using mysql
  3. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  4. Syntax error due to using a reserved word as a table or column name in MySQL
  5. Change MySQL default character set to UTF-8 in my.cnf?
  6. MySQL update table based on another tables value
  7. MySQL offset infinite rows
  8. On Duplicate Key Update same as insert
  9. Ordering by the order of values in a SQL IN() clause
  10. LAST_INSERT_ID() MySQL
  11. SQL Selecting from two Tables with inner join and limit [duplicate]
  12. How to export and import a .sql file from command line with options? [duplicate]
  13. SQL: Repeat a result row multiple times, and number the rows
  14. Select the 3 most recent records where the values of one column are distinct
  15. What MySQL data type should be used for Latitude/Longitude with 8 decimal places?
  16. Setting up foreign keys in phpMyAdmin?
  17. How to get an age from a D.O.B field in MySQL?
  18. Mysql count instances of substring, then order by
  19. Importing a CSV to MySQL with different date format
  20. Using version control (Git) on a MySQL database
  21. mySQL – Create a New Table Using Data and Columns from Three Tables
  22. use a variable for table name in mysql sproc
  23. How to create dummy variable columns for thousands of categories in Google BigQuery?
  24. Most efficient way to store IP Address in MySQL [duplicate]
  25. What is the best way to do incremental backups in MySQL?
  26. Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app
  27. MySQL: Setting sql_mode permanently
  28. MySQL: how to index an “OR” clause
  29. Is it possible to count two columns in the same query
  30. mySQL regex in the where clause

Leave a Comment