Insert: ERROR [42S22] [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.16]Unknown column ‘Serial’ in ‘field list’",
There is a column named serial number,but the error is serial number,does the datatable columns and database table columns be in same name?
Any columns that have spaces or other disallowed characters in the name must be surrounded by [square brackets] - it is generally best practice to always surround column names in square brackets anyways.
yes of course they should be same buddy
i did have the same name before but the space and disallowed character were the issue,thank you guys.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.