The role of dialect in mysql

This article mainly introduces the role of dialect in mysql, the article is very detailed, has a certain reference value, interested friends must read it!

Apart from the database, what is the dialect in life? Dialect is the characteristic language of one place, which is different from other places. Only you can understand it in this small place, and it is another dialect out of this place.

The same is true of database dialects. MySQL is a dialect, Oracle is also a dialect, and MSSQL is also a dialect. Under the premise of following the SQL specification, they all have their own extended characteristics.

In the case of paging, MySQL uses the keyword limit, while Oracle uses ROWNUM,MSSQL, which may be another way of paging.

# mysqlselect * from t_user limit 10 witch # oracleselect * from t_user t where ROWNUM