multiple auto increment in mysql

by

You can leave your sort column equal to NULL by default. The only thing you need is a little smarter query. For instance:

select * 
from something
order by ifnull(sort, id)

More Related Contents:

  1. Can you add an if statement in ORDER BY?
  2. Prevent InnoDB auto increment ON DUPLICATE KEY
  3. PHP mySQL – Insert new record into table with auto-increment on primary key
  4. How to sort MYSQL fulltext search results by relevancy
  5. timestamp within a form [closed]
  6. how to select only one value sql
  7. Save the data into a database and return another value from database using PHP
  8. Math Symbol From Mysql To HTML? [closed]
  9. How to store repeating dates keeping in mind Daylight Savings Time
  10. Using a .php file to generate a MySQL dump
  11. Insert Blobs in MySql databases with php
  12. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [duplicate]
  13. PDO with INSERT INTO through prepared statements [closed]
  14. How do I execute PHP that is stored in a MySQL database?
  15. Error while sending QUERY packet
  16. How to sort rows of HTML table that are called from MySQL
  17. PDO fetch one column from table into 1-dimensional array
  18. php file upload, how to restrict file upload type
  19. Get all mysql selected rows into an array
  20. Select from mysql table WHERE field=’$array’?
  21. Sort multidimensional array by date column, then use other column values if dates are the same
  22. MySQL error when inserting data containing apostrophes (single quotes)?
  23. php password_verify() hash and pass won’t match
  24. MySQL query using an array [duplicate]
  25. Using MySQL’s TIMESTAMP vs storing timestamps directly
  26. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  27. array_push() vs. $array[] = …. Which is fastest? [duplicate]
  28. using the browser prompt to download a file
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. Save array in mysql database

Leave a Comment