MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Error 1175 - I an trying to update a column in every record
Posted by: Rick James
Date: February 21, 2011 10:00AM

That can still be off by a day.

Possibly the CAST() function can avoid the 'safe updates' issue.

The cost for computing an expression in a SELECT is insignificant compared to fetching the rows. Caveat: It can be very costly in the WHERE clause because it can prevent use of indexes.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Error 1175 - I an trying to update a column in every record
Chad Ramos
February 20, 2011 10:57AM
Re: Error 1175 - I an trying to update a column in every record
laptop alias
February 20, 2011 11:46AM
Re: Error 1175 - I an trying to update a column in every record
Chad Ramos
February 20, 2011 12:45PM
Re: Error 1175 - I an trying to update a column in every record
Rick James
February 20, 2011 10:33PM
Re: Error 1175 - I an trying to update a column in every record
Chad Ramos
February 21, 2011 08:24AM
Re: Error 1175 - I an trying to update a column in every record
Rick James
February 21, 2011 10:00AM


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.