Log-bin binary LogServer-id early version must be added 1-pow (2,32)-1 recommended port number +IP Last 5.6 can be modified dynamicallyServer-uuid (after 5.6) The default exists $datadir/AUTO.CNF can be modified dynamically after 5.6Log-bin-index
Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be investigated. http://oldboy.blog.51cto.com/2561410/132106
MySQL lock mechanism is divided into table-level lock and row-level lock table-level lock to the entire table back lock, write lock or read lock (Unlock tables)LOCK TABLE table_name [as Alias_name] READRelease the lock using unlock tables. Aliases
Environment: Win7+py3.4+mysql+pymysql(The following default projects and apps have been created)1.--> Engineering/settings.py (Database configuration)DATABASES = { 'default': { 'ENGINE':'Django.db.backends.mysql', 'HOST':'127.0.0.1',
1. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bitYou can also directly copy the 64-bit, download by command: wget http://dev.mysql.com/get/Downloads/MySQL-5
One, the code is as followsPackage Www.tanniu.jdbc;import Java.sql.drivermanager;import Java.sql.resultset;import java.sql.SQLException; Import Com.mysql.jdbc.connection;import Com.mysql.jdbc.preparedstatement;public class JDBC {public static void
Data types supported by MySQLData types supported by MySQL include tinyint, SMALLINT, mediumint, int or integer, BIGINT, FLOAT, double, double PRECISION, REAL, DECIMAL, NUMERIC, DATE, DATETIME, TIMESTAMP, time, year, CHAR, VARCHAR, Tinyblob,
It is well known that MySQL's DDL statements are non-transactional, that is, the DLL statements cannot be rolled back, and which include DDL statements in the transaction?Such as:#禁用自动提交SetAutocommit=off; #创建tb1Create TableTB1
MySQL has the following common functions to master:1. Mathematical Functions
Function name
Role
ABS (x)
Returns the absolute value of X
SQRT (x)
Returns the non-negative two-square root of X
Download pathhttps://dev.mysql.com/downloads/mysql/
C:\windows\system32>net start MySQL
System error 2 has occurred.
The system cannot find the file specified.
After switching to the bin directory, remove the
MySQL store emoji emoticons to use the UTF8MB4 character set, which is 4 bytes of storage, the minimum supported version is 5.5.3+, if not, upgrade to a newer version.Modify the MySQL configuration fileWindow directory: mysql/my.iniubuntu16.04
Focus on the basic-mysql index operations that cannot be forgottenBasics of MySQL Indexing I'm not here to write, I don't want to be a porter of information.Skill sharing: Workbench as a er/database modeling tool designed for MySQL. In addition to
1. View information about the operating system2. Check all MySQL RPM packages on the system and delete[Email protected] ~]# Rpm-qa | Grep-i MySQL[Email protected] ~]# yum-y Remove Mysql-libs-5.1*3. Download the RPM package required for
Fifth. mysql transaction, view, index, backup and restore I. Transaction 1. What is a transactionA transaction is a mechanism, a sequence of operations, that contains a set of database operations commands and submits or revokes an operation request
Common FunctionsCommon aggregate functions :
AVG ()
Returns the average of a field
COUNT ()
Returns the number of rows in a field
MAX ()
Returns the maximum value of a field
manipulating Databases1. Create a databasesyntax : CREATE database name ;2. View the list of databasessyntax : SHOW DATABASE;3. Select a databasesyntax : Use database name ;4. Deleting a databasesyntax : DROP database name ; manipulating data tables
The standalone server has the binary mysql5.6.20 installed, and then the MySQL multi-instance is turned onUseradd mysql-s/sbin/nologin-mMkdir/data/{3307,3308}/{data,log,binlog}-Pcd/data/3307Chown-r
Mysql connection query and Mysql connection
# Data preparationDrop table if exists class;Create table class (Class_no int (2) unsigned zerofill primary key auto_increment comment 'class number ',Class_name varchar (30) not null comment 'class name');
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