New answers tagged

0 votes
Accepted

MySQL result set changes based on select list

You aren't specifying an order, so the LIMIT picks the first 100 rows in whatever order the query read them. That order depends on which index was chosen by the optimizer, and the table order. The ...
user avatar
1 vote

Limit left join for multiple rows

Another method that works even in ancient versions (eg 5.1) is to mimic the LATERAL join with what I call "poor man's" LATERAL JOIN / OUTER APPLY. This is the LATERAL join we want to mimic: ...
0 votes

on slave repication filter --replicate-do-db= store; give syntax error 1064 on mysql 5.6

That's not available in MySQL 5.6; you edit your my.cnf and restart mysql then it will take effect.
user avatar

Top 50 recent answers are included