ALTER TABLE registration_stock_lce ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY FIRST;

-- 创建临时表（复制原表结构）
CREATE TABLE registration_stock_lce_new LIKE registration_stock_lce;
-- 添加自增主键
ALTER TABLE registration_stock_lce_new ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY FIRST;
-- 导入数据
INSERT INTO registration_stock_lce_new SELECT NULL,* FROM registration_stock_lce;
-- 替换原表
RENAME TABLE registration_stock_lce TO registration_stock_lce_old, registration_stock_lce_new TO registration_stock_lce;
-- 删除旧表（确认数据无误后）
DROP TABLE registration_stock_lce_old;