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

[Peter Brawley]

A table without a primary key is incomplete, and the Insert ... On Duplicate Key Update... command illustrates this, because without a key it can never find a key to update. You forgot to give your table a PK. Without a PK, your cmd simply adds a row for ed, 19 points.

After ...

alter table tbl_points add primary key(name);

... your cmd works as expected.

Consider reading a primer on relational databases, eg https://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html