vs2019 Connect MySQL You have a usable connection already.
仅提供English版本
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-net
Solution
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2020-03-11
vs2019 Push Github Error: githubterminal prompts disabled
By modifying .git/config file modify url under [remote origin] to https://uesr.name:user.secret@github.com/******user.name is usernameuser.secret is user passwordSenior Blog Link
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.
