MySQL transaction is mainly used to deal with large-scale and high-complexity data. For example, in a banking system, to add an account, you need to add a basic account information, but also to add information related to the account, such as phone
First, step:1, unzip the green version of MySQL, and renamed to mysql5.7, such asCompare to Previous versions of 5.6, less data directory ( storage ) and My-default.ini file (configuration information)Second, installation Services1, run cmd
three paradigmsThree-paradigm definition (paradigm and inverse paradigm)1NF: Each data item is the smallest unit, indivisible, and only one data can be determined after the column is identified.2NF: Each non-primary attribute is completely dependent
One, Storage engine (table type)In general, a database is a collection of data, and a computer database can be a collection of some files on a memory or a collection of some memory data. The MySQL database, SQL Server database, and so on, we usually
A. Character type:1. Common character types are typically used for storage: Name Home address birthplaceKey instruction maximum character length characteristicsChar 255 (characters) fixed length (fixed)varchar 65532 (characters) gets longer (must
MySQL service usage1. Start the serviceStart the service:Service MySQL StartOrSudo/etc/init.d/mysql start2. Close the serviceTo close the service:Service MySQL StopOrMysqladmin-u root-p shutdownAnd then look at the discovery, the database is
One, the upper limit of the number of rows1. Official documentsThere is a limit of (2^32) ^2 (1.844E+19) rows in a MyISAM table.This is the theoretical upper limit of the number of lines in MySQL, but is actually not up to2. myisam_data_pointer_size
Mysqldump is a good command for MySQL database backup, and it comes with MySQL.- D: Only the table structure is backed up, backup files are SQL statements, only statements that create tables are backed up, and the inserted data is not backed up.- t:
Using the master-slave replication technology provided by MySQL itself, in the enterprise production scenario, it is possible to make multiple automatic backups of the log data, and realize the expansion of the database. For example, in a scheduled
Build MySQL master-slave replication installation Environment:Two CentOS 7 virtual machinesFirst, set up time synchronization environment, on the master node to build time synchronization Server master server Settings 1, install NTP[[email protected]
SHOW VARIABLES like '%lower_case_table_names% ';SELECT VERSION ();In the project, the table name is capitalized in the Quartz timer task, but the table name established in the database is lowercase, causing the report to not exist when Springboot is
1. Delete the original mariadb, or install the error.rpm-qa| grep mariadbRPM-E--nodeps Mariadb-libs2. In https://dev.mysql.com/downloads/mysql/Select for red Hat Enterprise Linux 7/oracle Linux 7, select the OS version as all.Download the Mysql-5.7.2
A subquery refers to nesting another SELECT statement in a SELECT statement.Any,in,some,all is one of the sub-query keywords,Any can be used with =, >, >=, to represent equal, greater than, greater than, equal to, less than, less than or equal to,
Tag: TE path SQ default system star start password addOne. Open Terminal (alt+ctrl+t):sudo Install mysql-server mysql-clientDuring installation, you will need to enter the root account password, enter the password, wait for the installation to
Preface: The Knowledge of explain (executive plan) has been studied, and the index is optimized and analyzed by explain.0. PreparationFirst create three tables: tb_emp (Staff table), tb_dept (departmental table) and Tb_desc (description table)1)
INSERT intoBookcategory (category_id,category,parent_id)VALUES(1,'Computer',0);//Specify the order of insertionsINSERT intoBookcategoryVALUES(1,'Computer',0);//Follow the default insertINSERT intoBookcategory
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