i have two tables name called by order and order_product, both tables have a column same name model, order_product model column have lots of data, but order model empty field.
i want copy model data from table order_product to model table order, how can i do this.?
i tried some SQL query, but the result not like really what i want, its look all field will be duplicate...
INSERT INTO `order` (model) SELECT (model) FROM `order_product`
INSERT INTO order (model)
SELECT model FROM order_product
WHERE 'some field' = (some condition)
INSERT INTO table1 ( column1 )
SELECT col1
FROM table2
this should work for ur question?? kindly let me know what is the desired output u except such that i will update the answer
By seeing ur comments
INSERT INTO table1 ( column1 )
SELECT distinct(col1)
FROM table2
Try to use DISTINCT to eliminate duplicate rows in the SELECT clause like so:
INSERT INTO `order` (model)
SELECT DISTINCT model FROM `order_product`;