First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the
The first time so close to contact the source code, a little excited, and a little overwhelmed, a lot of the source files are thousands of lines, you say how to see, there are some countless data structures, functions, classes and other messy things.
Backups are the last line of defense for data security, and for any scenario where data is lost, backups may not necessarily restore a single amount of data (depending on the backup cycle), but at least minimize the loss. There are two important
Download MySQL from official website (wget)
http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-server-5.6.30-1.el7.x86_64.rpm
http://cdn.mysql.com//Downloads/MySQL-5.6/MySQL-devel-5.6.30-1.el7.x86_64.rpm
Do not stop to do MySQL master-slave synchronization, you can use mysqldump, but this low efficiency, the use of xtrabackup to achieve this, high efficiency!One Xtrabackup installation:Yum-y Install Perl perl-devel libaio libaio-devel
By default, MySQL saves the name of the table in lowercase. One way to avoid the MySQL server lowercase problem is to start mysqld with-O lower_case_table_names=0. By default, this option in Windows is 1 and on Unix is 0. If Lower_case_table_names
Several issues encountered in the business database are resolved:1.ibdata too big problem, ibdata30g around, do backup when storage write speed is very slowAdding innodb_file_per_table=1 can modify InnoDB as a stand-alone tablespace pattern, and
The characters stored in the computer need to use the encoding set, early ASCII set, but with the development of technology, the ASCII set can not meet the requirements, there are more and more characters, such as Chinese character. Later developed
A MySQL command line tool (view Help---, or-? )1) MySQLMySQL is a simple SQL shell (with the GNU ReadLine feature). It supports both interactive and non-interactive use. When used interactively, the query results are in the ASCII table format. When
1. How to log into MySQL databaseMysql-u username-p2. How to turn on/off MySQL serviceService MySQL Start/stop3. Check the status of MySQLService MySQL Status4, how to display a number of all databasesShow databases5. How to get the names and types
One. Common MySQL command-line commands1. Start MySQL service net start MySQLStop MySQL service net stop MySQL 2. Netstat–na | findstr 3306 View the port being monitored, findstr is used to find out if there is a port in the back3. Log in to the
MySQL connection to the server from the client is not connected to the problem of the company to use MySQL to do a test, began to build a MySQL database in their own local program to connect again, did not encounter a problem connected.This time the
1. Ways to create tables1) Create the syntax form of the tableFirst, select the database:Use database name;To create a table:CREATE Table Table name (property name data type [integrity constraint], property name data type
Solution to the problem that mysql cannot connect to the database with skip-name-resolve, skipnameresolve
Mysql cannot be linked with skip-name-resolve,
Check whether MySql has used host name authorization.
Add the following two lines to the
MySQL entry (7) -- View
A view is a virtual table exported from one or more tables. A view is like a window in which you can view the data provided by the system.1. View description 1.1 view meaning
A view is a virtual table exported from one or
MYSQL is required to retrieve data from Chapter 4 of Reading Notes. mysql is required
MySQL is an open-source Relational Database Management System (RDBMS). the MySQL database system uses the most common database management language-Structured Query
Common mysql commands and common mysql system commands
Recently, some mysql commands were often used during my internship, so I made some preparations:
Solve the character garbled problem: display Chinese characters rather than garbled characters:
MySQL database InnoDB engine server power-off data recovery method, mysqlinnodb
Note:
An online MySQL database server suddenly loses power, causing system failure to start up. After you reinstall the system, find the previous MySQL database
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