Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > mysql > answers

Update Without Set

Member
  
Join Date: Jul 2006
Location: Indonesia
Posts: 51
#1: Jul 14 '06
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's Avatar
AdministratorVoR
  
Join Date: Feb 2006
Location: South West UK
Posts: 6,166
#2: Jul 14 '06

re: Update Without Set

That's not what the MySQL documentation says

http://dev.mysql.com/doc/refman/5.1/en/update.html
sashi's Avatar
Expert
  
Join Date: Jun 2006
Location: Seremban, Malaysia
Posts: 1,630
#3: Jul 15 '06

re: Update Without Set

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's Avatar
Moderator
  
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#4: Jul 21 '06

re: Update Without Set

SET is absolutely mandatory in the UPDATE statement!

Ronald :cool:
Newbie
  
Join Date: Jul 2006
Posts: 7
#5: Jul 28 '06

re: Update Without Set

You cannot have update without SET its compulsory
Newbie
  
Join Date: May 2007
Posts: 1
#6: May 21 '07

re: Update Without Set

hey there,

I guess ur friend should be kidding, or he's a wack programmer...Update 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
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,392 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved