MySQL Forums
Forum List  »  Newbie

Re: Batch edit a table using sql
Posted by: Peter Brawley
Date: August 13, 2014 01:35PM

I would have thought that your two cmds would have returned errors...

insert() syntax is INSERT(str, pos, len, newstr),
eg insert( 'abcd', 1, 3,'xyz' ) --> 'xyzd'.

replace() syntax is REPLACE( str, oldSubStr, newSubStr ),
eg replace( 'abcd', 'abc', 'xyz' ) --> 'xyzd'.

An UPDATE cmd with no WHERE clause updates all rows.

Options: ReplyQuote


Subject
Written By
Posted
August 13, 2014 12:46PM
Re: Batch edit a table using sql
August 13, 2014 01:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.