MySQL

Connection: mysql-h host address-u user name-p User Password (Note: u and root do not need to add spaces, the same is true for others)Disconnected: exit (Press ENTER) Create authorization: grant select on database. * to username @ login host

After a large amount of data is deleted from your database, you may find that the size of the data file is not reduced. This is because fragments are left in the data file after the delete operation. Discuz! The data table optimization function is

Sqlite provides some C function interfaces that you can use to operate databases. By using these interfaces, you can pass some standard SQL statements (in char * type) to the sqlite function, and sqlite will operate the database for you. Sqlite is a

This chapter briefly describes the problem of multi-table queries encountered during instance development.It mainly describesSelect A. *, B. *, C. * from A, B, CAndSelect A. *, B. *, C. * from Table A inner join table B on A. id = B. id inner join

Absolute value functions ABS (x) and circumference rate functions PI ()Copy codeThe Code is as follows:Mysql> select abs (0.5), ABS (-0.5), PI ();+ ---------- + ----------- + ---------- +| ABS (0.5) | ABS (-0.5) | PI () |+ ---------- + ----------- +

You have completed your brand's new application, and everything works like a charm. To use your network. Everyone is happy.Then, suddenly, an explosive user killed your MySQL server and your website was closed. What's wrong? How can you stop it?The

1. Local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:Copy codeThe Code is as follows:Cd/data/home/mysqlbakRq = 'date + % Y % m % d'/Usr/local/mysql/bin/mysqldump sqldb -- flush-logs-uroot-p123456 --

Modify the MySQL password:Copy codeThe Code is as follows:Mysqladmin-u root-p password 123456Mysqladmin-u username-p old password New password Forget the MySQL password:Copy codeThe Code is as follows:Chown-R mysql: mysql/var/lib/mysql/Etc/init.

When the mysql client connects to the mysql server (the process is mysqld), mysqld creates a new thread to process the request. This thread first checks whether the host name is in the host name cache. If not, the thread tries to resolve the host

DATE_FORMA T (date, format) format the date or date and Time Value Based on the format string, and return the result string.You can use DATE_FORMAT () to format the DATE or DATETIME value to obtain the expected format. Format the date value based on

Preface: With the popularization of innodb, innobackup has become a mainstream backup method. Physical backup can easily meet all database recovery requirements when creating a new slave.However, when a single table is accidentally deleted or a

The number of split fields must be limited. Therefore, it is impossible to store an infinite number of characters in a string.The table to which this field belongs is associated with this field. It must be a one-to-many relationship.For example, the

After configuring MySQL 5.1.48 or MySQL 5.5.8, click Execute, but the Start service step is not completed. Check that the MySQL System Service has been added but cannot be started. At this time, we can use the Event Viewer to see several MySQL

Although order by does not match the ORDER of the index, the index can still be used, as long as the unused index part and all the additional order by fields are included in the WHERE clause.Use the index MySQL OrderThe following queries use indexes

Recently, we have studied the implementation of MYSQL random extraction. For example, to randomly extract a record FROM the tablename table, the general syntax is: SELECT * FROM tablename order by rand () LIMIT 1.However, I checked the MYSQL

Recently, MySQL on Windows 2003 experienced a failure in connecting to the database when it was running normally many times. This problem occurs when it was unable to connect to the database or stop or restart MySQL. Restarting the database also did

I. Purpose: To synchronize the MySql database on the master server to the slave server, so that operations on the master server can be instantly updated to the slave server, this prevents the primary server from being unable to be used due to an

1. Data capacity: the total number of data records and the total number of bytes of each data record within 1-3 years;2. Data items: whether there are large fields and whether the values of those fields are updated frequently;3. SQL condition for

I felt that the code was a little messy, and the comments and codes were written at random. There seemed to be no uniform specification, and there were also differences in the Code styles in different files. Maybe Mysql had gone through a lot of

Method 1: Go to the MYSQL installation directory and open the MYSQL configuration file my. ini or my. cnf to find max_connections = 100 and change it to max_connections = 1000 to restart MYSQL.The first method is recommended for ease of modification.