Duplicating records...

[Jon Cooper]

I have looked long n hard at the Insert Select as being the answer to my
need to create duplicate records. (Purpose is basically to allow someone to
create a duplicate of an existing email template then modify it). I have
tried all sorts of variations on:

INSERT INTO emaillist SELECT * FROM emaillist WHERE emailid = #url.emailid#
(inc trying IGNORE) but of course this throws an error over duplicate keys.

All I want to do is to take Record A, duplicate it and have a new key
assigned to it (the key is an autonumber field). This must be simple but I'm
stuck!

thanks

Jon

[jerry gitomer]

Jon Cooper wrote:

I have looked long n hard at the Insert Select as being the answer to my
need to create duplicate records. (Purpose is basically to allow someone to
create a duplicate of an existing email template then modify it). I have
tried all sorts of variations on:

INSERT INTO emaillist SELECT * FROM emaillist WHERE emailid = #url.emailid#
(inc trying IGNORE) but of course this throws an error over duplicate keys.

All I want to do is to take Record A, duplicate it and have a new key
assigned to it (the key is an autonumber field). This must be simple but I'm
stuck!

thanks

Jon

Try the following:

INSERT INTO emaillist '$keyvalue', SELECT col1, col2, col3
FROM emaillist WHERE emailid = #url.emailid#

I am not sure it will work with MySQL, but it is easy enough to
find out.

HTH
Jerry

[Jon Cooper]

hi Jerry thanks for taking the time to look at this but no success!
$keyvalue' is not being recognised as a MySQL function and hunting thru the
docs I have been unable to find an equivalent.

Any other ideas massively appreciated!

Jon
"jerry gitomer" <jg******@verizon.net> wrote in message
news:5uT2e.3$7b.2@trndny02...

Jon Cooper wrote:

I have looked long n hard at the Insert Select as being the answer to my
need to create duplicate records. (Purpose is basically to allow someone to create a duplicate of an existing email template then modify it). I have
tried all sorts of variations on:

INSERT INTO emaillist SELECT * FROM emaillist WHERE emailid = #url.emailid# (inc trying IGNORE) but of course this throws an error over duplicate keys.
All I want to do is to take Record A, duplicate it and have a new key
assigned to it (the key is an autonumber field). This must be simple but I'm stuck!

thanks

Jon

Try the following:

INSERT INTO emaillist '$keyvalue', SELECT col1, col2, col3
FROM emaillist WHERE emailid = #url.emailid#

I am not sure it will work with MySQL, but it is easy enough to
find out.

HTH
Jerry

[Felix Geerinckx]

On 31/03/2005, Jon Cooper wrote:

All I want to do is to take Record A, duplicate it and have a new key
assigned to it (the key is an autonumber field). This must be simple
but I'm stuck!

With the following table definition:

mysql> desc templ;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| f1 | varchar(100) | YES | | NULL | |
| f2 | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+----------------+

you can do the following:

INSERT INTO templ (id, f1, f2)
SELECT NULL, f1, f2
FROM templ
WHERE id= <<some_id>>;

--
felix

[Jon Cooper]

Felix - good grief yes that's right. thank you very much!

Jon

"Felix Geerinckx" <fe*************@gmail.com> wrote in message
news:xn***************@news.easynews.com...

On 31/03/2005, Jon Cooper wrote:

All I want to do is to take Record A, duplicate it and have a new key
assigned to it (the key is an autonumber field). This must be simple
but I'm stuck!

With the following table definition:

mysql> desc templ;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| f1 | varchar(100) | YES | | NULL | |
| f2 | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+----------------+

you can do the following:

INSERT INTO templ (id, f1, f2)
SELECT NULL, f1, f2
FROM templ
WHERE id= <<some_id>>;

--
felix