SQL query result export and file import in MySQL

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

Remove binary log files from MySQL free disk space

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

MySQL Write insert data optimization configuration

*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 A statement to update multiple tables method

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}]

Commands for MySQL query table index Show

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

Delete MySQL binary log specific method

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

MySQL appears Invalid (old) table or database name ' duplicate user ' solution

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 of a trigger in MySQL

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

MySQL Import Export common commands Introduction

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

Backup method of master-slave synchronous data in MySQL database

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 SQL Length,right,char_length character processing function

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

A method of creating and applying MySQL function functions

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

Mysql uses Xtrabackup for backup and restore operations _mysql

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-

How to restore the Mysql root password _mysql

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

Start and stop of Mysql Server (ii) _mysql

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 the name and field information of a table _php tips

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 ( [

MySQL innodb_buffer_pool_size: Setting the best memory value

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

To solve the MySQL clean table times 1701 wrong way

Empty tables with foreign KEY constraints The Times error 1701 (42000) Cannot truncate a table referenced in a FOREIGN KEY constraint (' laravel-test '. ' Bl_role_user ', constraint ' Role_user_role_ Id_foreign ' foreign KEY (' role_id ')

Play MySQL Licensing

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_

Php mysql dynamic web page programming error correction guide

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

Total Pages: 3233 1 .... 1369 1370 1371 1372 1373 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.