DemandNow there is a demand, MySQL has a table, data growth is very fast, but the data is valid for 1 months, one months ago the record is not very important, but can not be deleted. In order to ensure the query speed of this table, a simple backup
Because of the deployment of MySQL server in the network, there is no load, the local connection speed is also normal, but the network connection is particularly slow, and finally check that the original DNS resolution problemIn MySQL configuration
For the database, everyone should know its importance, the information in the database can not have any problems, such as e-commerce site Server backend, security products, data backstage, and so on.Now I configure MySQL dual-machine synchronization,
1: Need: How long does it take for a table of 20 million data to be randomly updated with 20 rows?DROP TABLE IF EXISTS test20; CREATE TABLE test20 (id INT auto_increment PRIMARY key,money double,createdtime DATETIME) engine=innodb DEFAULT charset=
MySQL comes with some of the functions of the function is also very powerful, here to tidy up a bit of timeGets the current timestamp current_timestamp () yyyy-mm-dd hh:ii:sscurdate () yyyy-mm-ddcurtime () hh:ii:ss//The date function of the
Stored ProceduresThe Create and use permissions for a stored procedure are separate.Before creating the stored procedure, use delimiter//To change the delimiter to//and then delimiter; Change it back.Use drop procedure *; Delete stored procedure,
MySQL this thing, is a relatively easy to use database, but to be proficient, it takes a lot of effort.Here are some MySQL simple master and slave configuration, write casually, have time to change, slowly progress it.At present, the company is
Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/46559861Integer data types in MySQL can specify the display widthCreate a tableCREATE TABLE tb_emp (id BIGINT (1))The ID field has a data type of bigint (1), noting the
Information_schema database Table Description:schemata Table : Provides information for all databases in the current MySQL instance. This table is the result of show databases.Tables Table : Provides information about the tables in the database,
CREATE TABLE T (ID INT not NULL PRIMARY KEY,A INT not NULL,INDEX (ID)) Engine=innodb;An inexperienced user might want to create a primary key, and then add an index for the query to use. In fact, the primary key is indexed. So there's no need to add
Developed to see the adjustments I made and found that the index I created was actually created on another test library (Test Library 2), but why is the test library 2 still slow?So, on the test library 2, I found that the index of the 2 columns I
Stored procedures:1. MySQL 5.0 starts supporting stored procedures later.2. Our commonly used SQL statements need to be compiled and executed at the time of execution, and stored procedures are set of SQL statements to complete a particular function,
How to connect MySQL in Nodejs, here is a small demo.The first step is to install the MySQL moduleNPM install MySQLThe second step is to import the MySQL modulevar mysql = require (' mysql ');Third step to connect MySQL databasevar connection =
Requirements are: For a device, the average of every hour of the day, the average of one months per day, the more general requirement is, from the start time to the end time, every time, to find an average.The current solution is to process in the
Earlier in the work, because the customer's disk space alarm did not pay much attention to the lack of space caused by the following possible MySQL problem1 MySQL process does not come up2 MySQL does not shut down properly and must be kill-93 MySQL
Take a new machine and don't be sure which options are enabled at compile time:
view nginx Compilation parameters:/usr/local/nginx/sbin/nginx-vview Apache compilation parameters:Cat/usr/locla/apache2/build/config.niceview MySQL compilation
1. Download install MySQL, I use Mysql_5.6.24_winx64_xiazaiba, unzip to a disk below, I install here to D disk, D:\install\MySQL\MySQL Server 5.6.2. set the system environment variable , for convenience, add the MySQL Bin folder path in the path of
Overview ...1.Case Syntax2.If Syntax3.Iterate Syntax4.Leave Syntax5.Loop Syntax6.Repeat Syntax7.Return Syntax8.While SyntaxMySQL supports the,,,, IF CASE ITERATE LEAVE LOOP WHILE , and REPEAT constructs for flow control within stored programs. It
Reference URL: http://www.111cn.net/database/mysql/51146.htmThe original page ads too much, I copied the next.1. Delete from T1 where condition2. Delete t1 from T1 where condition3. Delete T1 from T1,t2 where condition4. Delete t1,t2 from t1,t2
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service