[open source]. NETCORE. Netframework xamarin uses ORM FreeSql to access MySql/Mariadb

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 using System; using FreeSql.DataAnnotations; publ ...

Posted on Wed, 22 Apr 2020 07:05:10 -0700 by talltorp

Application and summary of sequence in MySql

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 /* N ...

Posted on Sat, 18 Apr 2020 07:58:14 -0700 by dominicd

Navicat connection MySQL 8.0 pro test

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

Getting started with MySQL and common command line

This article creates a rough learning list, and moves the details to the major learning websites. Graphical tools Navicat (cracked version) SQLyog PhpMyadmin Workbench DBeaver ... Connect to database mysql -uroot -p view the database show datebases; ps: end of command line; can't be less. ...

Posted on Tue, 28 Jan 2020 06:11:46 -0800 by spikeon

node + express learning II (database)

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

My.ini file can't be found in mysql root directory. Recreate my.ini

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

Mysql stored procedures traverse pits where values cannot be obtained

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

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 Create ...

Posted on Mon, 17 Dec 2018 04:57:04 -0800 by FireDrake