How many fields can MySQL have

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

Simple use of MySQL stored procedure

First create a students table The SQL script is as follows: create table students( id int primary key auto_increment, age int, name varchar(20), city varchar(20) ) 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

Play MYSQL database basic skills

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! Student list create table student_info ( id int unsigned auto_increment primary key, studentname varchar(10), gender enum('male','female') ); insert in ...

Posted on Wed, 01 Apr 2020 22:06:18 -0400 by billabong0202

[ShardingSphere] 1. Mysql database master-slave setup

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

Mysql multi instance installation and configuration

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

Mysql 5.7 for linux Installation binary

. 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 install 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 (XDL) - process control and loop

Learning note 8 of shell script programming -- process control and loop 1, if statement 1, framework 1,Single branch: if [Conditional judgment] ;then program fi if [Conditional judgment] then program fi //Be careful: if Sentence usage fi Ending, different from ...

Posted on Tue, 31 Mar 2020 22:37:42 -0400 by trukfixer

Install mysql and mysql common commands under Mac OS

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 Enter mysql ...

Posted on Tue, 31 Mar 2020 22:21:20 -0400 by Dvector

Subtraction of two dateTime types in mysql

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

Common parameter configuration and explanation in my.cnf in mysql

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