db2 mysql建表语句

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    hire_date DATE NOT NULL,
    salary DECIMAL(10, 2) NOT NULL
);

CREATE TABLE employees (
    id INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    hire_date DATE NOT NULL,
    salary DECIMAL(10, 2) NOT NULL,
    PRIMARY KEY (id)
);

-- MySQL
ALTER TABLE employees RENAME COLUMN email TO email_old;

-- DB2
ALTER TABLE employees RENAME COLUMN email TO email_old;

-- MySQL
ALTER TABLE employees MODIFY salary DECIMAL(12, 2);

-- DB2
ALTER TABLE employees ALTER COLUMN salary SET DATA TYPE DECIMAL(12, 2);