mysql数据库表字段批量增加备注

ALTER TABLE your_table_name MODIFY column_name datatype COMMENT 'Your comment here';

ALTER TABLE users MODIFY email VARCHAR(255) COMMENT 'User email address';

DELIMITER //
CREATE PROCEDURE AddComments()
BEGIN
  DECLARE done INT DEFAULT FALSE;
  DECLARE col_name VARCHAR(255);
  DECLARE col_comment VARCHAR(255);
  DECLARE cur CURSOR FOR SELECT COLUMN_NAME, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name' AND COLUMN_COMMENT IS NULL;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

  OPEN cur;
  read_loop: LOOP
    FETCH cur INTO col_name, col_comment;
    IF done THEN
      LEAVE read_loop;
    END IF;
    SET @sql = CONCAT('ALTER TABLE your_table_name MODIFY ', col_name, ' COMMENT ''', col_comment, '''');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
  END LOOP;
  CLOSE cur;
END //
DELIMITER ;

CALL AddComments();