How do I delete a string from my database and update it.

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: How do I delete a string from my database and update it. by fx (Pilgrim) on Dec 19, 2003 at 23:40 UTC
The question is vague. It sounds like you want to delete some record from the database. One way to do this would be: `$dbh->do("delete from table_1 where some_id = 1234");` ...or if you want to NULL one of the attributes for a record you could: `$dbh->do("update some_table set some_value=NULL where some_id = 1234") +;` [download] ...and then call `$dbh->commit` if `AutoCommit` is not set, but again the question is really too vague to answer.	[reply] [d/l] [select]
Re: Answer: How do I delete a string from my database and update it. by exussum0 (Vicar) on Dec 20, 2003 at 20:55 UTC
Using placec holders might be a little smarter. `$sth = $dbh->prepare("delete from table_1 where some_id = ?"); $sth->execute(1234); $sth->execute(undef);` [download] Less worry about quotes. Play that funky music white boy..	[reply] [d/l]
Re: How do I delete a string from my database and update it. by Fastolfe (Vicar) on Nov 25, 2000 at 06:07 UTC
See Re: How can I add a string to my database and update it? Originally posted as a Categorized Answer.	[reply]