Re: I need a column that automatically adds the new number with the old number. Possible?

[rosewood mahogany]

Here's some of my totally failed code.

INSERT INTO tbl_points (name, points) VALUES ('ed',19) ON DUPLICATE KEY UPDATE points = points + 19;

My terminal then says this was submitted successfully, but when I check the table I find it did not work:

The existing row was not updated. Instead a new row was inserted.