Home >>
MySql >> How to copy data from one table to another table in MySql
How to copy data from one table to another table in MySql
INSERT INTO `stock_closing`(`article`,`color`,`mrp`,`size`,`packing`,`quantity`,`pair`) SELECT `article`,`color`,`mrp`,`size`,`packing`,SUM(`quantity`) AS `quantity`,SUM(`pair`) AS `pair`
FROM `stock_incoming` GROUP BY `article`,`color`,`size`
Post Your Comment