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

111 votes

3 answers

172747 views

                          Suppose you have the following table and data:

    create table t (
        k int,
        v int,
        index k(k)
        ) engine=memory;

    insert into t (k, v)
    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?
                        

Asked by daisy (1338 rep)

Sep 22, 2011, 04:22 AM
Last activity: Jun 11, 2021, 03:19 PM

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

Related Questions