c# - Error when trying to out out data from a database -


i getting error shown here when trying output things:

you have error in sql syntax; check manual corresponds mysql server version right syntax use near ') colours.prompt_reply' @ line 1

please help

mysqlcommand cmddatabase = new mysqlcommand("select (user_id, project, project_feedback, when) colours.prompt_reply ;",condatabase); 

i think have error in command

mysqlcommand cmddatabase = new mysqlcommand("select user_id, project, project_feedback, when your_table_name",condatabase);

is 'when' part of table?

i haven't used mysql in c# had used sql sever before think work


Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -