Re: Duplicating a Record in MySQL

Well, I confess that I have not read the entire thread. But MySQL does provide a INSERT from SELECT syntax which I have used often. David ----- Original Message ----- From: "Roger Lewis" <re.lewis@attbi.com> To: <holmes072000@charter.net>; "'Php-General'" <php-general@lists.php.net> Sent: Saturday, October 19, 2002 1:45 PM Subject: RE: [PHP] Duplicating a Record in MySQL > > > -----Original Message----- > From: John W. Holmes [mailto:holmes072000@charter.net] > Sent: Saturday, October 19, 2002 12:52 PM > To: 'Roger Lewis'; 'Php-General' > Subject: RE: [PHP] Duplicating a Record in MySQL > > * >> It's not strictly php, but does anyone know an easy way to > duplicate a > > >> record in MySQL. It would be nice if you could write something > like: > > >> > > >> COPY * from table WHERE id = 6; > > >> > > >> and have it insert a new record into the table with the next id > > >>number. > > > > >I think that if you have to do this, you've got design issues. Why > not > > >just keep a "count" column in the row and increment that, instead of > > >duplicating the row. > > > > >---John Holmes... > > John, > > Here's the application: I'm creating a daily report online, eg. with > > Title, > > Report no., Date, Author, Subject Headings, Text, etc., etc.. The > report > > is > > stored in a MySQL table. When it comes time to write a new report, I > > would > > like to be able to call up an existing report, upon which to base the > new > > one, and copy the record. Then make changes where necessary and > update > > the > > record. > > So have PHP select out the row you want to "copy", make your changes to > it with PHP or a form, then have PHP insert a new row into the database. > Why copy data when you're going to change it. > > ---John Holmes... > Well, you're probably right. I've been working with Adobe GoLive, and have > been using the CopyFormData command, so that's where I got the idea. I ran > into trouble with GoLive when I complicated my report form by adding file > attachments. Anyway, here's a condensed version of code base on what > Stephen Knight suggested. (Thanks, Stephen). I'll work on this to try and > avoid the copying step as you are suggesting. > > $sql = "select * from daily_reports where report_no = '$report_no' "; > $result = mysql_query($sql); > $x = mysql_fetch_row($result); > $fields = "report_no, order_no, report_date, project_no, project_name, > client, title, subtitle, author, company, summary_heading, > summary, section1_heading, section1"; > $values = " '$x[1]', '$x[2]', '$x[3]', '$x[4]', > '$x[5]', '$x[6]', '$x[7]', > '$x[8]', > '$x[9]', '$x[10]', '$x[11]', '$x[12]', > '$x[13]', '$x[14]' "; > // Note: There must be a way to have PHP generate the previous line, but I > don't know how. > $sql = "INSERT INTO daily_reports ($fields) VALUES ($values)"; > mysql_query($sql); > > Thanks, Roger > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > >