/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 vote133 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote113 views1 answer
Zerar auto increment mysql
SQL
0 vote133 views1 answer
How to find table lock and row lock in mysql
SQL
5 votes81 views1 answer
Postgres upsert
SQL
1 vote133 views1 answer
Oracle grant select on schema
SQL
4 votes123 views2 answers
Sql offset
SQL
1 vote123 views1 answer
Second last highest id in sql
SQL
0 vote129 views1 answer
Ubuntu stop mysql from starting on boot
SQL
6 votes110 views3 answers
Mysql first day of year
SQL
2 votes111 views1 answer
Sqlplus clear screen
SQL

Share