Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Write a query to create an empty table from an existing table?

CREATE TABLE new_table
  AS (SELECT *
      FROM old_table WHERE 1=2);
Source by www.techonthenet.com #
 
PREVIOUS NEXT
Tagged: #Write #query #create #empty #table #existing
ADD COMMENT
Topic
Name
7+3 =