/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 vote267 views2 answers
Starting mysql service from mac
SQL
0 vote303 views1 answer
How to move a columns location in mysql
SQL
0 vote327 views1 answer
Sql doesn't contain
SQL
1 vote276 views1 answer
Moodle query item quiz
SQL
2 votes281 views1 answer
Mysql trigger after update
SQL
0 vote297 views1 answer
Primary key multiple
SQL
0 vote282 views1 answer
How to to get time in sql
SQL
0 vote275 views1 answer
How to insert multiple rows in mysql using laravel
SQL
4 votes273 views3 answers
NOT NULL SQL
SQL
0 vote269 views1 answer
How to get initials in sql
SQL

Share