Skip to main content
1 of 4
daisy
  • 1.3k
  • 3
  • 11
  • 16

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