Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql copy data from one table to another

UPDATE  `Table2`
JOIN `Table1`  ON `Table1`.`a_id` = `Table2`.`id`
SET `Table2`.`txn_stamp` = `Table1`.`tranx_id`
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #mysql #copy #data #table
ADD COMMENT
Topic
Name
3+6 =