Insert using mysql

Insert: ERROR [42S22] [MySQL][ODBC 8.0(a) Driver][mysqld-8.0.16]Unknown column ‘Serial’ in ‘field list’",

Hi @AakashBaruva
Kindly check once whether column Serial is there in your database table
Cheers @AakashBaruva

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?

1 Like

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
Cheers @AakashBaruva

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.