First, Preface: The basic principle of reading and writing separationThe basic principle of MySQL's read-write separation is to have master (the primary database) respond to transactional operations,Let slave (from the database) respond to select
python2.7 installation Mysql-python1. Open the following address and select Download: Mysql-python-1.2.4.win32-py2.7.exe (MD5)https://pypi.python.org/pypi/MySQL-python/1.2.42. Double click on the download good EXE program, this step if the following
MySQL Statement Specification: 1. keyword and function name all uppercase2. Database name, table name, field name all lowercase3. The SQL statement must end with a semicolon4. Comment Statement with "#"First, the operation of the database* SHOW
MySQL Max and where execution issuesExecute SQL:CREATE TABLE ' grades ' (' ID ' int (a) is not NULL auto_increment,' student_id ' int (a) is not NULL,' Subject ' varchar (COLLATE) Utf8_bin DEFAULT NULL,' Grades ' varchar (COLLATE) Utf8_bin DEFAULT
single loop inserts multiple dataDELIMITER;;CREATE PROCEDURETest_insert ()BEGIN DECLAREYint DEFAULT 1; whileY - DoInsert intoSCHOOL_SP_MJ (School_id,mojor_id,status)Values(1Y1); SETY=Y+1; END while ; Commit; END;;//can be here first to detect
1. Open terminal, enter: CD ~Will enter the ~ folder2. Then enter: Touch. Bash_profileAfter the carriage return is executed,2. Re-enter: Open-e. bash_profileThis file is opened in TextEdit (this should be a blank document if the environment variable
Why to build an index
In most cases, not using indexes, trying to improve performance by other means is a waste of time (from the inside of MySQL Technology Insider).
How does the index raise the performance?
The index can get
Today, a stored procedure is executed in the MySQL database, and because the MySQL data connection tool is not installed, it is executed in the black box and then the following problem is encountered:Always said it was my problem with the syntax of
These two days to take over, other people left the crawler found a very fun SQL script stitching.As long as your scrapy field name is the same as the name of the database field. Well, congratulations, you can copy this SQL stitching script. for
MySQL allows you to insert one or more tuples into a table that already exists.Format:INSERT into table name (property name 1, property name 2, property name 3) VALUES (VALUE1,VALUE2,VALUE3);INSERT into table name (property name 1, property name 2,
//Create a database (the end of MySQL statement in PHP is not added, because the MySQL tone in PHP can only execute one sentence at a time)Create Databasetestdatabase;//Select Database Usetestdatabase;//Create a data tableCreate TableTest_table
Bo Master Original, reproduced annotated Source:In the MySQL application, the scope of the query is a lot of time range as a condition for the scope of query, time range query hasMany kinds of writing, first summed up the Between....and ... How to
Bo Master Original, reproduced please indicate the source:The use of the IF () function in MySQL is similar to the three-mesh expression in Java, and is more useful, with the following syntax:if (EXPR1,EXPR2,EXPR3), if the value of EXPR1 is true,
Create a new table:CREATE TABLE ' tree ' ( ' id ' int (one) not NULL auto_increment COMMENT ' primary key ', ' parent_id ' int (one) ' NOT null, ' name ' varchar (ten) not NULL, PRIMARY KEY (' id ')) engine=innodb DEFAULT Charset=utf8; Create
1.Packets larger than Max_allowed_packet is not allowedA system parameter for MySQL:max_allowed_packet, whose default value is 1048576(1M),Enquiry:show VARIABLES like '%max_allowed_packet% ';Modify the value of this variable: "max_allowed_packet =
1. Create automatic backup directories and scripts# mkdir/data/mysqlbackup/# VI backdb.shAdd the following script content#!/bin/bash/usr/local/mysql/bin/mysqldump-uacm-pacm123 acmdb >/data/mysqlbackup/acmdb_$ (Date +%y%m%d_%h%m%s). sqlTar
MySQL database FAQ1. Transaction Features and isolation level:
See blog: http://www.cnblogs.com/Hangtutu/p/8016663.html2. View
View is a virtual table, which is transparent to users who use views. View andDoes not actually exist in the database.
DB2 to MySQL, DB2 to MySQL
I will not talk nonsense, and directly go to the topic...
>. The data type is generally used. The principle of the data type to be modified is to increase the scope in a small range, which is easy to understand and will
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