Relative Content

Tag Archive for c++sqlmysqldebugging

Getting Unknown column ‘ ‘ in ‘field list’ (MySQL error code: 1054, SQLState: 42S22) using MySQL connect/C++

I am working on a beginner level C++ banking system project using MySQL data base server. In order to use a database from the server I have used Connect/C++ library from MySQL website. The main file was compiling and no linking errors, but as soon as the program executes a function which executes sql query, there is an error. I have given one of the functions code which shows the following error statement in console “Unknown column ‘ ‘ in ‘field list’ (MySQL error code: 1054, SQLState: 42S22) using MySQL connect/C++”. I have used try-catch block in main() function.