MySQL

Since the PHP and MySQL has a certain understanding, I will be in the company's huge Excel database eyeing, want to secretly "share" the confidential business data, while pondering how to get the hand, while thinking about how to convert into a

Table structure: The ID field is the category ID, the Name field is the category name, and the father_id field is the category path for the Id,path field of the parent category (Save the Class ancestor, Isdir to determine whether it is a directory (

Linux Source code installation apache+mysql+php /******************************** I am Pefocus,pefocus is me!********************************/ Compilation environment: RedHat Enterprise as 5, open Sellinux Required Software:

Because the xtrabackup version installed on the server is relatively old and does not support hot backup of mysql 5.7, you need to upgrade the version or deploy version 2.4.1 on the new server. Here we download the latest

Scenario: The file system space in the mysql installation directory is insufficient, and some tables have too much data. You can use the soft connection method to move some tables that occupy a large space to other file systems, and ensure that

Today, old Zuo is preparing to migrate the website of a customer from the company to another server, and back up the latest webpage files and export the database according to the normal operation, then, create a site and database wget on the new

For a long time, I have never been familiar with MySQL transactions and locks. I was interested in a problem I encountered when I checked my colleagues' troubleshooting, however, there are still some gains.First, we initialize the data. The

Open the my. ini configuration file in the mysql database and findWait_timeout: the wait_timeout parameter is 5.Wait_timeout = 5This means that the connection will be automatically disconnected in 5 seconds, and the data submitted will come out of

Innodb is the MySQL storage engine for transaction security. It is the preferred storage engine for core tables in oltp applications.The first storage engine for MySQL to support transactions is BDB.MySQL's first complete support for ACID

1. Partition column index constraintsIf the table has a primary key or unique key, the partition column of the partition table must be included in the primary key or unique key list to ensure the efficiency of the primary key, otherwise, the same

In the production environment, we generally adopt mysqldump full-database backup, but this is not available for large databases, because mysqldump is a logical backup, and the efficiency of backup and recovery is slow, if a critical value is

In the project development process, you may need to open your own database to others, but to ensure security, you cannot open other databases on your server at the same time. You can create a new user and grant the user specific database permissions.

1. Query duplicate records based on a single field (name) in the tableSELECT * FROM user WHERE name IN (SELECT name FROM user group by name having count (name)> 1 );2. Delete duplicate records based on a single field (name) in the table. Only

Learn to use phpMyAdmin, a Web-based database management tool.If appropriate tools are used, MySQL database management will be quite simple. To use the MySQL command line method, you must be familiar with MySQL knowledge and use the same SQL

There are two ways to install php, one of which is used to become an apache component.Download php: php-5.1.2-win32 and php-5.1.2-installer.exe I just got down these two ~~~Copy the dll file in php to windows/system32, and change php. ini-dist to

// Save the image to the database The code is as follows:Copy code If ($ Picture! = "None "){$ PSize = filesize ($ Picture );$ MysqlPicture = addslashes (fread (fopen ($ Picture, "r"), $ PSize ));Mysql_connect ($ host, $ username, $ password) or

The code is as follows:Copy code $ ObjPHPExcel-> setActiveSheetIndex (0)-> SetCellValue ('A1', iconv ('gbk', 'utf-8', 'Chinese hello '))-> SetCellValue ('B2', 'World! ')-> SetCellValue ('C1', 'Hello ')-> SetCellValue ('D2 ', 'World! '); // Use

The code is as follows:Copy code -Select-$ SQL = "select * from ptypes where sid = 0 and ssid = 0 ";$ Result = mysql_query ($ SQL, $ conn) or die ("An error occurred while returning the data record! ");While ($ row = mysql_fetch_object ($ result )

Note that the encoding of the database tutorial should be the same as that of the txt document during import, or the garbled problem may occur.// Verify the file type and errorIf ($ _ FILES ["insert_first"] ["type"] = "text/plain "){Echo "Step 1: