CREATE TABLE table2
AS
SELECT * FROM databasename.table1

perhaps ask in the correct forum ?

web developement/databases

as the people that may know your answer may not look here.

Why not run the query and see what it does? My guess would be that it basically makes a copy of table1 and saves it to table2.

commented: riiiiiiiiiiiiiiiight! +3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.