mysql field name from variable

by

If the string is in your external application (like PHP), sure, just construct the MySQL statement.

If the string is inside a MySQL table, you can’t. MySQL has no eval() or such function. The following is impossible:

Suppose you have a table queries with a field columnname that refers to one of the column names in the table mytable. There might be additional columns in queries that allow you to select the columnname you want.

INSERT INTO queries  (columname) VALUES ("name")
SELECT (select columnname from queries) from mytable

You can however work with PREPARED STATEMENTS. Be aware this is very hacky.

SELECT columnname from queries into @colname;
SET @table="mytable";
SET @s = CONCAT('SELECT ',@colname,' FROM ', @table);

PREPARE stmt FROM @s;
EXECUTE stmt;

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. How can I make SQL case sensitive string comparison on MySQL?
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  5. Count the occurrences of DISTINCT values
  6. Column count doesn’t match value count at row 1
  7. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  8. How do I modify a MySQL column to allow NULL?
  9. Connect to mysql in a docker container from the host
  10. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  11. MySQL WHERE IN ()
  12. Using MySql with Entity Framework 4 and the Code-First Development CTP
  13. MySQL error 1241: Operand should contain 1 column(s)
  14. MySQL treats ÅÄÖ as AAO?
  15. MySQL – Supertype/Subtype design
  16. How can write queries in MySQL that can parse JSON data in a column?
  17. Mysql: Order by like?
  18. MySQL Time Zones
  19. How to use django models with foreign keys in different DBs?
  20. How to change MySQL column definition?
  21. How can I undo a mysql statement that I just executed?
  22. Continue SQL query even on errors in MySQL workbench
  23. Which DATATYPE is better to use TEXT or VARCHAR?
  24. How to generate a UUIDv4 in MySQL?
  25. is php sort better than mysql “order by”?
  26. How can “set timestamp” be a slow query?
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. MySQL cartesian product between two SELECT statements
  29. Sum until certain point – MySql
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment