Generate serial number in mysql query

by

Based on your reasons for not wanting to use user defined variables as wanting to avoid having 2 queries, one for inializing and one to use it you could use the following:

SELECT  @a:=@a+1 serial_number, 
        marks 
FROM    student_marks,
        (SELECT @a:= 0) AS a;

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Delete the entire content of all table in a Database [closed]
  4. MySQL select 10 random rows from 600K rows fast
  5. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Simulate lag function in MySQL
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. Get record counts for all tables in MySQL database
  11. How do I check if a column is empty or null in MySQL?
  12. Use MySQL spatial extensions to select points inside circle
  13. INSERT … ON DUPLICATE KEY (do nothing)
  14. MySQL create stored procedure syntax with delimiter
  15. Mysql Convert Column to row (Pivot table )
  16. Merge two tables in one SQL query and make the date values unique
  17. How to find non-existing data from another Table by JOIN?
  18. MySQL/SQL: Update with correlated subquery from the updated table itself
  19. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  20. Mysql insert random datetime in a given datetime range
  21. Greatest value of multiple columns with column name?
  22. MySQL UPDATE syntax with multiple tables using WHERE clause
  23. Are SELECT type queries the only type that can be nested?
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. Select data from “show tables” MySQL query
  27. What is dynamic SQL?
  28. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  29. Update MySQL with if condition
  30. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

Leave a Comment