w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
Syntax issue UPDATE works but not INSERT

The datatype for the field 'category_of_taxom' is most likely set to varchar, meaning it should have quotes around the value when using INSERT. So you can either:

1) Change the datatype of category_of_taxom to integer in your database

2) Include quotes around the value in your INSERT statement:


Related documentation: mysql - quote numbers or not?

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.