适用SQL语句汇总
1.重复记录操作:http://www.cnblogs.com/caotang/archive/2011/01/18/1937932.html
2.替换更新:update Produce set produce.Cell_ID=replace(Cell_ID,',',' ') where Produce.Cell_ID like'%,%'
复制表(只复制结构) | select * into b from a where 1<>1 |
拷贝表(复制数据) | insert into b(a, b, c) select d,e,f from b |
做了就有可能!