MySQL basic SQL statement Encyclopedia (Basic Text)

1. Description: Create DatabaseCREATE DATABASE Database-name2. Description: Delete DatabaseDrop Database dbname3. Description: Back up SQL Server---to create a device that backs up dataUse masterEXEC sp_addumpdevice ' disk ', ' testback ', '

Add MySQL 5.6 from node Slave

MySQL version: 5.6.36Xtraback Edition: Version 2.4.61. Modify the master node MySQL configuration file and restart MySQLCat/usr/local/mysql/my.cnf[Mysqld]DataDir =/var/lib/mysqlSocket

MySQL installation process

Essential Tools1:linux system2:mysql installation Package http://www.mysql.com3:cmake (CMake compiled installation) Ncuress-devek (development tools default installation)Avoid port conflicts check MySQL installation situationRpm-q mysql-server MySQL

Mysql+drbd+heartbeat

Mysql+drbd+heartbeat                     Overview: DRBD One, DRBD introduction DRBD is the full name of: Distributed replicatedblock device (DRBD) distributed block device replication, DRBD is composed of kernel modules and related scripts, To build

MySQL stop and restart under Linux

First, the starting mode1. Start using the Linux command service:Service mysqld Start2. Start with mysqld script:/etc/inint.d/mysqld start3. Start with Safe_mysqld:safe_mysqld&Second, stop1. Start with service:Service Mysqld Stop2. Start with mysqld

Use MySQL under window to report undefined identifier "SOCKET"

Workaround One:This error is the My_socket fd that appears in the Mysql_com.h file when using the MySQL database in VC; Description is not my_socket undefined, only need to refer to the Mysql.h header file before referencing # include is OK, and

CentOS 7.3 Installation Mysql-5.7.18-linux-glibc2.5-x86_64

:Https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz about 600M can choose Thunder Download and then upload, Because it is intranet, I choose Thunder Download.1. Download:[Email protected] ~]# wget

Use of varchar, char, text in MySQL

After a char or varchar set length is exceeded, the string is truncated.The difference between char and varchar is that Char takes up n characters regardless of the actual value, and varchar consumes only +1 of the actual character space, and the

MySQL Gtid master-slave replication (main library online, add new Concou)

Requirements:1, the main library on-line, the main library does not stop the service under the premise of the Master from replication2. Add a new Bundle libraryOperation:1, export the data in the main library (the main library is running normally);2.

CentOS under MySQL Uninstall, install, test the whole process

MySQL UninstallYum remove MySQL mysql-server mysql-libs compat-mysql51Rm-rf/var/lib/mysqlRm/etc/my.cnfSee if you have MySQL software:Rpm-qa|grep MySQLSome words continue to deleteMySQL Installation1> If you do not have a local installation package,

Common indexes in MySQL, master, unique, full-text index differences

The MySQL index is used to quickly look for records with specific values, and all MySQL indexes are saved as B-trees. If there is no index, MySQL must start scanning all records of the entire table from the first record until it finds a record that

0708 about understanding MySQL SQL execution Order

Turn from http://www.jellythink.com/archives/924, the blog is a clear comparisonI understand that the above is the SQL execution order overall scenario. When you join the index, in fact his execution plan is a slight change, for example, just

MySQL Audit implementation method

MySQL version: 5.6.24-72.2First, the basic principle of MySQL audit function is realized through Init-connect + Binlog:Because the key to auditing is DML statements, all DML statements can be logged by Binlog.Unfortunately, the current MySQL binlog

MySQL SQL statement Execution order

SQL statement SELECT statement Query order (7) SELECT (8) DISTINCT (1) from (3) join (2) on (4) WHERE (5) GROUP by (6) having (9) ORDER by (Ten) LIMIT One, executes the FROM statement, the MySQL is executes from left

Mycat in MySQL master-slave mode (1 master 1 slave) Read and write separation and automatic switching mode verification

Experimental environmentTwo CENTOS7 MySQL5.7.12 IP addresses are: 192.168.10.36 192.168.10.37One CENTOS7 mycat IP address is: 192.168.10.31One: Install MySQL as shown here (yum installation is used here):Two: Configure MySQL, and build MySQL

MySQL Remote connection

On the remote host, I opened the MySQL service, the command line can be opened, such as the user named Root, the password is 123456. However, the remote connection with the Mysql client is reported error, such as Mysql-front reported the following

Installation of Lnmp--mysql

1. Pre-preparationCreate group: Groupadd MySQLCreate User: Useradd-r-g MySQL MySQLCreate MySQL folder in data store folderMkdir-p/usr/www/mysql/dataYum install cmake-y #一般没有cmake and need to be installed.2. Download the source code: Http://dev.mysql.

Python MySQL Learning--simple additions and deletions to seal the installation

1. Adding and deleting to seal the mysqlhelper.py1 ImportPymysql as PS2 3 classMysqlhelper:4 def __init__(self, host, user, password, database, CharSet):5Self.host =Host6Self.user =User7Self.password =Password8Self.database

Add timed tasks to Linux and periodically export MySQL database data.

1.crontab-e #编辑属于当前用户的定时任务.2. Edit: Key I: Writing tasks such as: */1 * * * */usr/local/hy_mysql/bin/mysqldump-uroot-proot--socket=/tmp/mysql3305.sock Test DM001>&G T /usr/local/sql_bak/dm001.sql >/dev/null 2>&1 #每隔一分钟导出数据库中的数据.3. Press ESC---": Wq #

MySQL manual, mysql5.6 Chinese manual

MySQL manual, mysql5.6 Chinese manualMySQL configuration file The configuration file used by MySQL is my. ini, which is in the installation directory. MySQL common configuration parameters: 1. default-character-set: default character set of the

Total Pages: 3233 1 .... 1744 1745 1746 1747 1748 .... 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.