syntax prob

[csniffer]

i want to add information to a table named studentdetails in column named jobchoice1 and it needs to be added on the row where first name is == to Tony, can anyone see whats wrong with my syntax. thx

mysql> ALTER studentdetails (jobchoice1) VALUES ('Network Administrator') WHERE
firstname == Tony;

To err is human, to completely mess up takes a computer.

 

[sleipnir214]

First, you need to pick the correct predicate for your query.

"ALTER" changes the actual structure of a table.

"INSERT" adds data to a table.

"UPDATE" edits preexisting data in a table.


You say you want to add data, which would indicate an "INSERT" query. Yet you have a "WHERE" clause in your query. You can't use "WHERE" with "INSERT".

What exactly is it you are trying to do?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[csniffer]

It is update that I need to use, your answer has enabled me to find the answer in a book. Thx T

To err is human, to completely mess up takes a computer.