Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql copy table with new name


        
            
        
     CREATE TABLE IF NOT EXISTS new_table LIKE existing_table;

INSERT new_table
SELECT * FROM existing_table;
Comment

copy a table mysql

CREATE TABLE employees_clone LIKE employees;
Comment

PREVIOUS NEXT
Code Example
Sql :: his is incompatible with sql_mode=only_full_group_by 
Sql :: oracle list functions 
Sql :: spark sql concatenate string and int 
Sql :: sql query to make a existing column auto increment 
Sql :: see mysql users ubuntu 
Sql :: search stored procedures by name 
Sql :: oracle all_source package body 
Sql :: how to set an already made tables auto increment in mysql 
Sql :: mysql modify foreign key 
Sql :: get the list of all tables in sql server 
Sql :: update with inner join 
Sql :: oracle start job 
Sql :: create table if not exist in sqlite 
Sql :: update column name and datatype in sql 
Sql :: best configuration for display table in sqlplus 
Sql :: mysql concat two columns laravel eloquent 
Sql :: oracle compile schema 
Sql :: group_concat max length mysql 
Sql :: cannot pip install mysqlclient 
Sql :: mysql get last id 
Sql :: count mysql server db tables 
Sql :: day of the week sqlite 
Sql :: postgres killing connections on db 
Sql :: starting mysql service from mac 
Sql :: mysql bidirectional composite primary key 
Sql :: create procedure with encryption 
Sql :: oracle get nls settings 
Sql :: sql get table last modified time 
Sql :: What is the compatibility level of a SQL database 
Sql :: create table mysql example auto_increment 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =