centos7.4 binary installation MySQL

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 Database knowledge system

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.

MySQL tables and data types

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 Functions and operators

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>

MySQL fuzzy query concat ()

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 ()

The centralized type difference of MySQL multi-table query

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

MySQL Insert exists

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

MySQL gets the number of data rows in the table

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

mysql-implement Sqlserver-row_number () over (partition by order by) grouping sorting function

SQL Server: withResult as ( Select SUM(F_dayvalue) asF_value,f_zz_ttbuildid,f_energyitemcode fromT_ec_energyitemdayresultwhereF_energyitemcode like '%000' andF_startday>=@ldStartDate andF_startday@ldEndDate

MySQL table structure and data replication

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: Index Combat

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 MySQL

db2

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

MySQL Maximum connections setting

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

MySQL Basic use method

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 MySQL

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_

MySQL Learning experience 2

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,

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,

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

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

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

Total Pages: 3233 1 .... 2907 2908 2909 2910 2911 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.