Insert into a specific row multiple values with Where clause?

Question

I want to insert two dates into a specifc row on my table using MySql but have a syntax error on Workbench (Error 1064):

INSERT INTO atable (Activated,Expiry) WHERE Access_Code = 'accesscode'
VALUES('$current_date','$Expiration_Date')

What would be the correct version for this?

INSERT statements don't have a WHERE clause. The point of a WHERE clause is to filter existing rows but INSERT statements don't affect existing rows. Do you want to insert a new row or do you actually want to update an existing row? If it's the latter then you use an UPDATE statement. — jmcilhinney
– jmcilhinney, Commented Jul 23, 2014 at 0:31

Mariano D'Ascanio · Accepted Answer · 2014-07-23 00:35:08Z

1

It would be something like this:

UPDATE atable
SET Activated='$current_date',
    Expiry='$Expiration_date'
WHERE Access_Code='accesscode';

I'm assuming you will be setting $current_date and $Expiration_date via (what looks like PHP) code.

Hope this helps.

answered Jul 23, 2014 at 0:35

Mariano D'Ascanio

1,2002 gold badges16 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1