Search
 
SCRIPT & CODE EXAMPLE
 

SQL

create new table from existing table with data in sql server

CREATE TABLE florist 
AS SELECT
  *
FROM product
WHERE category = ’flower’;
Comment

create new table from existing table with data in sql server

INSERT INTO new_table
SELECT * FROM old_table
Comment

PREVIOUS NEXT
Code Example
Sql :: table or view does not exist 
Sql :: copy data from one table column to another table column in sql 
Sql :: sql check double value 
Sql :: wordpress delete post revisions older than date "sql" 
Sql :: sql where keyword 
Sql :: wherein mysql 
Sql :: update single sql column 
Sql :: how to get the number of columns in a table in sql 
Sql :: how to sort names in alphabetical order in sql 
Sql :: sql server query all database objects 
Sql :: sql server sleep 
Sql :: mysql regex replace 
Sql :: oracle trigger after logon on schema 
Sql :: limit sqlserver 
Sql :: give a column name to values generated from case statement in sql 
Sql :: create or replace table sql 
Sql :: connect to ssms with python 
Sql :: SQL Server rename foreign key constraint 
Sql :: @sqlresultsetmapping 
Sql :: mysql update column default value CURRENT_TIMESTAMP error 
Sql :: SQL Modify Column in a Table -MySQL 
Sql :: How to convert DateTime to VarChar SQL 
Sql :: postgresql distinct 
Sql :: select into temp table 
Sql :: create index mysql 
Sql :: remove unique key from a table 
Sql :: mysql list tables by size 
Sql :: oracle running queries sql 
Sql :: laravel general error 2006 mysql server has gone away 
Sql :: sql convert float to string 
ADD CONTENT
Topic
Content
Source link
Name
3+3 =