MySQL string interception functions: left(), right(), substring(), substring_index(). There are mid(), substr(). Among them, mid() and substr() are equivalent to the substring() function, and the f
Tag: mysql
MySQL installation
1.mysql download Select the corresponding version download address Here we download mysql-8.0.17-winx64
Unzip and create the root directory after unzip my.ini and data folder
basedir:
Practical mysql database command
Connect: mysql -h host address -u user name-p user password (Note: u and root need not add spaces, the other is the same)
disconnect: exit (Enter) Create authorization: grant select on database.*
Mysql design and development specification
MySQL Design and Development Specification 1 Purpose The main purpose of this specification is to standardize database design and development, and try to avoid the trouble caused by improper datab
MySQL – Implement the hierarchical data structure in the database
I know there are two methods: adjacency list and nested tree. It is said that due to a large number of queries, the adjacency list will be slow to traverse. But I don’t know any actual numbers in t
Split string and loop the value in the MYSQL process
I have encountered a situation where I have to pass a comma-separated string to a MySQL procedure and split the string and insert these values into the table as rows.
As shown in the figure
Error code: 1406. The data is too long – MySQL
Error code: 1406. The column data is too long
CREATE TABLE `TEST`
(
`idTEST` INT NOT NULL ,
`TESTcol` VARCHAR(45) NULL ,
PRIMARY KEY (`idTEST`)
) ; Now insert some values
INSERT IN
What is the HOST column of the User table in mysql?
Execute use mysql; then execute show tables; you can see all the tables in mysql
Execute desc user; you can see the table structure of user
You can see that host is a column in the user table , Exe
MySQL query
Basic query:
select * from table name;
Basic condition query:
select * from Table name where conditions;
Fuzzy query:
select * from table name where name …like ‘%devic
Access MySQL Remote Databases from Command Line
I have a server with Rackspace. I want to access the database from the command line of the local machine.
I have tried:
mysql -u username -h my.application.com -ppassword But it gave an