MySQL

1. Check the system status Check the status of the system by using some operating system tools, such as CPU, memory, swap, and disk utilization. Based on experience or compared with the normal status of the system, sometimes the system looks idle on

BLOB is a large file. A typical BLOB is an image or sound file. due to their size, it must be processed in a special way (for example: upload, download, or store data in a database ). According to Eric Raymond, the main idea of processing BLOB is to

Later, I was working on WordPress. I didn't know that WordPress was using the InnoDB Data Engine at the beginning, so I built a database in the original database. I didn't find any problems at the beginning, it's okay to import the SQL statement. I

Copy codeThe Code is as follows:BEGINDECLARE '@ I' int (11 );DECLARE '@ siteCount' int (11 );DECLARE '@ sqlstr' VARCHAR (2560 );DECLARE '@ sqlinsert' VARCHAR (2560); // DECLARE the variable aboveSelect count (0) into '@ siteCount' FROM tbl_base_site;

MySQL supports several storage engines as processors for different table types. The MySQL storage engine includes the engine for processing transaction security tables and the engine for processing non-transaction security tables: ◆ MyISAM manages

Regular mysql backupPut/etc/cron. hourly/Copy codeThe Code is as follows:#! /Bin/bashDUMP =/usr/local/webserver/mysql/bin/mysqldumpOUT_DIR =/data1/backup/DB_NAME = Database NameDB_USER = Database UserDB_PASS = Database Password# How much days backup

1. myisamchkTo use myisamchk, you must temporarily stop the MySQL server. For example, we want to repair the discuz database. Perform the following operations:# Service mysql stop (stop MySQL );# Myisamchk-r/absolute path of the database file/* MYI#

Statement: alter table tableName engine = InnoDB;Tables UsedCopy codeThe Code is as follows:Create table if not exists 'test '('Id' int (10) not null auto_increment,'Websitename' varchar (200) character set utf8 not null,'Websiteurl' varchar (200)

First, open the mysql console through WAMP. Prompt to enter the password. Because it is empty, press Enter. Then enter"Use mysql", Which means to use the mysql Database and prompt" Database changed. Then enter the SQL statement"Update user

Statement: UPDATETestSETAge=5 WHERE'Name'='Wang Mang' As the name implies, Wang's age is changed to 5, but the result is helpless -- The number of affected rows is 0. What's going on? The syntax is correct. It's okay ...... I changed it and removed

There are two methods available on the Internet: First:Uninstall the KB967723 patch.Log on to the server and go to control panel-add and delete programs-(check "show updates" at the top). You can see the updated KB967723 patch in it, and then

Currently, you can set options to operate the connection timeout of two client extension libraries, such as mysqli:Copy codeThe Code is as follows:// Create an object$ Mysqli = mysqli_init ();// Set the timeout Option$ Mysqli-> options

Put mysql.exe in the binary directory under mysqldirectory under C: \ WINDOWS. You can run the following command:Connection: mysql-h host address-u user name-p User Password (Note: u and root do not need to add spaces, the same is true for

Internal issues related to the mysql databaseCause delete from table where col not in (select col from table group by xx)An error is reported.What we need to do isCopy codeThe Code is as follows:Create table tmp selete col from table group by

Run the cd command on the terminal to enter the file directory.Note: here is an example of the project.1. create a project: Enter zf create project Airline in the format of zf create action project-name in the terminal. Note: You can enter zf in the

Conventions and Styles Conventions and programming StylesEvery time I want to demonstrate the actual code, I will adjust the code displayed on the screen of the mysql client and change the font to Courier, make them look different from common text

Copy codeThe Code is as follows:Mysqldump-u user-p db tab1 tab2> db. SQL RestoreCopy codeThe Code is as follows:Mysql-u user-p db Refer:1. copy backup files: (ensure that the database has no write operations (you can lock the Table). Copying files

The UDF of MySQL is a dynamic Connection Library (* Nix is called a shared library) that does not need to set the entry point ). You can call this method to debug a DLL. Now I will introduce a very simple and easy-to-use debugging method. This

MySQL error code list:1005: An error occurred while creating the table.1006: database creation failed1007: the database already exists. An error occurred while creating the database.1008: the database does not exist. An error occurred while deleting

If you forget your MYSQL root Password, you can recover it through the following process.1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). The files that store the process ID are usually located in the