MySQL

1. Display Databaseshow databases;2. Select DatabaseUse database name;3. Display the tables in the databaseShow tables;4, display the structure of the data tabledescribe table name;5. Display the records in the tableSELECT * FROM table name6. Build

One, CONCAT () functionThe CONCAT () function is used to concatenate multiple strings into a single string.Use data table info as an example, where select Id,name from Info LIMIT 1, and the returned result is+----+--------+| ID | name |+----+--------

First, what is a thing?Personal understanding, the SQL is the thing is to do a group of SQL statements, the group of SQL statements or all successful execution, otherwise it will not be fully enforced. Or a series of operations performed as a single

Note Down Memo1, Ready Webstrom Editor, editor adjust font size and so on file->settings->editor set up the source of the registration code on the Internet:2017.2.27 UpdateSelect "License Server" input: http://idea.imsxm.com/2, ready MySQL because I

Overview:Shared locks, also known as read locks, referred to as the S-lock, as the name implies, a shared lock is multiple transactions for the same data can share a lock, can access the data, but can only read can not be modified.Exclusive locks,

# #安装mysql需要的依赖包Yum Install Ncurses-devel libaio-devel-y# #安装编译MySQL需要的软件As the MySQL5.5 and above series of products to be installed in a special way, it is necessary to install the commonly used compiled MySQL tool cmake software package, the

What is the index in MySQL?The index, also called "Key" in MySQL, is a marker used by the MySQL storage engine to quickly find records, which plays a key role in improving query speed, and the role of indexes becomes more important when the amount

1, database backup: Pro: The database that needs to be backed up; Mypro.sql: Backup files generated by backupsC:\USERS\JFHLG>mysqldump--pro>mypro.sql /backup File save address as default path C:\USERS\JFHLGc:\users\jfhlg>mysqldump -u root-p

1. Download the MySQL JDBC driverAddress: https://dev.mysql.com/downloads/connector/For convenience, choose your own compression package directlySkip login, select Direct downloadAfter the download is complete, unzip the

Questions: local MySQL, using 127.0.0.1 can connect successfully, using specific IP connection error ERROR 1130 (HY000): Host ' 10.252.225.125 ' isn't allowed to connect to this MySQL server Workaround: Authorize the database to enter the MySQL

MySQL command line individual parameter explanationHttp://blog.51yip.com/mysql/1056.htmlUsage:mysql [OPTIONS] [Database]//Command mode-?,--help//Display assistance information and exit-I,--HELP//Display Help information and

Table-level constraints1. PRIMARY KEY constraint----PRIMARY keyPrimary key: A combination of one or more columns in a table that requires the data of that column to be uniqueSingle field primary key: Fields name Data Type Property Primary

When you delete a table or a piece of data in MySQL, it appears[ERR] 1451-cannot Delete or update a parent ROW:A FOREIGN KEY constraint fails (...) This is because the foreign Key association is set in MySQL, resulting in the inability to update or

Very many times. When we are querying the MySQL database, we want to process the time, for example, format or other operation, this way to avoid the processing. And MySQL also has a lot of time aspects of the processing function, today simple to do

Because Ubuntu default MySQL path is under/var/lib/mysql, many times if we do not mount other partitions at/Var, as the site gradually browse and add content, the data capacity will become larger, natural disk space will be more tight. So we need to

InnoDB engineThe InnoDB engine provides support for database acid transactions and implements four isolation levels for the SQL standard. The engine also provides row-level and foreign-key constraints, which are designed to handle a large-capacity

The server is scheduled as follows:192.168.100.128 Master192.168.100.129 from192.168.100.130 Mysql-proxy1. Download and install the Mysql-proxy in 100.130TAR-ZXVF mysql-proxy-0.8. 5-linux-el6-x86-64bit.tar.gzcp mysql-proxy-0.8. 5-linux-el6-x86-64bit/

MySQL installation tutorial under Centos7 and centos7mysql tutorial MySQL installation tutorial for your reference. The specific content is as follows: 1. Download Go to the official website to download the Yum Source: Address 2. Installation

The mysql master is not synchronized, and the system prompts that the record cannot be found for the update. The mysql Master/Slave View the status of a cluster: show slave status \ G The original library prompt is: Last_Error: Coordinator stopped

Latch (latch) in MySQL-analysis of problems and causes, and mysqllatch Latch What is latch: Locks are a key feature of the differences between database systems and file systems. The lock mechanism is used to manage concurrent access to shared