CREATE TABLE New_Table_name AS SELECT * FROM Existing_table_Name; -- Copy datas and structure:
CREATE TABLE new_table AS SELECT * FROM my_table;
-- Copy structure only:
CREATE TABLE new_table AS SELECT * FROM my_table WHERE 1=0;| Code Example |
|---|
| Sql :: sql cheatsheet |
| Sql :: partition by sql server |
| Sql :: como consultar registros duplicados en mysql |
| Sql :: sort by mysql |
| Sql :: mysql count multiple columns in one query |
| Sql :: regenerate assets odoo |
| Sql :: opening xampp mysql in cmd ubuntu |
| Sql :: median mysql |
| Sql :: increment integer in table sql |
| Sql :: enable full text search mysql |
| Sql :: T-SQL - Delete Column |
| Sql :: update trigger |
| Sql :: create temporary table sql |
| Sql :: user_dependencies |
| Sql :: change column data type sql |
| Sql :: create table query in mysql |
| Sql :: what is a query in sql |
| Sql :: alter table primary key postgresql |
| Sql :: alter table add foreign key mariadb example |
| Sql :: nvl in oracle |
| Sql :: oracle nvl2 |
| Sql :: sort order on two columns sql |
| Sql :: run function in sql |
| Sql :: mysql table schema |
| Sql :: pg_pretty_size |
| Sql :: checking data type in sql server |
| Sql :: ERROR 1064 (42000) |
| Sql :: mysql get max value and id |
| Sql :: nth highest salary in sql |
| Sql :: how to duplicate mysql table |