SELECT ... A select in the form outfile ' file_name ' can write the selected row to a file. The file is created on the server host, so you must have file permissions to use this syntax. File_name cannot be an original file. An existing file prevents
This is the operation log of the database, such as update a table, or delete some data, even if the statement does not have matching data, this command will also be stored in the log file, including the time of execution of each statement, will also
*innodb_buffer_pool_size
If you use InnoDB, then this is an important variable. Compared to MyISAM, InnoDB is more sensitive to buffer size. Mysiam may also be fine with the default key_buffer_size for large amounts of data, but InnoDB feel like
MySQL itself supports an UPDATE statement to update multiple tables, which is sometimes a very useful feature.
multiple-table syntax
UPDATE [low_priority] [IGNORE] Table_referencesSET col_name1={expr1| DEFAULT} [, col_name2={expr2| DEFAULT}]
The MySQL Query Table Index command has two forms of command:
The code is as follows
Copy Code
Mysql> Show index from ' tblname ';Or:Mysql> show the keys from ' tblname ';
The results of running the above
Server 120G SSD hard disk space used 92%, after inspection found that the original MySQL binary log is not in time to remove, occupy a lot of space, so directly with the command: Reset master a delete clean.
The code is as follows
Error
Event Type: ErrorEvent Source: MySQLEvent Type: NoneEvent id:100Date: 2012-10-12Event: 20:42:04Users: N/AComputer: ADMINISTRATOR74Describe:Invalid (old) table or database name ' duplicate user '
For more information, the Support Center at
A simple example
1.1. Create a table:
CREATE TABLE T (S1 integer);
1.2. Triggers:
The code is as follows
Copy Code
? delimiter |Create trigger T_trigger before insert on t for each rowBegin Set @x = "Hello
A, BACKUP database: (command in DOS Mysqlin directory execution)
The code is as follows
Copy Code
Mysqldump--opt SCHOOL>SCHOOL.BBB
Note: Back up the database school to the school.bbb file, school.bbb is a text
I remember I used to write a diary in this site is a record of the master and slave MySQL Tutorial database tutorial synchronization Backup related articles, do not know that a friend has not seen, the method is very simple, is certainly can be
MySQL Tutorial SQL Length,right,char_length character processing function
LENGTH (str) Octet_length (str) Char_length (str) Character_length (str)Returns the length of the string str.
Mysql> Select LENGTH (' text ');-> 4Mysql> Select
These statements create a stored subroutine. To create a subroutine in MySQL 5.1, you must have the Create routine permission, and alter routine and execute permissions are automatically granted to its creator. If binary logging is allowed, you may
This example for you to share the Xtrabackup backup to restore the specific code for your reference, the specific content as follows
Install Xtrabackup with RPM package
# # Install Dependency Pack
yum-y Install perl perl-devel libaio libaio-
If you forget your MySQL root password, you can recover it through the following procedure.
1. Send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), and the file that holds the process ID is usually in the directory where the
Third, stop the server
To start the server manually, use Mysqladmin:
%mysqladmin shutdown
To stop the server automatically, you don't need to do anything special. BSD systems typically stop the service by sending a term signal to the process,
PHP MySQL three ways to get table field names and fields information
First give information about the tables used in this example:
Use DESC to get table field information
The PHP code is as follows:
Run Result:
Array
(
[
What is InnoDB BUFFER POOL
Computers use most of their memory to improve the performance of frequently accessed data. This is what we know about caching, which is a very important part of the system because accessing the hard disk can be as slow as
0. Delete the system surplus accountUse MySQL;Select User,host from Mysql.user;Delete from user where user= ';Flush privileges;MySQL Create account:mysqladmin-u root password ' 123456 'Take the demo library test library, respectively demo_1 and test_
With regard to the WEB programming of databases, the role of databases has become increasingly important. When talking about databases, PHP has very powerful database support functions. From FileMaker to Oracle, PHP can be seamlessly connected to
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service