CREATE TABLE table2
AS
SELECT * FROM databasename.table1
vinaii
0
Newbie Poster
Recommended Answers
Jump to PostWhy 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.
All 2 Replies
Fungus1487
55
Posting Pro in Training
perhaps ask in the correct forum ?
web developement/databases
as the people that may know your answer may not look here.
Infarction
503
Posting Virtuoso
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.
Sulley's Boo
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.