Today, in the technical discussion group, "Everything goes as it happens" students have a question when reading, how many fields can there be in a MySQL table?With this question in mind, we explored, and then went on to discuss the issue of single field length.
1. Official Document Description
The content of the official document is a ...
Posted on Wed, 01 Apr 2020 22:54:26 -0400 by bftwofreak
First create a students table
The SQL script is as follows:
create table students(
id int primary key auto_increment,
) character set utf8;
insert into students values(null, 22, 'lisa', 'Hangzhou');
insert into students values(null, 16, 'rock', 'Shanghai');
insert into students values ...
Posted on Wed, 01 Apr 2020 22:17:06 -0400 by Andre_Ng
I sorted out some sql statements for beginners, and customized the basic skills necessary for playing mysql database. It is very suitable for beginners to learn!
create table student_info (
id int unsigned auto_increment primary key,
insert in ...
Posted on Wed, 01 Apr 2020 22:06:18 -0400 by billabong0202
mysql 5.7 installation
This is a series of articles ShardingSphere The first article in this article is about how to build a master for Mysql.The setup environment is centos 7.7 and the database version is 5.7.Three virtual machines are needed, one master and two slaves. Readers can create virtual machines on their own computers, or they can b ...
Posted on Wed, 01 Apr 2020 15:39:19 -0400 by surfnjunkie
What is multi instance
In short, multiple instances of MySQL are to open multiple different server ports on one server at the same time and run multiple MySQL service processes at the same time. These service processes provide services by listening to different service ports on different socket s.
Two different mult ...
Posted on Tue, 31 Mar 2020 23:32:53 -0400 by FrankA
. check whether other versions of mysql are installed and uninstall
(when installing linux, mysql is often installed by default.)
[root@localhost ~]# yum list installed | grep mysql
[root@localhost ~]# yum remove mysql-libs.x86_64
1. Download the installation package
[root@localhost ~]# wget http://cdn.mysql. ...
Posted on Tue, 31 Mar 2020 23:05:34 -0400 by Norsk.Firefox
Learning note 8 of shell script programming -- process control and loop
1, if statement
if [Conditional judgment] ;then
if [Conditional judgment]
if Sentence usage fi Ending, different from ...
Posted on Tue, 31 Mar 2020 22:37:42 -0400 by trukfixer
Using brew to install mysql
brew install mysql
After the installation is successful, use the following command to start / shut down the service
brew services start mysql
brew services stop mysql
Set up a soft connection for mysql.bin
ln -s /usr/local/Cellar/mysql/5.7.21/bin/mysql /usr/bin
Posted on Tue, 31 Mar 2020 22:21:20 -0400 by Dvector
The problem of mysql time subtraction (bug)From: https://blog.csdn.net/yzsind/article/details/8831429Today, I saw one of Ning Qing's classmates micro-blog , mentioning the wrong result of mysql date subtraction, I didn't pay much attention to it before, so I tested it and found that it was really bad and easy to step ...
Posted on Tue, 31 Mar 2020 19:09:04 -0400 by grga
1. Configuration of my.cnf common parameters in MySQL
[client]user=davidpassword=88888888[mysqld]########basic settings########server-id = 11 port = 3306user = mysqlbind_address = 10.166.224.32 #Modify according to the actual situationautocommit = 0 #5.6.X During installation, it needs to be commented out and opened aft ...
Posted on Tue, 31 Mar 2020 12:26:18 -0400 by Ancoats