How can I simulate an array variable in MySQL?

by

Well, I’ve been using temporary tables instead of array variables. Not the greatest solution, but it works.

Note that you don’t need to formally define their fields, just create them using a SELECT:

DROP TEMPORARY TABLE IF EXISTS my_temp_table;
CREATE TEMPORARY TABLE my_temp_table
    SELECT first_name FROM people WHERE last_name="Smith";

(See also Create temporary table from select statement without using Create Table.)

More Related Contents:

  1. How to store Query Result in variable using mysql
  2. MySQL: @variable vs. variable. What’s the difference?
  3. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  4. Create table variable in MySQL
  5. Using variable in a LIMIT clause in MySQL
  6. Pass array to MySQL stored routine
  7. How to select from MySQL where Table name is Variable
  8. Getting around MySQL “Can’t reopen table” error
  9. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  10. Is MySQL Temporary table a shared resource?
  11. How to pass a variable to a IN clause?
  12. How can i write in NodeJS with MongoDB the following MySQL Select?
  13. Which MySQL data type to use for storing boolean values
  14. How to check if mysql database exists
  15. SELECT * FROM multiple tables. MySQL
  16. Can a foreign key reference a non-unique index?
  17. Storing Data in MySQL as JSON
  18. How to set a maximum execution time for a mysql query?
  19. SQL keys, MUL vs PRI vs UNI
  20. How to move columns in a MySQL table?
  21. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  22. What is the best MySQL collation for German language
  23. quick selection of a random row from a large table in mysql
  24. How can we find gaps in sequential numbering in MySQL?
  25. Optimization of MySQL search using “like” and wildcards
  26. Why do I need “OR NULL” in MySQL when counting rows with a condition
  27. Find date range overlaps within the same table, for specific user MySQL
  28. MySQL on delete cascade. Test Example
  29. How do I alter a mysql table column defaults?
  30. How to count date difference excluding weekend and holidays in MySQL

Leave a Comment