1: Download the binary installation package (make sure no MySQL database server is installed): mariadb-10.2.12-linux-x86_64.tar.gz, mariadb-10.2.12.tar.gz.2: Create a System account specify the shell type (default automatically creates a group with
MySQL Data1. Database definition language (data Definition language DDL)A. Alter DATABASEB. Create DatabaseC. Drop databased. ALTER TABLEE. CREATE tableF. drop tableG. Rename tableH. CREATE indexI. DROP Index2. Data manipulation Language (DML)A.
First, view all tables in the current databasemysql> use dbdatabase changedmysql> show tables; Empty Set (0.00 sec) #表示db数据库下无数据表.Ii. Establishment of the tableCREATE TABLE customers (ID int unsigned NOT NULL auto_increment,name varchar (in) Not
MySQL> select mod (29,9);//Modulo function+-----------+| MoD (29,9) |+-----------+| 2 |+-----------+row in Set (0.00sec)MySQL> select mod (29,2);+-----------+| MoD (29,2) |+-----------+| 1 |+-----------+row in Set (0.00sec)MySQL>
The concat () function is used to concatenate strings.Exact query: SELECT * from user where name= "Zhangsan"fuzzy query; select * from user where name is like "%zhang%"In actual use, the condition is passed in as a parameter. So we use the concat ()
1, inner connection inner JOINAn inner connection, also known as an equivalent connection, inner join produces a set of data that conforms to both A and B tables.INNER JOIN syntaxSELECT * FROM A inner join B on a.name = B.name;2, natural connection
The scenario is as follows:"Today's front-end suddenly said, I need to make a judgment, can not repeat the collection, I like the neck of the icy shudder, so think what I should do?" Why did she think that I didn't think it was my job?Think of three
Get the number of rows for a single tableUse COUNT (*) or COUNT (1)1 SELECT 2 COUNT (1) as Count3from4 table_name;Execution resultsGets the number of rows for two tablesCombine the result set of each select query with unionFor example, to
Table structure replication (with data)CREATE TABLE New SELECT * FROM oldTable structure replication (without data)CREATE TABLE New SELECT * from old where 1=2This gives a where condition 1=2 is to give the data to an empty tableTable structure
MySQL mainly provides 2 ways to index: B-tree index, hash indexThe B-Tree index has the ability to range lookup and prefix lookup, and for a B-tree with n nodes, the complexity of retrieving a record is O (Logn). Equivalent to two points to
Install, configure MySQLRefer to previous steps to build MySQL serviceTo make the experiment convenient, we configured two MySQL services on the same machine (running two ports)cd/usr/local/; Cp-r MySQL mysql_2; CD mysql_2;Initialize
When using the MySQL database, you often encounter a problem that is "Can not connect to MySQL server." Too many connections "-mysql 1040 error because the number of connections that have not yet been released to MySQL has reached the maximum MySQL
1. Log in to MySQL2. Modify the MySQL password3. Exit MySQL4. View the current database5. View the tables in the current library6. View the structure of the table7. Create a new library8. Create a new table9. Deleting a library10. Delete a table11.
Xtrabackup backup MySQLMysqldump is based on a logical backup, which is equivalent to re-executing the SQL statement. Xtrabackup is equivalent to a physical backup of a file.Installation dependencieswget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_
1tinyint small~ medium~ int big~ float double Dec (m,d) fixed-point number range is determined by MD for bit (M) bit type bit (1) bit (64).2zerofill padding 0 such as ALTER TABLE T1 modify ID1 int zerofill;1 becomes 000001 the assumption is that int
Mysql stored procedure,
Create a stored procedure
1. Create a stored procedure without parameters.
Delimiter // # The default end mark of mysql is a semicolon, and now it is changed to two slashes. Create procedure pro_student () begin delete
Mysql exercise questions,
Table Structure and data: http://www.cnblogs.com/wupeiqi/articles/5748496.html
Question:2. query the student ID of all students whose score is higher than that of the "physical" course;1)Select A. student_id, biological
Mysql database multi-source replication solution and mysql database solution
Overview
Currently, mysql databases in the production environment are distributed on two servers. If the configuration is simple from a single master-slave perspective, the
Mysql table and constraint operations, mysql constraint operations
By default, the Data Engine and character set are used to create a table. For example, to create a student table, the Code is as follows:
Create table students (id int unsigned
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