mysql在Windows server 2012R2配置缺少vcruntime140_1.dll文件解决办法
仅提供中文版本
由于我安装的是mysql8.0.20安装的c++是2015应该是版本不一致导致每次检索都会出现缺少vcruntime140_1.dll文件，可以通过链接下载2015-2019版进行dll的更新
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2020-06-12
vs2019连接MySQL You have a usable connection already.
找到大佬在解决vs2017的问题，发现这是mysql本身的bug，需要安装特定版本的mysql-connect-net和mysql-connect-net解决方案
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...
2021-01-22
MySQL 锁粒度与ACID
表锁(Table Lock)：它会锁定整张表。一个用户在对表进行写操作(插入、删除、更新等)钱，他需要先获得写锁，这会阻塞其他用户对该表的所有读写操作。没有写锁的时候，其他用户可以获得读锁，多用户之间的读锁相互不阻塞。行级锁(row lock):行级锁能够最大程度的支持并发处理(同时也带来了最大的所开销)。 ACIDACID表示原子性(atomicity)、一致性(consistency)、隔离性(isolation)和持久性(durability) 原子性(atomicity)：一个事务必须被视为一个最小的工作单元，整个事务中的所有操作要么全部提交成功，要么全部失败回滚，对于一个事务来说，不可能只执行其中的一部分操作一致性(consistency):数据库总时哦才能够一个一致性的状态转换到另外一个一致性的状态。在执行事务某条语句的时候系统突然蹦会，导致事务最终没有提交，所以事务所作的修改也不会保存到数据库中隔离性(isolation):通常来说，一个事务所作的修改在最终提交以前，对其他事务是不可见的。在一个事务没有执行结束时，对事务的修改不会影响外部数据。持久性(durabil...
2020-04-17
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 1command += "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...
2020-04-14
Mysql连接远程数据库无法连接
解决办法
2020-06-12
MySQL Query Column Names in Table
select column_name from information_schema.COLUMNS where table_schema='recheck_model' and table_name = 'problem_model';Call the columns view in information_schema, use where statement to specify your database and data table name.
