4 format code to be more readable, remove irrelevant memory(RAM) tag, add order-by tag
source | link

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?

Suppose you have the following table and data:

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?

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?

3 tweaked grammar and flow; removed "thank you" per meta.so guidelines
source | link

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

Suppose you have the following schemetable and data:

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"select * from t where k = 10 with no "order by" clause order by clause, how does MySQL sort the records by default  ?

Many thanks !

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 !

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

Suppose you have the following table and data:

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?

2 edited title
| link

default What is the Default order of records , for a "select"SELECT statement in MySQL?

    Tweeted twitter.com/#!/StackDBAs/status/116769146800308224
1
source | link