Summary of differences between Oracle and MySQL primary key, index, and paging

The difference between Oracle and MySQL primary key, index and paging, learning Oracle's friends can refer to the following

Difference:

1, primary key, Oracle can not achieve self-increment, MySQL can achieve self-increment.

Oracle new sequence, Seq_user_id.nextval

2. Index:

MySQL index starts from 0 and Oracle starts at 1.

3, pagination,

Mysql:select * from the user order by DESC limit N, M.

Indicates that, starting with the nth data, find the M data altogether.

Oracle:select * from user
Select RowNum A * FROM ((SELECT * from user) a)
SELECT * FROM (select RowNum a.* from (SELECT * from user) a)
where r between N, M.

Indicates that n indicates a query from the nth data, finding the M-bar data.

Summary of differences between Oracle and MySQL primary key, index, and paging