Dynamic table name at sql statement

by

The usage of dynamic table names within the query is best with Prepared Staments,
also in mysql for concatenation the function is concat

SET @id := '47';
SET @table := concat(@id,'_2013_2014_voucher');
set @qry1:= concat('select * from ',@table);
prepare stmt from @qry1 ;
execute stmt ;

You can do it for the delete query as well

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. How to define a custom ORDER BY order in mySQL
  6. MySQL update table based on another tables value
  7. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  8. How to get the number of days of difference between two dates on MySQL?
  9. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  10. conditional join in mysql
  11. a count for each join – optimisation
  12. How to grant all privileges to root user in MySQL 8.0
  13. MySQL Group by SUM
  14. TRIGGERs that cause INSERTs to fail? Possible?
  15. Search for all occurrences of a string in a mysql database [duplicate]
  16. MySQL Aggregate Functions without GROUP BY clause
  17. Count days between two dates, excluding weekends (MySQL only)
  18. How to insert values in table with foreign key using MySQL?
  19. MySQL: How do I join same table multiple times?
  20. How to save MySQL query output to excel or .txt file? [duplicate]
  21. MySQL: Set user variable from result of query
  22. Is there a naming convention for MySQL?
  23. Is there any performance gain in indexing a boolean field?
  24. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  25. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  26. How to swap values of two rows in MySQL without violating unique constraint?
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. Storing images in MySQL [closed]
  29. Would it help to add index to BIGINT column in MySQL?
  30. Count duplicates records in Mysql table?

Leave a Comment