1. Create project
We use the console type project to test the insertion, deletion, update, query and other functions, create a console project, and use the command:
dotnet new console
dotnet add package FreeSql.Provider.MySql
dotnet add package FreeSql.Repository
2. Create a solid model
Posted on Wed, 22 Apr 2020 07:05:10 -0700 by talltorp
The sequence in Mysql is mainly used for the primary key, which is an incremental field and cannot be repeated.
Mysql is different from Oracle in that it does not support the original sequence, and it needs to use the combination of tables and functions to achieve similar sequence functions.
1. First create the main table of the sequence
Posted on Sat, 18 Apr 2020 07:58:14 -0700 by dominicd
Today, the next MySQL 8.0 found that Navicat could not connect, and always reported 1251 errors;
After trying many ways, we finally found a way to achieve it:
By changing the encryption method:
1. First enter the root account of mysql through the command line:
PS C:\Windows\system32> mysql -uroot -p
Enter password: ******
Enter the pas ...
Posted on Thu, 19 Mar 2020 10:50:04 -0700 by sid666
This article creates a rough learning list, and moves the details to the major learning websites.
Navicat (cracked version)
Connect to database
mysql -uroot -p
view the database
ps: end of command line; can't be less.
Posted on Tue, 28 Jan 2020 06:11:46 -0800 by spikeon
In learning 1, a simple project is built. This section is added to Mysql database
1. navicat new connection
Make sure Mysql and Navicat are installed
1. Start database: net start mysql (stop using net stop mysql) Note: to run with administrator privileges
2. Open navicat to create a new connection
The connection name is optional. I have set ...
Posted on Sun, 15 Dec 2019 09:07:06 -0800 by taz321
1. First of all, I opened the hidden file according to the Internet, or I could not find my.ini.
2, if method 1 finds... No need to look at 2. Accept reality if you don't find it. You need to create my.ini yourself and reconfigure it.
(1) The administrator runs cmd on the premise that the mysql environm ...
Posted on Sat, 05 Oct 2019 03:14:06 -0700 by Alidad
Undoubtedly, this must be a sad story. I have a requirement here. I need to migrate and backup some records and log tables. Under the current conditions, we do not use MaxCompute for backup, nor do we handle it gracefully through master-slave databas ...
Posted on Wed, 04 Sep 2019 20:39:02 -0700 by nofxsapunk
mysql-8.0.12-winx64.zip version of MySQL Installation-Free Configuration Tutorial under windows
Step 1: Download this version of mysql file from the mysql official website
Step 2: Unzip the file
The third step is to analyze the file structure
Step 4: Configuration
Create a new data folder in the mysql root directory
Posted on Mon, 17 Dec 2018 04:57:04 -0800 by FireDrake