/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 vote124 views1 answer
Get only first row mysql
SQL
15 votes140 views4 answers
Create table if not exists sql
SQL
0 vote143 views1 answer
Sql select min
SQL
6 votes145 views3 answers
Mysql create database utf8
SQL
-1 vote148 views1 answer
Default username and password for oracle 11g
SQL
3 votes143 views1 answer
Locate sql server
SQL
2 votes146 views2 answers
Mysql show table column comments sql
SQL
0 vote142 views1 answer
Declare or use variable in snowflake
SQL
0 vote139 views1 answer
How to install mysql without admin rights
SQL
0 vote140 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL

Share