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: Mysql
MySQL is a relational database management system, developed by the Swedish company MySQL AB, and currently belongs to an Oracle company. MySQL is the most popular relational database management system. In terms of web applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.
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