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
Infarction
503
Posting Virtuoso
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.