oracle sql转mysql

-- Oracle
CREATE TABLE example (
    id NUMBER,
    amount NUMBER(10, 2)
);

-- MySQL
CREATE TABLE example (
    id INT,
    amount DECIMAL(10, 2)
);

-- Oracle
SELECT NVL(column, 'default_value') FROM table;

-- MySQL
SELECT IFNULL(column, 'default_value') FROM table;

-- Oracle
SELECT * FROM (SELECT a.*, ROWNUM rnum FROM (SELECT * FROM table) a WHERE ROWNUM <= end_row) WHERE rnum >= start_row;

-- MySQL
SELECT * FROM table LIMIT start_row, end_row - start_row + 1;

-- Oracle
CREATE OR REPLACE PROCEDURE example_proc (p_id IN NUMBER)
IS
BEGIN
    SELECT * FROM table WHERE id = p_id;
END;

-- MySQL
DELIMITER //
CREATE PROCEDURE example_proc (IN p_id INT)
BEGIN
    SELECT * FROM table WHERE id = p_id;
END //
DELIMITER ;