MySQL

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-----------

The following is a detailed description of the use of MySQL ifnull function, for your reference to learn, if you have encountered similar problems in MySQL ifnull function use, may wish to see.MYSQL ifnull (EXPR1,EXPR2)If EXPR1 is not Null,ifnull ()

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 

Question: How do I design or optimize a big table for tens? In addition, there is no other information, the personal feel that this topic is a little fan, have to simply say how to do, for a storage design, must consider the business characteristics,

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

1.1. isolation level of a transactionThe ANSI SQL standard has four levels of transaction isolation, but few database vendors follow these standards. The four isolation levels are: name 1

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

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,

http://zhangxugg-163-com.iteye.com/blog/1666673The federated described in this article belongs to MySQL's special engine, which can be used to map local data tables to a remote MySQL data table to solve a wide range of cross-machine connection

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());

I. OverviewMySQL's lock mechanism is relatively simple, and its most notable feature is that different storage engines support different locking mechanisms. For example, the MyISAM and memory storage engines use table-level locks (table-level

command: show Processlist;if it is the root account, you can see the current connection for all users. If you are a normal account, you can only see the connection you are occupying. show Processlist; only the first 100 are listed, if you want to

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

BEGIN#遍历占领野地表还原军队 #UpdateArmforceSet Number=NumwhereTroopsid=(SelectId fromTroopswhereIsfrist=1 andCityid=Cityid)DECLARETIdDECIMAL( +,0)default -1; #occupyWild表的TroopsIdDECLARECidDECIMAL( +,0)default -1; #occupyWild表的CityIdDECLARETemp_tidDECIMAL( +

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