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.*
Category: Database
The database is a warehouse that organizes, stores and manages data according to the data structure. It was created more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management is no longer just It is to store and manage data, and transform it into various data management methods required by users. There are many types of databases, from the simplest tables that store various data to large-scale database systems that can store massive amounts of data. They have been widely used in all aspects.
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
How to find an Apple CMSV10 administrator password?
I forgot the administrator password of the Apple cms backend. Many friends may encounter this problem, then I will briefly share how to retrieve the administrator password for Apple CMS V10. Apple
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
MySQL looks back
The difference between Mysql and Oracle 1. Instance difference Mysql is a lightweight database, open source and free. Oracle is charged and the price is very high.
One instance of Mysql can