Insert query into database failed

[ljCharlie]

Here's my code for Insert.

INSERT INTO activities VALUES ('31052003', '2003-05-31', 'Web site conference', '19:00:00', 'Eau Claire', 'Everyone') WHERE actID <> 31052003;

When I used the MySQL Control Center to insert, the error that the program gave me was a syntax error between &quot;WHERE actID <> 31052003&quot;. I tried inserting without the WHERE clause and it works just fine. So my guess is that it has to do with the not equal operator. I want to insert into the database when the actID in the database is not equal to the new actID. I have tried !=, <>, IS NOT but none work.

Please help.

Many thanks in advance!

ljCharlie

 

[sleipnir214]

You can't use INSERT and WHERE in the came query. INSERT adds a record to a table, so a WHERE clause is meaningless.

If you are trying to change the value in an existing table, use UPDATE instead of INSERT

Want the best answers? Ask the best questions:

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

TANSTAAFL!

 

[ljCharlie]

Thanks! That's what I kinda think too since it works perfectly without the Where clause.

ljCharlie