Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to insert same table data using mysql query

Use INSERT ... SELECT:

insert into your_table (c1, c2, ...)
select c1, c2, ...
from your_table
where id = 1
Comment

PREVIOUS NEXT
Code Example
Sql :: sql where multiple values 
Sql :: postgres sql alter table delete row 
Sql :: sql limit clause 
Sql :: how to assign custom id in mysql 
Sql :: get month from date sql server 
Sql :: how to find columns with null values in sql 
Sql :: wp sql to update admin email 
Sql :: Pl/Sql table based record 
Sql :: query to get all primary keys and foreign key 
Sql :: mysql not 
Sql :: description query in sql 
Sql :: create a database mysql 
Sql :: oracle cache matching 
Sql :: sql to excel pgadmin 
Sql :: equi joins in oracle 
Sql :: sql developer connect to sql server 
Sql :: find max number in sql 
Sql :: sql query to delete duplicate records 
Sql :: create table from query mysql 
Sql :: sum function in sql 
Sql :: oracle sql distinct vs unique 
Sql :: mysql update sum same table 
Sql :: Sql Text or Varchar 
Sql :: Why mysql is used? 
Sql :: enable mysql query log 
Sql :: insert into 
Sql :: SQL AS With More Than One Column 
Sql :: sqlite dropping multiple tables 
Sql :: delete and start from 1 primary key muysql 
Sql :: delete double on SQL with multiple primary keys 
ADD CONTENT
Topic
Content
Source link
Name
8+7 =