How to make an insert with a select statement in MySQL

Are you importing data from one table to another, from one big complex strange query select statement to make something else work try this simple way:

“INSERT INTO zip_codes(code,city_id) SELECT t.zip_code,(select from cities c where and as ‘vikiyagroup’ from temporal t inner join states s on order by”;

And yes it worked with thousands of records!

Happy coding!