MARIADB Application Basics============================================================================Overview:
MySQL Introduction
★ Data Model : Hierarchical model, mesh model, relational model 、......
Relational Model:
One. mysql command-line mode settings:Desktop, My Computer, properties, environment variables, newPath= "; path\mysql\bin;" Where path is the installation path for MySQL.Two. A simple introduction to the command line into the MySQL
What you need to remember and master about MySQL finishing1.-- Show which threads are running -- View variables2. /* Database operation */------------------------------------------------------------------------------------------ ------------2. /*
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
Common MySQL command Daquan One, the connection MySQL format: mysql-h host address-u user name-p user Password 1, example 1: Connect to the local MySQL. First open the DOS window, and then enter the directory Mysqlbin, and then type the command
InnoDB supports transactions, while MyISAM does not support transactions.Definition of a transaction:When multiple users access the same data, one user may change the data in the process of other users to initiate a change request, in order to
1. Download the required MySQL version on the website, the installation version is very simple no longer sayWebsite download link2. Setting Environment variables2.1 Unzip the downloaded package and remember the path where the bin folder is located;2.
An index is a special kind of file (an index on a InnoDB data table is an integral part of a table space), and they contain reference pointers to all records in the datasheet.Note:[1] The index is not omnipotent! Indexing can speed up data retrieval
First, the installation of the necessary procedures
1, installation vsftpd
Yum-y Install VSFTPD
2. Install MySQL
Yum-y Install Mysql-server mysql-devel pam_mysql
Second, create a virtual user account
First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
The optimization of MySQL is very important. The other most commonly used and most need to optimize is limit. MySQL's limit brings great convenience to paging, but when the amount of data is large, limit performance drops sharply. Same as 10
160915.1459OverviewNoon installation success, but failed to start, it is likely that the compression package has a problem (from others), the solution of nearly one hours, did not fix, so change the program, re-download the official website
ALTERTable: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Description:when you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space. mysql-bin.000001mysql-bin.000002mysql-bin.000003mysql-bin.000004mysql-bin.000005...
There are a lot of solutions for this on the Internet, and I have adoptedWritten in more detail such as:1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer
Define the type of exception capture and how to handle it: DECLARE handler_action Handler for Condition_value [, Condition_value] ... Statement handler_action: CONTINUE | EXIT | UNDO
Transferred from: http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/18/2216279.html1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin restart/ect/
Tool Name: mysqlha_skiperror.shTool usage: For MySQL skip master and slave errorsTool Parameters: Options:-P Port Specifies ports-N number specifies that skipping errors does not specify a default of 10 times (log is logged if you do not know can be
MYSQL modifies the table name to a large-write stored procedure, mysql Stored Procedure
This article will share with you the stored procedure of modifying the table name to uppercase in MYSQL. The specific content is as follows:
1. conditions:1.1
Install mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz,glibc2.14.tar.gz in Linux
Download mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz from the official website
Create a mysql user
[root@Master home]# useradd mysql[root@Master data]# echo 'mysql'|passwd
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