MySQL

Copying recordsLower case-insensitive functionsPassword encryption function CREATE TABLE Employee> CREATE TABLE employee (ID int,name char (), AGI int,sex enum (' M ', ' F '), Department char (10));> INSERT into employee values (g, ' John ', ', ' m

Root account permissions are lost we can hardly do a lot of things, today this article to introduce you to the MySQL database root account permissions to solve the problem, I hope the article can help you. There are a lot of database operating

When are we going to use the copy table? For example: I now operate on a table, but I am afraid of accidentally delete data, so in the same database to build a table structure, table data is the same table for backup. If use mysqldump compare

MySQL has a function is log down to run the slower SQL statement, the default is not this log, in order to open this function, to modify the my.cnf or in the MySQL boot when the add some parameters. If you modify inside the MY.CNF, add the following

There are three standard loops in the statements of the MySQL stored procedure: The while loop, the loop loop, and the repeat loop. There is also a non-standard way of cycling: GOTO, but this cycle is best not to use, it is easy to cause confusion

1, the MySQL database does not have an incremental backup mechanism, when the amount of data is too large backup is a big problem. Fortunately, the MySQL database provides a master-slave backup mechanism, which is to write all the data in the

Author:skate Time:2013/04/11 MySQL's sql_mode reasonable setting Sql_mode is a very easy to ignore variable, the default value is null, in this setting can allow some illegal operations, such as allowing some illegal data insertion. This value

Workaround One: MySQL installation when the code, Look at the My.ini, there's no [MySQL] Default-character-set=utf8 [Client]Default-character-set=utf8 [Mysqld]Default-character-set=utf8 set up when creating a table: DROP TABLE IF EXISTS '

1005: Failed to create table 1006: Failed to create database 1007: Database already exists, failed to create database 1008: Database does not exist, delete database failed 1009: Unable to delete database file causes database failure to be

The use of select for update in MySQL must be for InnoDB, and in a transaction to work. The criteria for a select are different, with row-level or table-level locks. Because the InnoDB preset is Row-level lock, MySQL executes Row lock (only the

This article mainly introduces the PHP connection is not MySQL but the MySQL command line operation of the normal solution, the need for friends can refer to theFailure Status: PHP Web Connection MySQL failed, but at the command line through the

Some MySQL publications have made changes to the structure of the system tables in the MySQL database, adding new permissions or attributes. When you update to the new version of MySQL, you should also update the system tables to ensure that their

The MySQL plug-in storage engine is a component in the MySQL database server that performs actual data I/O operations for the database and allows and enforces a specific set of attributes for special application requirements. One of the main

This article mainly describes the way in which MySQL responds to a disk full error (such as "No remaining space on the device"), and how to respond to a quota error (such as write failure or "Reach User screen limit"). The content described in this

First, limit the concurrent processing of innodb. If innodb_thread_concurrency = 0 can be changed first to 16 or 64 to see machine pressure, if Very large, first changed to 16 to let the machine pressure down, and then gradually increase to adapt

1. Overview There are two ways to import a MySQL database: 1 lead out the database SQL script, and then import; 2 directly copy the database directory and files. In the case of different operating systems or versions of MySQL, the method of

MySQL establishes the database using the Create command: New Database Example: to MySQL highest admin login, in mysql>create database XXXXX; XXXXX is the database name. How to create a user in MySQL so that the user has full permissions to the

PHP Query The full code of the MySQL database, when used, please note that the user name and password in the connection statement are modified. $link = mysql_connect (' localhost ', ' root ', ' 123456 ')//Fire tip: Please change the username and

1. Close the databaseScript: [[email protected] etc]# service MySQL stop2. Use script: Mysqld_safe--skip-grant-tables start DatabaseStarting a database with/usr/bin/mysqld_safe--skip-grant-tables&3. Use a blank password to enter the database (MySQL

1. Introduction to the IndexAn index is a special database structure that you can use to quickly query specific records in your data.The indexes in MySQL include: normal index, uniqueness index, full-text index, single-column index, multicolumn