Insert using mysql

Help
1

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

2

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

3

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
4

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.

5

yes of course they should be same buddy
Cheers @AakashBaruva

6

i did have the same name before but the space and disallowed character were the issue,thank you guys.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.