MySQL String Error in insert into Statement
When passing values, looking at C# code directly passing string value, error reported showing matching column not found
1 | command += "INSERT INTO " + TableName + "(data_id,data_desc,data_price) VALUES(" + ids[i] + ", " + description[i] + "," + price[i] + ");"+"\r\n"; |
After the running error, I found that I didn’t consider that the command is passed completely in string form. At this time, the string passed by description does not have double quotes “ “, the string form of the command is:
1 | "insert into table (data_id,data_desc,data_price) |
You can see that description has no double quotes so the command is wrong. You need to modify the command description to add single quotes.
1 | ", '" + description[i] + "' ," |
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2020-04-17
MySQL insert into 语句中字符串报错
在传入值时，在C#中代码直接传入string值，报错显示未找到符合列 1command += "INSERT INTO " + TableName + "(data_id,data_desc,data_price) VALUES(" + ids[i] + ", " + description[i] + "," + price[i] + ");"+"\r\n"; 运行出错后发现是自己没有考虑到命令全部以字符串形式传入，此时description传入的字符串未带有双引号“ “,命令的字符串形式为： 12"insert into table (data_id,data_desc,data_price)value(111,description,1.001)" 可以看到description没有双引号所以命令出错，需要修改命令description加入单引号即可 1", '" + description[i] + &qu...
2020-11-04
WCF IIS配置并引用 并初步使用Mysql数据库
学习网址：https://docs.microsoft.com/zh-cn/dotnet/framework/wcf/how-to-create-a-wcf-client本地资源配置与IIS资源配置我是根据微软官网学习的，有兴趣的可以跟着敲一下，我这里只说一下我遇到的问题 IIS 再IIS中配置服务时，根据教程上创建虚拟目录，发现如果我如果再默认站点创建服务将会提示InvalidOperationException: 找不到类型“Microsoft.ServiceModel.Samples.CalculatorService,发现我再默认站点已经托管了一个服务导致的问题。应该是今天感冒有点迟钝新建站点：1.1. 将我们的路径端口及名称输入即可，和创建Web站点一个步骤。 创建文件APP_Code、service.svc、Web.config,其中Web.config文件按照官方给的案例后面将会出现无法打开安全通道，因为与远程终结点的安全协商已失败。这可能是由于用于创建通道的 EndpointAddress 中不存在 EndpointIdentity 或错误指定了 Endpoint...
2020-11-04
WCF IIS Configuration and Reference and Preliminary Use of Mysql Database
Learning URL: https://docs.microsoft.com/zh-cn/dotnet/framework/wcf/how-to-create-a-wcf-clientLocal resource configuration and IIS resource configuration I learned according to Microsoft official website, interested can follow to type, I only calculate problems I encountered here IIS When configuring service in IIS, creating virtual directory according to tutorial, found if I create service in default site will prompt InvalidOperationException: Cannot find type “Microsoft.ServiceModel.Samples...
2020-06-12
vs2019 Connect MySQL You have a usable connection already.
Found big shot solving vs2017 problem, found this is bug of mysql itself, need to install specific version of mysql-connect-net and mysql-connect-netSolution
2020-06-12
vs2019连接MySQL You have a usable connection already.
找到大佬在解决vs2017的问题，发现这是mysql本身的bug，需要安装特定版本的mysql-connect-net和mysql-connect-net解决方案
2021-01-22
MySQL Lock Granularity and ACID
Table Lock: It locks the entire table. Before a user performs a write operation (insert, delete, update, etc.) on the table, they need to acquire a write lock first, which will block all read and write operations on the table by other users. When there is no write lock, other users can obtain read locks, and read locks between multiple users do not block each other.Row Lock: Row-level locks can support concurrent processing to the greatest extent (and also bring the largest lock overhead). AC...
