Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to move rows from one table to another in sql

INSERT INTO Table2 (UserName,Password)
SELECT UserName,Password FROM Table1 WHERE UserName='X' AND Password='X'
Comment

PREVIOUS NEXT
Code Example
Sql :: Sql Cursor: Implicit 
Sql :: mysql case sensitive 
Sql :: sql find gaps in date ranges 
Sql :: set default value now() date 
Sql :: Enable outgoing remote MySQL access 
Sql :: show database size or specific database table size 
Sql :: what is a foriegn key 
Sql :: SQLAlchemy query to return only n results? 
Sql :: select 1 from orders 
Sql :: acutal month year 
Sql :: sql column as header 
Sql :: Oracle Function call - 12C 
Sql :: android sqlite query con join 
Sql :: including parameters in OPENQUERY 
Sql :: To access SQL database file 
Sql :: strat with in sql 
Sql :: reading from right to left from string find first special characters in sql 
Sql :: copy table structure from postgresql to mysql 
Sql :: what to do if foreign key is making conflict while deleting record from sql table using c# 
Sql :: postgres insert knex 
Sql :: psql delete table 
Sql :: sql compiler 
Sql :: how to create foreign key in sql server management studio 
Sql :: utf8_encode mysql 
Sql :: minus vs except in sql 
Sql :: run sql script file and changes db name in this file using c# 
Csharp :: c# change label forecolor code 
Csharp :: Point to mouse 2D Unity 
Csharp :: get date of tomorrow c# 
Csharp :: c# input integer 
ADD CONTENT
Topic
Content
Source link
Name
3+3 =