mysql - Mysql查询插入或更新时出错

Question

我对这个查询有点绝望，我找不到我的错:

INSERT INTO device (
                    Device_UUID, 
                    Model, 
                    Manufacturer, 
                    Latitude, 
                    Longitude, 
                    Type, 
                    Registration_Date, 
                    Status, 
                    API_Source) 
             values (
                    'WW', 
                    'a', 
                    'v', 
                    '0.00',
                    '0.00', 
                    'BUS', 
                    '2014-01-01 12:11:11', 
                    '1', 
                    'R') 
            ON DUPLICATE KEY UPDATE 
                    Model = "wwww", 
                    Manufacturer = "bbbbb", 
                    Registration_Date = "2014-01-01 12:11:11";

所有字段都是字符串，甚至纬度和经度

Answer 1

类型是关键字。尝试将 Type 放入一些“。