Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

doubt in query

what is wrong with the query

UPDATE inbound_to_future (PartnerName,ManufacturerName,MPN,Region,ATS,SOQ) VALUES ("Future Electronics","AAEON ELECTRONICS             ","1702031802                    ","FUTC",0,1);
0
priyapratheep
Asked:
priyapratheep
  • 2
1 Solution
 
BinuthCommented:
insert into inbound_to_future (PartnerName,ManufacturerName,MPN,Region,ATS,SOQ) VALUES ('Future Electronics','AAEON ELECTRONICS','1702031802','FUTC',0,1)

0
 
BinuthCommented:
update syntax


Update inbound_to_future
set PartnerName ='Future Electronics'
      ,ManufacturerName = 'AAEON ELECTRONICS'
      ,MPN = '1702031802'
      ,Region = 'FUTC'
      ,ATS = 0
      ,SOQ =1
Where
      <set your contition here>
0
 
carlsiyCommented:
Exactly what are you trying to do.. an insert query or an update query?
0
 
GeoffSuttonCommented:
With SQL you cannot use full quotes ("), only single quotes (') as text identifiers.  Full quotes are treated as column names.

Also to update something you need a condition, otherswise every row in the table will get the same data.

Finally, you are using UPDATE while you have INSERT syntax.

For inserts use:
INSERT tableName (Column1, column2, column3) VALUES (value1, value2, value3)

For updates use:
UPDATE tableName SET column1=value1, column2=value2, column3=value3 WHERE (somecolumn=somevalue)

Hope this helps,

Geoff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now