Title, recently done a project, demand is like this, write a functional module, to achieve batch import, save time for customer service (well, demand is demand). Fortunately, the inserted data is a number of consecutive numbers, so you can
One, multi-table connection query# Focus : outer link Syntax select field List from table 1 Inner | left | Right join table 2 on table 1. field = Table 2. Fields;1, Cross link: No matching criteria are applicable. Generate Cartesian Product
One, CONCAT () functionThe CONCAT () function is used to concatenate multiple strings into a single string.Use data table info as an example, where select Id,name from Info LIMIT 1, and the returned result is+----+--------+| ID | name |+----+--------
1. Assume that there are already mysql-5.5.10.tar.gz and cmake-2.8.4.tar.gz two source files(1) Install CMake First (mysql5.5 is compiled by CMake later)[[email protected] rhel5 Local] #tar-zxv-f cmake-2.8.4.tar.gz[Email protected] rhel5 Local] #cd
Create student table IF not EXISTS ' student ' ( ' id ' int (4) unsigned not NULL auto_increment, ' name ' varchar (12) Not null, ' sex ' enum (' Male ', ' female ') not null default ' male ', ' age ' tinyint (4) ' is not null default ' ' ', '
The previous article briefly describes the workflow, prerequisites, and constraints of MySQL group replication, and compares the features of the traditional asynchronous replication set semi-synchronous replication. This article describes the
The database needs to accommodate a variety of languages and characters to support different character sets (Character set), and each character set has its own collation (Collation).One. Character SetCharacter set, which is a collection of encodings
Today I think about some of the configuration of MySQL, and later on the configuration of MySQL and Tomcat-related content will be added here. Tomcat:1. Change the memory (to set up Tomcat memory to resolve memory overflow issues): Install Tomcat,
When using MySQL data export for backup, the entire table of data is backed up, sometimes just want to back up part of the data, this time can use the following methods:1. Use INSERT into and select to combine:Insert into Selectfrom where>= "- 9-
MySQL User rights action1. Create a userMysql-urootCreate DATABASE Zabbix default CharSet UTF8;Grant all on zabbix.* to [email protected] identified by ' Zabbix ';#查看权限Show grants for [email protected];Use MySQL;SELECT * from user where user= '
/*1. Check out all employees with department number 30*//*Analysis: 1). Column: No column is specified to query, so all column 2 is queried. Table: Only one table, Emp3). Condition: Department number 30, i.e. deptno=30*/SELECT * fromEmpWHEREDeptno=
Multi-table OperationFOREIGN KeyWhat is a foreign keyA foreign key refers to a column or columns that reference another table, and the referenced column should have a PRIMARY key constraint or a uniqueness constraint.Foreign keys are used to
ViewView OverviewA view is a table that is exported from one or several basic tables and can operate as a basic table. Only view definitions are stored in the view, not the data corresponding to the view.If the data for the base table changes, the
A query for numeric data:SELECT * from Tb_name WHERE sum > 100;Query predicate:>,=,,!=,!>,!,=Two query stringsSELECT * from tb_stu WHERE sname = ' Xiao Liu 'SELECT * from Tb_stu WHERE sname like ' Liu 'SELECT * from Tb_stu WHERE sname like '%
A Download mysql-5.7.18
Website address: https://dev.mysql.com/downloads/mysql/
2. Download Mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar (RMP file)Two Install (green area is the command executed on Linux)1 Uninstall mariadb-lib prior to
1. Download MySQL for mac:https://dev.mysql.com/downloads/installer/2. Double-click mysql-5.7.17-macos10.12-x86_64.dmg to Unzip, double-click mysql-5.7.17-macos10.12-x86_64.pkg to install3. Continue, Continue, Agree, Install, enter the administrator
Detailed analysis of SQL Execution steps and SQL Execution steps
Detailed analysis of SQL Execution steps
First, let's look at the sequence of statements executed.
(8)select (9)distinct A (1)from Ta (3)join Tb (2)on XXX (4)where XXX (5)group by XXX (
Explore mysql paging performance and mysql Paging
Several common paging methods:
1. Escalator Mode
The escalator mode generally only provides the previous or next page mode in navigation. Some products do not even provide the previous page function,
Comparison between Datetime and Timestamp in Mysql, datetimetimestamp
In mysql, the three types of date, datetime, and timestamp (if int is used, four types) are easy to confuse. The following compares the similarities and differences between the
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