Solved

doubt in query

Posted on 2008-10-09
4
217 Views
Last Modified: 2012-05-05
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
Comment
Question by:priyapratheep
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Binuth
ID: 22684775
insert into inbound_to_future (PartnerName,ManufacturerName,MPN,Region,ATS,SOQ) VALUES ('Future Electronics','AAEON ELECTRONICS','1702031802','FUTC',0,1)

0
 
LVL 14

Accepted Solution

by:
Binuth earned 500 total points
ID: 22684783
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
 
LVL 6

Expert Comment

by:carlsiy
ID: 22684799
Exactly what are you trying to do.. an insert query or an update query?
0
 
LVL 10

Expert Comment

by:GeoffSutton
ID: 22686693
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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 8 50
t-sql split string into multiple rows 7 84
SQL Server 2012 r2 - Varible Table 3 24
ServiceCenter IR Query Expressions 1 20
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question