mysql 创建注释

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    position VARCHAR(50),
    salary DECIMAL(10, 2)
) COMMENT '员工信息表';

ALTER TABLE employees COMMENT '员工信息表';

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT COMMENT '员工ID',
    name VARCHAR(50) COMMENT '员工姓名',
    position VARCHAR(50) COMMENT '职位',
    salary DECIMAL(10, 2) COMMENT '薪资'
);

ALTER TABLE employees MODIFY COLUMN name VARCHAR(50) COMMENT '员工姓名';

DELIMITER //

CREATE PROCEDURE AddEmployee(
    IN p_name VARCHAR(50),
    IN p_position VARCHAR(50),
    IN p_salary DECIMAL(10, 2)
)
BEGIN
    -- 添加员工信息
    INSERT INTO employees (name, position, salary) VALUES (p_name, p_position, p_salary);
END //

DELIMITER ;

COMMENT ON PROCEDURE AddEmployee IS '添加员工信息的存储过程';