MySQL

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.

Database performance is critical to a data-centric application that directly affects the performance of the program. In general, to ensure the efficiency of the database, to do the following four aspects of the work: database design, SQL statement

MySQL Copy table operation we will often use, the following will give you a detailed description of several MySQL copy tables, I hope you learn the MySQL copy table can be helpful.If we have one of the following tables:ID Username password-----------

A MySQL server, the machine unexpectedly restarts, n tables error, presumably you already know that the library engine is MyISAM, too sad, too broken, the first look at the error message:mysql> desc partition_keys; error 130  (HY000): incorrect file 

http://database.51cto.com/art/201108/280088.htm when creating foreign keys in the MySQL database , there are often some errors that can be frustrating. A typical error is: Can ' t create Table ... The error. In many instances, this kind of error

MySQL floating-point and fixed-point types can be represented by the type name plus (m,d), m represents the total length of the value, D represents the length after the decimal point, and M and D are also known as precision and scale, such as float (

HTTP://DXCNS.BLOG.51CTO.COM/1426423/367105 uses navicat for MySQL to export data from MySQL, including database table creation scripts and data(1) Export of data: Right-click---> Dump SQL fileAt this point, the export operation of the data has been

http://toptree.iteye.com/blog/812642 today, in the development of the mail system to find a lot of mail is not sent successfully, want to manually change the data. Find the MySQL date functionThe obtained pubtime is a string type, which is converted

Truncate use note due to the TRUNCATE TABLE a_table command once, take the lesson and record it as a warning!  MySQL TRUNCATE TABLE a_table command affected result description, hands-on experience command TRUNCATE TABLE a_table; The data in the

This article by show according to Lin Feng to provide friendship sponsorship, starting in the mud row World . 1 , the format of the connected database Mysql-h ip-u user name-p password; 1.1 connecting to a remote database Mysql-h 192.168.1.214-uroot-

ApacheIf using RPM package installation, the installation path should be in the/ETC/HTTPD directoryApache configuration file:/etc/httpd/conf/httpd.confApache Module Path:/usr/sbin/apachectlWeb directory:/var/www/htmlIf the source code is installed,

Errors encountered while making configuration from the server.mysql> Change Master to master_host= ' 192.168.136.129 ', master_user= ' repl ', master_password= ' 123456 ', Master_log_ File= ' mysql-bin.000003 ', master_log_pos=2610;ERROR 1201 (HY000)

Integral type data: 1.tinyint,2.smallint,3.mediumint,4.int,5.bigint.InvasiveWhen the statement was made, we found that there was a statement:Create Table main_t ( tinyint ),smallint(), meidum_id mediumint ( ),int(a), bigint());

1.mysql There are many system variables can be set, system variable settings, will cause the system to run different state. So MySQL provides two sets of commands to view the system settings and the running state, respectively. 1. System

New database: Code:Create database name;Attention:1. Database name preferably using the _db suffix, easy to identify the user database,2. User-created database only user account and root are authorized to use.Example:Create database

How to assign permissions to mysql users and mysql users 1. Create a new user in Mysql Syntax: 1. create user Username identified by 'Password '; Example: create user xiaogang identified by '20150901 '; By default, new users do not have any

Rotten mud: Learn mysql binlog configuration, mysqlbinlog This article was sponsored by Xiuyi linfeng and first launched in the dark world. 1Basic knowledge Logs record every change in the database to a dedicated file, which is called a log file.

How to correctly create a MySQL Index Indexing can improve data retrieval efficiency, reduce database I/O costs, and reduce database sorting costs. Sorting group operations mainly consume CPU resources and memory. Therefore, using indexes in sorting

Tinyint data type in mysql The mysql database defines the data type as "data type (m: Here, the number m represents different meanings in different data types. The integer system has limited the value range. For example, tinyint occupies one byte

Mysql inserts data in batches using the Stored Procedure Recently, we need to test the performance of adding, deleting, modifying, and querying more than data records in a single mysql table. Because there is no ready-made data, we construct it by