insert into mysql if not exist else update

Asked Aug 12 '15 at 08:21

Active Aug 12 '15 at 08:21

Viewed 53 times

I have in my table of mysql this cells: ebook_data and ebook_email. I want to update ebook_data if ebook_email is same, if not insert ebook_data and ebook_email.

I don't understand werry well php and mysql.

Can you help me, please?

Thanks in advance.

asked Aug 12 '15 at 08:21

Pixel Time

3

You're looking for something like [this](http://stackoverflow.com/questions/6030071/mysql-table-insert-if-not-exist-otherwise-update). – Andrei Aug 12 '15 at 08:23
$sql="INSERT INTO ebook (ebook_data, ebook_email) VALUES (NOW(), '$ebook_email') ON DUPLICATE KEY UPDATE ebook_data =VALUES(NOW())"; – Pixel Time Aug 12 '15 at 08:27
Don't comment your code and update it to your post. – Logan Wayne Aug 12 '15 at 08:30
@Andrew Flag this as a duplicate – Barmar Aug 12 '15 at 08:48

insert into mysql if not exist else update

0 Answers0