Q:

why command update in " insert or update " are working not right?

INSERT INTO `Users`
                (ID,FirstName,LastName) 
                    VALUE 
                ('60','Alex','Mathew') 
                ON DUPLICATE KEY 
                UPDATE 
                    FirstName = 'Alex' AND LastName = 'Mathew'

ID - is the Unique key

Insert works, but update sets FirstName to '0'. Where is the error?

A:

Test it:
INSERT INTO `Users`
                (ID,FirstName,LastName) 
                    VALUE 
                ('60','Alex','Mathew') 
                ON DUPLICATE KEY 
                UPDATE 
                    FirstName = 'Alex', LastName = 'Mathew'

Change AND on ','

