SQL: What is the default Order By of queries?

by

There is no such order present. Taken from http://forums.mysql.com/read.php?21,239471,239688#msg-239688

  • Do not depend on order when ORDER BY is missing.

  • Always specify ORDER BY if you want a particular order — in some situations the engine can eliminate the ORDER BY because of how it
    does some other step.

  • GROUP BY forces ORDER BY. (This is a violation of the standard. It can be avoided by using ORDER BY NULL.)

SELECT * FROM tbl — this will do a “table scan”. If the table has
never had any DELETEs/REPLACEs/UPDATEs, the records will happen to be
in the insertion order, hence what you observed.

If you had done the same statement with an InnoDB table, they would
have been delivered in PRIMARY KEY order, not INSERT order. Again,
this is an artifact of the underlying implementation, not something to
depend on.

More Related Contents:

  1. Syntax error due to using a reserved word as a table or column name in MySQL
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. Change MySQL default character set to UTF-8 in my.cnf?
  4. MySQL update table based on another tables value
  5. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  6. MySQL offset infinite rows
  7. On Duplicate Key Update same as insert
  8. What’s the difference between ” = null” and ” IS NULL”?
  9. SQL: Repeat a result row multiple times, and number the rows
  10. Select the 3 most recent records where the values of one column are distinct
  11. What MySQL data type should be used for Latitude/Longitude with 8 decimal places?
  12. Setting up foreign keys in phpMyAdmin?
  13. How to get an age from a D.O.B field in MySQL?
  14. Mysql count instances of substring, then order by
  15. Importing a CSV to MySQL with different date format
  16. How to reset the root password in MySQL 8.0.11?
  17. What characters have to be escaped to prevent (My)SQL injections?
  18. Is there any performance gain in indexing a boolean field?
  19. Using version control (Git) on a MySQL database
  20. mySQL – Create a New Table Using Data and Columns from Three Tables
  21. How to create dummy variable columns for thousands of categories in Google BigQuery?
  22. Most efficient way to store IP Address in MySQL [duplicate]
  23. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  24. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  25. What is the best way to do incremental backups in MySQL?
  26. Storing images in MySQL [closed]
  27. Would it help to add index to BIGINT column in MySQL?
  28. How can I stop a MySQL query if it takes too long?
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. django cannot connect mysql in docker-compose

Leave a Comment