/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 vote147 views1 answer
Mariadb cast to int
SQL
7 votes142 views6 answers
Nth highest salary in sql
SQL
2 votes144 views1 answer
Import database in mysql command line xampp
SQL
0 vote220 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote164 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote135 views1 answer
Mysql sql select one day before
SQL
0 vote140 views1 answer
Flask sqlalchemy update row
SQL
0 vote137 views2 answers
Mysql unique two columns
SQL
0 vote158 views1 answer
Mysql date equals to current_date plus days
SQL
21 votes118 views7 answers
Table drop if exist sql server
SQL

Share