/SQL/Create table from existing table in sql

Create table from existing table in sql

Create table from existing table in sql

//this will create new Empty table

CREATE TABLE TableName AS (SELECT * FROM ExistingTable WHERE 1=2);

1

Create new table from existing table with data in sql server

CREATE TABLE florist 
AS SELECT
  *
FROM product
WHERE category = ’flower’;

0

Source: learnsql.com

Create new table from existing table with data in sql server

INSERT INTO new_table
SELECT * FROM old_table

0

Source: stackoverflow.com

Similar codes

0 vote140 views1 answer
Longtext sql
SQL
1 vote188 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote145 views1 answer
Oracle apex run 404
SQL
0 vote129 views1 answer
Mysql workbench indent formatting
SQL
1 vote141 views1 answer
How to subtract from the value of a table in sql
SQL
3 votes143 views1 answer
How to find names includes in sql
SQL
10 votes137 views5 answers
Create table mysql query
SQL
0 vote144 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
18 votes136 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote178 views2 answers
Sql unique
SQL

Share