SELECT INTO Variable in MySQL DECLARE causes syntax error?

by

I ran into this same issue, but I think I know what’s causing the confusion. If you use MySQL Query Analyzer, you can do this just fine:

SELECT myvalue 
INTO @myvar 
FROM mytable 
WHERE anothervalue = 1;

However, if you put that same query in MySQL Workbench, it will throw a syntax error. I don’t know why they would be different, but they are.

To work around the problem in MySQL Workbench, you can rewrite the query like this:

SELECT @myvar:=myvalue
FROM mytable
WHERE anothervalue = 1;

More Related Contents:

  1. How can I select data from different tables?
  2. Select all columns except one in MySQL?
  3. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. MySQL error code: 1175 during UPDATE in MySQL Workbench
  6. Ordering by specific field value first
  7. What is MySQL row order for “SELECT * FROM table_name;”?
  8. Select mysql query between date?
  9. How to connect mysql workbench to running mysql inside docker?
  10. mysql select from n last rows
  11. MySQL select with CONCAT condition
  12. Sort by order of values in a select statement “in” clause in mysql
  13. MySQL – How to select data by string length
  14. Mysql select distinct
  15. Return a default value if single row is not found
  16. How to select one row randomly taking into account a weight?
  17. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  18. MySQL – Select the last inserted row easiest way
  19. Sum results of a few queries and then find top 5 in SQL
  20. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  21. Syntax error when using except in a query
  22. MySQL Errno 150
  23. Using index, using temporary, using filesort – how to fix this?
  24. MySQL : retrieve a large select by chunks
  25. MySQL – insert data from another table merged with constants
  26. MySQL Error: #1142 – SELECT command denied to user
  27. How to SELECT by MAX(date)?
  28. MySQL matching unicode characters with ascii version
  29. MySQL cartesian product between two SELECT statements
  30. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’

Leave a Comment