One, inner connection (INNER join)1. Equivalent connectionOverview : The value of the connection column of the two tables is compared with the equals "=", which is equivalent to the two tables when the Cartesian is executed, and the values of the
MySQL in your can ' t specify target table for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement).For example, the following sql: errorDELETE from
Do pagination for the first time (no idea what the paging process is going to do?) )Understanding: Actually is the foreground page by passing different parameters {1. The condition of the query. 2. Number of pages (Pagenum), 3 per page (pageSize)},
MySQL's paging is relatively simple, only the limit offset,length to get the data, but when the offset and length is large, MySQL performance decreased significantly1. Sub-Query optimization methodFind the first piece of data, then the ID of the
In Windows when we installed MySQL:1. The concept of a transactionA transaction is a set of SQL statement operations, and the individual SQL statements that make up this set of operations must all succeed in order to result. Any SQL statement
| table creation create table table name (field name type name constraint) # create table students ( id int unsigned primary key auto_increment not null, name varchar ( default ", age tinyint ")
First, formTable One EMPTable Two DeptTable three Salgrade;Table four annual profit statementSecond, exercise1. Identify the department with at least one employee. Show department number, department name, department location, number of departments.2.
First, let's take a look at BLOB type dataBlob type fields are used to store binary data in MySQL, the blob is a type family, including: Tinyblob, Blob, Mediumblob, Longblob, the only difference between these types is the maximum size of the storage
- increase insert into ... values (...) insert into table name; values () to include all data; insert into the table name (field); values () only need to enumerate the corresponding data;| Full column Insert Insert into studentsvalues (0, ' Guo
Defines a complex logic for batch processing of SQL statements, creating delimiter // modification terminators through a name store-- stored procedures have no return value delimiter // ---- put Terminator; Modify to//create procedure porc2 ()
MySQL master-slave replication is also known as Replication1 The principle of hisHttp://www.cnblogs.com/crazylqy/p/4065374.html2 The realization of hisHere is a topic dedicated to MySQL from the history to the development to the architecture, to the
First, the basic principle of replication Slave will read binlog (binary log file) from Master for data synchronization Steps: For detailed procedures, see : http://www.cnblogs.com/luckcs/articles/2543607.htmlIi. Basic principles of replication
Integer typeTinyint: mini-shaping, up to 256 state; use one byte storage;smallint: small plastic, up to 6556 states; use two bytes of storage;Mediumint: Medium plastic; use three byte storage;int: standard shaping; using four bytes of storage;BigInt:
Statement: The material used in this column is written by the VIP students of the Kay Academy, who has the right to be anonymous and has the final right to interpret the article; The Edith Academy is designed to promote students to learn from each
MySQL commands and MYSQL
Basic MySQL knowledge point for Computer Level 2 Examination, common MYSQL commands, details:
Common MYSQL commands (add computer second-level sites to favorites)
Start: net start mySql;
Enter: mysql-u root-p/mysql-h
MySQL 4.1/5.0/5.1/5.5/5.6/
Command differences of different versions:
show innodb status\G mysql-5.1show engines innodb status\G mysql-5.5
User @ '%' about grant authorization mysql-5.5 does not contain localhost
-------------------------------------
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