Update Without Set

[xpcer]

my friend ever tell me that he have seen an update query without using SET , can anyone tell me how to use it in mysql
thanks

[Banfa]

That's not what the MySQL documentation says

http://dev.mysql.com/doc/refman/5.1/en/update.html

[sashi]

Hi there,

are you sure you friend were talking abt an UPDATE query? was is not SELECT INSERT DELETE queries respectively? well.. i feel that UPDATE is not complete without the SET keyword along with it.. isn't Banfa? :)

http://www.w3schools.com/sql/default.asp

[ronverdonk]

SET is absolutely mandatory in the UPDATE statement!

Ronald :cool:

[tejaswini]

You cannot have update without SET its compulsory

[craft]

hey there,

I guess ur friend should be kidding, or he's a wack programmer...Up date does the update in the database, while the set statement does the change of values,,,there must be a change of value before an update can occur...that's the rule...

Code2Craft

[nikdeapen]

An update can be useful without the set clause but it is syntactically required.

A statement like:
UPDATE records SET records.id = records.id WHERE records.id = x;

will not update any information but will fire the update trigger for the given row.

I have used this in a couple places to log a reset of a record with no information changes.