oracle语句转mysql

SELECT * FROM (
    SELECT a.*, ROWNUM rnum FROM (
        SELECT * FROM your_table ORDER BY some_column
    ) a WHERE ROWNUM <= end_row
) WHERE rnum >= start_row;

SELECT * FROM your_table ORDER BY some_column LIMIT start_row, end_row - start_row + 1;

SELECT 'Hello, ' || name AS greeting FROM users;

SELECT CONCAT('Hello, ', name) AS greeting FROM users;

CREATE TABLE example (
    id NUMBER,
    date_column DATE
);

CREATE TABLE example (
    id INT,
    date_column DATE
);

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

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

SELECT 
    employee_id, 
    TO_CHAR(hire_date, 'YYYY-MM-DD') AS hire_date, 
    NVL(salary, 0) AS salary 
FROM employees 
WHERE department_id = 10 
ORDER BY hire_date;

SELECT 
    employee_id, 
    DATE_FORMAT(hire_date, '%Y-%m-%d') AS hire_date, 
    IFNULL(salary, 0) AS salary 
FROM employees 
WHERE department_id = 10 
ORDER BY hire_date;