Member Avatar for vinaii

CREATE TABLE table2
AS
SELECT * FROM databasename.table1

  • 3 Contributors
  • 2 Replies
  • 69 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Infarction
Member Avatar for Fungus1487

perhaps ask in the correct forum ?

web developement/databases

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

Member Avatar for Infarction

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.