I doubt this is possible, and I am successfully doing this using a php file right now, but im wondering if this is possible to do completely in sql
So say I have a table with say 6 rows (id, sid, file, file_version, timeStamp).
I want to duplicate the rows while changing the id, sid, and time
So basically I want to create X new rows, that share the file, and file_version with the original X
Code:
id sid file file_version time
//have
1 4 2 38 2009-07-12 19:42:59
2 4 13 46 2009-07-12 19:42:59
3 4 56 59 2009-07-12 19:42:59
4 4 78 72 2009-07-12 19:42:59
5 4 212 117 2009-07-12 19:42:59
6 4 300 190 2009-07-12 19:42:59
//want to add
7 13 2 38 2009-07-13 22:04:02
8 13 13 46 2009-07-13 22:04:02
9 13 56 59 2009-07-12 22:04:02
10 13 78 72 2009-07-12 22:04:02
11 13 212 117 2009-07-12 22:04:02
12 13 300 190 2009-07-12 22:04:02
------------------------------
SOLVED WITH------------------------------
Quote:
|
Originally Posted by r937
temp table is not necessary
Code:
INSERT
INTO daTable
( sid
, file
, file_version
, time )
SELECT 13 -- new sid
, file
, file_version
, CURRENT_TIMESTAMP
FROM daTable
WHERE sid = 4 -- sid being copied
 |
dBforums
>
duplicate multiple rows - but certain cols still custom
07-13-09, 23:51
Linear Mode
