Home: Perl Programming Help: DBI:
inserting



$0.05$
Novice

May 28, 2002, 8:49 PM


Views: 10243
inserting

is it possible to do this:


say i have a database, and in this database i have lots of records. Now, say that i want to modify one of these records, i wouldnt have to delete this record would i? do i just do the standard INSERT INTO query, while specifying the same unique key? or what?


fashimpaur
User

May 29, 2002, 5:23 AM


Views: 10240
Re: [$0.05$] inserting

$0.05$,

No, use the SQL command 'UPDATE' to modify an existing record in the database.
Just be specific in the where clause to ensure you will only modify the number
of records intended (usually one) and no others.

I recommend the book: SQL: The Complete Reference by Groff and Weinberg (Osborne/McGraw Hill Publishing). It is comprehensive and will address most any
SQL issue you have a question about.

Good Luck,
Dennis

$a="c323745335d3221214b364d545".
"a362532582521254c3640504c3729".
"2f493759214b3635554c3040606a0",
print unpack"u*",pack "h*",$a,"\n\n";


Cure
User

Jun 8, 2002, 10:07 AM


Views: 10229
Re: [$0.05$] inserting

www.sqlcourse.com



Cure