VS连接MySQL后配置Select语句,当从指定mytable1表中选择好列后,查询测试,提示如下:执行查询时出错。请检查命令的语法以及参数的类型和值(如果有),确保它们正确。
You have an error in your SQL syntax:chkck the manual that correponds to you MySQL server
version for the right syntax to use near`[字段],[字段] FROM [mytable1]` at line 1请问这是怎么回事啊?怎么解决?请老师们指教,多多感谢!
You have an error in your SQL syntax:chkck the manual that correponds to you MySQL server
version for the right syntax to use near`[字段],[字段] FROM [mytable1]` at line 1请问这是怎么回事啊?怎么解决?请老师们指教,多多感谢!
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ddlxConnectionString %>"
ProviderName="<%$ ConnectionStrings:ddlxConnectionString.ProviderName %>"
SelectCommand="SELECT [xuehao], [xingming], [xingbei], [xueyuanbianhao] FROM [mytable2]"></asp:SqlDataSource>
You know the key on the num 1 left.