MYSQL declaring variables

by

declare variable in MySQL with @ and assign with :=

SET @crs = 0; // declaration
--here your query
@crs := @crs+1 // assignment

References

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. Left Outer Join doesn’t return all rows from my left table?
  3. Are table names in MySQL case sensitive?
  4. MySQL: is a SELECT statement case sensitive?
  5. 1114 (HY000): The table is full
  6. Get table names using SELECT statement in MySQL
  7. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  8. UPDATE multiple tables in MySQL using LEFT JOIN
  9. Can a foreign key reference a non-unique index?
  10. How to raise an error within a MySQL function
  11. What is maximum query size for mysql?
  12. Storing Data in MySQL as JSON
  13. Finding all parents in mysql table with single query (Recursive Query)
  14. How do I retrieve my MySQL username and password?
  15. How to execute a MySQL command from a shell script?
  16. Select most common value from a field in MySQL
  17. How does a MYSQL Self-Join Work?
  18. How to change the default port of mysql from 3306 to 3360
  19. Is it possible to reference one column as multiple foreign keys?
  20. What is the best MySQL collation for German language
  21. quick selection of a random row from a large table in mysql
  22. How to Import Multiple csv files into a MySQL Database
  23. MySQL error #2014 – Commands out of sync; you can’t run this command now
  24. How can we find gaps in sequential numbering in MySQL?
  25. Row to column transformation in MySQL
  26. Data truncated for column?
  27. Find date range overlaps within the same table, for specific user MySQL
  28. mysql select id and name from other table and join query
  29. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  30. Dump only the data with mysqldump without any table information?

Leave a Comment