m0_65225122的博客

原创 mysql表添加字段并且放到最开始的位置以及删除字段（做个记录）

SELECT * FROM sheet1select * FROM sheet1 WHERE `姓名`='韩三' GROUP BY `详细地址`ALTER TABLE sheet1 ADD id int primary key not null auto_increment FIRST;alter table sheet1 drop column id;SELECT COUNT(*) FROM sheet1