How to store Query Result in variable using mysql

by

Surround that select with parentheses.

SET @v1 := (SELECT COUNT(*) FROM user_rating);
SELECT @v1;

More Related Contents:

  1. How can I simulate an array variable in MySQL?
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. What’s the difference between ” = null” and ” IS NULL”?
  8. JOIN queries vs multiple queries
  9. Is the primary key automatically indexed in MySQL?
  10. Storing Data in MySQL as JSON
  11. MySql: MyISAM vs. Inno DB! [closed]
  12. MySQL: Cloning a MySQL database on the same MySql instance
  13. DOs and DONTs for Indexes [closed]
  14. How to change the default port of mysql from 3306 to 3360
  15. How to insert images from database?
  16. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  17. mySQL – Create a New Table Using Data and Columns from Three Tables
  18. When to use MyISAM and InnoDB? [duplicate]
  19. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  20. How to insert a file in MySQL database?
  21. How do I rename a MySQL database (change schema name)?
  22. Foreign key to one of many tables?
  23. Find date range overlaps within the same table, for specific user MySQL
  24. Rename a table in MySQL
  25. What’s the recommended way to connect to MySQL from Go? [closed]
  26. What is the best way to do incremental backups in MySQL?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to Get True Size of MySQL Database?
  29. Put MySQL database under version control?
  30. MySQL: Computed Column

Leave a Comment