Skip to main content
2 of 4
edited title
RolandoMySQLDBA
  • 184.4k
  • 33
  • 323
  • 531

What is the Default order of records for a SELECT statement in MySQL?

Suppose the following scheme:

create table t(k int, v int,index k(k)) engine=memory; 
insert into t values(10, 1), (10, 2), (10, 3)

When issuing "select * from t where k = 10" with no "order by" clause , how does MySQL sort the records by default ?

Many thanks !

daisy
  • 1.3k
  • 3
  • 11
  • 16