MySQL

MySql official manual Study Notes 1-MySql easy to use this is some of the notes I made when studying MySql 5.1. I hope to understand what I learned, it would be even more surprising to help you learn MySql in the same way. To connect to or

When the mysql insert update statement runs this statement, it automatically determines whether there is a duplicate primary key in the database with the record you want to insert. If yes, it is updated. If not, the insert format is as follows:

Mysqls fragment operation description: www.2cto.com every time MySQL deletes a row of content from your list, this section of space will be left blank. A large number of delete operations within a period of time will make this blank space more space

The use of pager commands in mysql is in mysql. in linux, the use of pager commands will greatly improve work efficiency. The following describes several examples: 1. First, let's take a look at the basic usage of www.2cto.com mysql> pager less

Create a new user in mysql. First, log on with the root permission to create the user SQL code create user username identified by 'Password '; www.2cto.com this user can log on to the database in any place. The SQL code create user username @ ip

How to view mysql connection parameters 1. view the details of all current connections :. /mysqladmin-uadmin-p-h10.140.1.1 processlist www.2cto.com 2. view only the current number of connections (Threads is the number of connections .) :.

Mysql Modify/revoke permissions mysql for security, by default, can only log on locally, disable the remote login permission, if you need to log on remotely, perform the following configuration: www.2cto.com (1) log on to mysql: [password can be

Skip-grant-tables: a very useful mysql startup parameter -- skip-grant-tables. As the name impliesGrant-tables is not enabled for mysql. What is the purpose? Of course, it is useful when you forget the administrator password. Www.2cto.com Operation

We recommend that you use the auto-increment ID that is not related to the business as the primary key for Innodb without special requirements.We recommend that you use auto-incrementing IDs that are not related to the business as the primary key

MySQL deadlock causes query resolution. Recently, when the database is being maintained, the data cannot be stored into the database during data parsing. The reason is that MySQL transactions have deadlocked. I restarted MySQL several times before.

The configuration of the master server (master) is simple. You only need to modify the two parts in the my. cnf configuration file. Modify the server_id attribute in my. cnf. Set the master server to 1, that is, server-id = 1. Modify the log-bin

Due to various reasons, I recently think that Ubuntu and Windows 7 systems are very uncomfortable, so I am bored with formatting the hard disk and re-installing a new Ubuntu single system. It seems that I haven't been in touch with a single-system

Mysql update statement value nested select Java code update a set col = (select col from a where id = '5') where id> 5 and id 5 and id

The value status (Stored Procedure + scheduled task) of the regularly updated table field column now has two more tables, tcm and doc; db_count: id count1 2202 3003 2204 2225 240db_date: id t_date count 1 17:04:07 2202 15:04:07 2243 11:04:07 2254 17:

Mysql for cainiao: adding, modifying, and deleting ColumnsTest data:   I. Column addition:1. alter table name column DeclarationThe added columns are at the end of the table by default.   2. You can use "after" to specify which columns are behind

Mysql re-installation steps: ① enter the control panel, in the add and delete programs, delete mysql. ② Enter regedit in the Start-run column to enter the registry, press F3 to search for mysql items, and delete the mysql items. ③ Search for

Differences between after and before in triggersAfter is triggered after data is added, deleted, and modified.The statement that is triggered is later than the monitor's add, delete, and modify operations.Before is triggered first, and then added,

Usage of standard SQL statements in mysql> set cascade update or delete: add constraint on delete cascade;> link query: syntax format: from TABLE1 join_type TABLE2 [on join_condition] [where query_condition] join_condition: Connection condition;

Mysql master-slave Database Synchronization explanation master server settings 1. Create a replication user with the replication slave permission [SQL] mysql> grant replication slave on *. * to 'repl' @ '192. 168.1.22 'identified by 'repl'; 2. Edit

In Mysql, varchar and text note Varchar occupy two bytes for each English (ASCII) character, and one Chinese character only occupies two bytes for char and one English (ASCII) character, the type of a Chinese character that occupies 2 bytes of