how can I replace a record in my DB (mySql) by new record?

ngiw2012 · 06-05-2014, 06:21 AM

I'm working on centos 6.5
and I have manged to do an insert query

mysql -u root --password='pw' MatchingDB

> INSERT INTO USER_MACTable (USER, MAC) VALUES ('$user','$mac');

my question is:
how to modify the insert query above to let it replace an existing record when the MAC attribute is duplicated and to insert a new record normally when the MAC attribute isn't duplicated using phpmyadmin queries?

linosaurusroot · 06-05-2014, 06:42 AM

UPDATE not INSERT - you should be able to search for SQL tutorials online.

ngiw2012 · 06-05-2014, 07:23 AM

I have tried something like this but it keeps return an error (syntax error):

INSERT INTO user_MACTable (user, MAC) VALUES ('$user','$mac')
ON DUPLICATE KEY UPDATE MAC = VALUES('$mac')

the error according to my server is near '$mac')

TenTenths · 06-05-2014, 08:53 AM

Quote:

Originally Posted by ngiw2012

I have tried something like this but it keeps return an error (syntax error):

You do not need the values() construct if you are specifically naming the column you are changing.

Try this:

Code:

INSERT INTO user_MACTable (user, MAC) VALUES ('$user','$mac') 
ON DUPLICATE KEY UPDATE MAC = '$mac'