#主库修改my. INI[mysqld]Server-Id=2Log-Bin=Mysql-Binbinlog-Do-Db=demo# modifying My.ini from a library[mysqld]Server-Id=3Replicate-Do-Db=Demo--Restart master and slave libraries after configuration is complete#主库为从库添加用户Grant
The select sentence that appears in other SQL statements. (Nested select in select)#求出学生的平均年龄Select AVG (age) from Stu_details;#查找出大于平均年龄的数据Mysql> SELECT * from Stu_details where >18.25;#将平均数的SQL语句作为子查询放入上一条语句中Mysql> SELECT * from Stu_details where >
mysql-5.7.21 start error, Permanent solutionchmod +x/etc/rc.d/rc.local#往里面写入两条命令, which means to automatically create mysqld and modify owner permissions for bootEhco "Mkdir-p/var/run/mysqldChown-r
(1) InnoDB engine, InnoDB engine provides support for database acid transactions. It also provides row-level and foreign-key constraints. Its design goal is to deal with large data capacity of the database system.(2) Myiasm engine (the original
Rights Management:We know that our top authority manager is the root user, and it has the highest permissions. Includes select, Update, delete, update, Grant, and so on. So in general, after the company, the DBA engineer creates a user and password
bidirectional Mutual Master from step:12 machines Add a cluster machine access to the account given replication slave permissionsmysql> grant replication Slave on * * to ' rep ' @ ' 172.16.1.% ' identified by ' 1234566 ';22 Machine parameter
The newly installed CentOS 6.9 virtual machineModifying the Yum server sourcecd/etc/yum.repos.d/Rename Repo repo.bak_$ (date +%f) *Ali's Yum Library Https://opsx.alibaba.com/mirror Open Point HelpCurl-o/etc/yum.repos.d/centos-base.repo
we typically run into a business scenario like this:b host and C database in the same intranet, a host cannot directly access the C database, we can build the agent on the B host let a access C database, we use Haproxy to do this thingCENTOS7
1. Check if the MySQL server is started-| grep mysqldHow to display the following, proof has been startedlocalhost:~ mhx$ Ps-ef | grep mysqld0 1053 1 0 9:59 am ttys000 0:00.03/bin/sh/usr/local/mysql/bin/mysqld_safe--datadir=/usr/local/mysql/data--pi
This lesson first experiences the basic syntax of MySQL. Action folder (library) increaseCreate Database db1 charset UTF8;Check# View the currently created database Show Create database db1; # View all databases show databases;ChangeALTER DATABASE
With SQL statements, delete duplicates only keep oneIn thousands of records, there are some same records, how can you use SQL statements, delete duplicates1, look for redundant records in the table, duplicate records are based on a single field
Modify field arrangement position ALTER table name MODIFY field name 1 data type first| After field name 2 Parameter Description First, optional parameters Change Field 1 to the first field in the table. After field name 2 Insert Field 1 to the back
Multi-table query, SQL JOINS1. INNER JOIN inside joinsSelect S.name as student_name,t.name as Teacher_name from students as s inner joins teachers as T on S.teacherid=t.tid; /*2 table take intersection, inner connection */2. Cross-ConnectSELECT *
Querying existing databases: show databases;Operations on the database:1. Delete database: Run drop database + name;2. Add Database: Run CREATE DATABASE + name;Operations on a table:First you have to open the database of the table you want to
of the MySQL databaseExport1. Export the database as a SQL fileMysqldump database name-uroot-p > XXX.SQL Export data table structure and dataeg. Mysqldump cloudres-uroot-p > Cloudres.sql2. Export to GZ compressed fileMysqldump Database name-uroot-p |
MyISAM Storage EngineAdvantages:
Supports up to 256TB of storage space
Read data faster and consume less resources
MyISAM Engine Storage File:
TBL_NAME.FRM: Table-style definition
Tbl_name. MYD: Data files
Tbl_name.
INSERT into ' material ' (' id ', ' file_url ')SELECT id,ekm. ' File_url 'From ' extmaterial ' as EKMLeft JOIN (SELECT ' file_url ' from ' material ' WHERE ' id ' = ID) as PM on PM. ' File_url ' = EKM. ' File_url 'WHERE EKM. ' ext_id ' = Extid and
1,group by creating a groupIn MySQL group by sentence to note that must after where the order bySelect Order_code, COUNT (*) as product from order group by Order_code;2,having Packet filteringThe WHERE clause can be replaced by the having, the
installation Yum Install Mysql-serverChkconfig-list mysqld to see if the MYSQLD service is booting upchkconfig mysqld on set to bootService mysqld start mysqld ServicesSs-ntl (3306) after automatic completion, the corresponding port automatically
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