MySQL

    For example, when to export the MYSQL database of the remote server, this is what every PHP programmer, database manager, and webmaster who uses the PHP program must learn.   First, let's learn how to export the MYSQL database of the remote

Today, I just learned about the mysql command in the group to view the maximum number of processes opened. Let's take a look at it ~ Cat/proc/27095/limits | grep "Max open files" Command to view the maximum number of processes opened in mysql How

On percona performance conference 2009, several Yahoo engineers brought a "Efficient Pagination Using MySQL" report, which has many highlights. This article is a further extension based on the original article. First, let's take a look at the basic

I always thought that the two functions serve the same purpose. Some differences have been found through simple tests. Admin Mysql> select * from admin; + ----- + ----------- + --------- + | Uid | name | pass | + ---- + ------------ + --------- + | 1

1. Copy the table structure and data to the new tableCreate table new table select * FROM old TABLEThis method will copy all content in oldtable. Of course, we can use delete from newtable; to delete it.However, the worst thing about this method is

View the encoding: show variables like 'collation _ % '; show variables like 'character _ set _ %'; Modify: MySQL: Modify the default character set and convert the character set (MySQL 5.X) 1. modify the default character set of the MySQL database

1. Use the SHOW statement to find out the current database on the server: mysql> show databases; + ---------- + | Database | + ---------- + | mysql | test | + ---------- + 3 rows in set (0.00 sec) 2. CREATE a DATABASE abccs mysql> CREATE Database

MySQL supports a large number of column types, which can be divided into three types: Number type, date and time type, and string (character) type. This section first provides an overview of available types, summarizes the storage requirements for

Description of troubleshooting of Chinese garbled MYSQL in XAMPP: After XAMMP is installed, the MySQL database is built in. Create your own database-create a database table-add Chinese records to the table through jdbc-all the Chinese characters

Two servers A: 192.168.1.1B: 192.168.1.2A (master) Serve as the master server to provide synchronization services for B (slave. Shut down the database of server A and server B at www.2cto.com, and export the database of server A to server B to

First, stop MYSQL services.Start -- run -- services. msc -- find the MySql service, stop the default installation location of mysql: C: \ Program Files \ MySQL Server 5.0, and modify the my. ini file.Go to the MySQL installation directory, find my.

Quick de-duplication Analysis of tens of millions of mysql merged tables target: existing tables a and B, merge the data in the two tables to the c table. The data volume in Table a and table B is about 2 million. Basic information operating system

Modify mysql Character Set and default storage engine 1. modify mysql character Set mysql Database Current character Set mysql> show variables like 'character % '; + metrics + | Variable_name | Value | + metrics + | character_set_client | latin1 |

Summary of several uncommon SQL statements in MYSQL // LOAD DATA INFILE 'data.txt 'INTO TABLE table2FIELDS TERMINATED ','; // export the empty library table structure mysqldump-d-u xxx-p resin_log>/temp/dump. SQL // view the MYSQL configuration. The

Method 1: SELECT... INTO OUTFILEmysql> select * from mytbl into outfile '/tmp/mytbl.txt'; Query OK, 3 rows affected (0.00 secure1_mytbl.txt contains the following content: mysql> system cat/tmp/mytbl.txt 1 name12 name23 \ N the data in the exported

MySQL-(2) data stored by the storage engine in mysql is stored in files or memory using different technologies. These technologies use different storage mechanisms, indexing techniques, and locking levels to provide users with different choices.

MYSQL no repeated insert data UPDATE syntax & SQL statement: if the primary KEY is repeated during insert, the Statement ON DUPLICATE KEY UPDATE is specified, in this case, the unique or primary index will not insert content that is duplicated with

After MySQL 5 is installed, you cannot Start service to fix MySQL 5.1.48 or MySQL 5.5.8. After the configuration is completed, click Execute, but you cannot Start service. Check that the MySQL System Service has been added but cannot be started. At

The mysql numeric processing functions floor and round are in mysql. when processing a numeric value, a numeric processing function is used. For example, if there is a float value of 2.13, you only need an integer of 2, the following functions are

When mysql is connected to a program, a disconnection may occur if the connection wait time (wait_timeout) is not reached within a certain period of time, which is related to the database configuration. The default mysql connection wait time is (2880