I have table tables in MySQL named "temporarytransaction" ans "tbltransaction"
temporarytransaction and tbltransaction has 3 columns named "customer", "service rendered" and "date"
so for example temporarytransaction has 3 values
Nathan | Men's Cut | 2017-09-23
Nathan | Nail Art | 2017-09-23
Nathan | Massage | 2017-09-23
Nathan | Men's Cut,Nail Art,Massage | 2017-09-23
INSERT INTO tbltransaction (customer,service,date) SELECT customer,service,date FROM temporarytransaction;";
You could aggregate the
service values with
INSERT INTO tbltransaction (customer,service,date) SELECT customer, GROUP_CONCAT(service SEPARATOR ','), date FROM temporarytransaction GROUP BY customer, date