/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 vote171 views1 answer
View acl table oracle
SQL
0 vote185 views1 answer
Mysql export search results
SQL
5 votes223 views2 answers
Postgresql insert select
SQL
0 vote220 views1 answer
Get null value in sql
SQL
0 vote189 views1 answer
Sql find gaps in date ranges
SQL
0 vote183 views1 answer
Split string by comma in sql server
SQL
0 vote174 views1 answer
Declare date variable sql
SQL
0 vote184 views1 answer
Why mysql is used?
SQL
0 vote218 views1 answer
View to table
SQL
0 vote291 views1 answer
Mysql failed to login as root@localhost
SQL

Share