SET @avatar_column_exists := ( SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'sys_user' AND COLUMN_NAME = 'avatar' ); SET @avatar_column_sql := IF( @avatar_column_exists = 0, 'ALTER TABLE `sys_user` ADD COLUMN `avatar` VARCHAR(255) NULL COMMENT ''头像'' AFTER `phone`', 'SELECT ''sys_user.avatar already exists''' ); PREPARE avatar_column_stmt FROM @avatar_column_sql; EXECUTE avatar_column_stmt; DEALLOCATE PREPARE avatar_column_stmt;