MySQL

has been used in the 5.1 version, because the new business needs 5.6, installed and made notesMySQL5.6 some new features:InnoDB can now limit the amount of memory consumed when a large number of tables are open (a third party already has

[ERROR]/usr/sbin/mysqld:the table ' cps_effect_confirm_log_1301 ' isToday to a database recovery data, is a 25G library, in the execution of half is, the occurrence of such an errorOne, view the disk space 'DF-DH see that the MySQL directory (not

1. Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;+----------+| Database |+----------+| MySQL || Test |+----------+3 Rows in Set (0.00 sec)2. Create a database Abccsmysql> CREATE DATABASE

A problem needing attention1. When the database field is a blob type, the setbinarystream (int,inputstream,int) method in PreparedStatement must be used;2. When the database field is longblob type, you must use the setbinarystream

Today suddenly found that we have many tables in the database, suffix named "Copy", is estimated to be a direct copy of the navicat caused, and then to those with the same suffix name of the table to delete, if a choice will be troublesome, the

---restore content starts---error:2014 Commands out of sync; You can ' t run the This command nowI'm really drunk with this error number.Always tangled in why the stored procedure is executed, the commit operation is no longer found in the log of

MySQL forgot root password solution:# vi/etc/mysql/my.cnf (added under [mysqld])Press A or I to enter the compilation modeSkip-grant-tablesPress the ESC key to exit the compilation mode: Wq (Save and exit)# service MySQL Restart# MySQL> show

The way to examine the engine is to use mysqlshow, a tool that displays database information at the command line. Mysqlshow is available in the MySQL client installation package. To use mysqlshow, you need to provide the MySQL server login

[Warning] '--log_slow_queries ' is deprecated and would be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.1. Modify the configuration

A MySQL backup related command:MYSQLDUMP-H host name-P Port-u user name-p password (–database) database name > file name. sqlCommands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlbacking up the

Objective:If your database file is large, you may need to take up a lot of server resources when backing up, so the webmaster should try to choose the minimum period of time to perform automatic backup commands, such as 4-5 o ' Day in the morning.

CentOS Installation Mysql-proxyCentOS Installation Mysql-proxymysql-proxy的用处就不再说了mysql-proxy依赖libevent,lua,glib2等几个软件So before you install it, firstyum install lua-develyum install glib2-develLibevent I use source code installation,Download

Common statements in MySQL:1: Create a table with self-growing primary keyDROP TABLE IF EXISTS user_login;CREATE TABLE User_login (user_id INT UNSIGNED not nullauto_increment,User_name VARCHAR () DEFAULT NULL,PRIMARY KEY user_id) Engine=myisam

/** * Download Voice * Remarks: * @throws Exception */public void Downloadyuyin () throws Exception {String Voiceid = Getrequest (). GetParameter ("Voiceid");InputStream InputStream = Voiceservice.findinputbyvoiceid (Voiceid);String realPath1 =

Server variables for MySQLThe MySQL server maintains two major classes of variables, one server variable and the other state variable. whichServer variables: Define MySQL server run characteristics1. mysql server variables can be divided into global

Original: MySQL stored procedures and common functionsA. function1. Mathematical FunctionsCeil () into a roundingSELECT ceil (1.2); 2Floor () Rounding and roundingSELECT floor (1.9); 9MoD take remainder (modulo)SELECT MOD (3,8); 3--3 to 8

1. About Query Caching Take a look at 2 examples directly:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4C/C1/wKioL1RE1_aQWzaqAAC-tRq76Ak323.jpg "title=" Mysql13.png "alt=" Wkiol1re1_aqwzaqaac-trq76ak323.jpg "/>650) this.

Use Java to access images and other types of files in the MySQL database1. Notes 1. When the database field isBlobType, must usePreparedStatementInSetBinaryStream (int, InputStream, int)Method;2. When the database field isLongblobType, must

Mysql DATA export Permissions There are many ways to export mysql data, such as mysqldump, mysql-e 'SQL'> file, which can easily export data. However, when using a common user to export data, an error occurred. 1 Select * into outfile

Basic mysql knowledge1. Why use the database:(1) reducing storage data redundancy(2) Higher Data Consistency(3) storage data can be shared(4) standards that can be followed by Databases(5) easy to maintain data integrity(6) Data Security2. In the