/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 vote314 views1 answer
Drush run sql select
SQL
2 votes312 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote319 views1 answer
Sql script get all stored procedures from database
SQL
0 vote304 views1 answer
How to close external sql connection in laravel
SQL
0 vote290 views1 answer
Create domain sql
SQL
0 vote307 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
-1 vote328 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote334 views1 answer
How to run mysql on terminal mac
SQL
0 vote304 views1 answer
Mysql workbench indent formatting
SQL
-1 vote321 views1 answer
Concat two columns in sql server
SQL

Share