MySQL

The letter-case rule in the MySQL statement varies with the statement element and depends on the operating system on the MySQL server host.SQL keyword and function nameKeywords and function names do not distinguish between uppercase and lowercase

An introduction to IDE toolsThe production environment is also recommended for MySQL command line, but for our testing purposes, you can use the IDE toolsDownload Link: https://pan.baidu.com/s/1bpo5mqjMaster: #1. Test + link Database # #. Create a

1. String class functions(1) CONCAT (s1,s2,s3,.....) connection stringFor example: SELECT CONCAT (' 1 ', ' 2 ') from DUAL;Output: 12(2) LOWER (s) turns the string all lowercaseFor example: SELECT LOWER (' ABC ') from DUAL;Output: ABC(3) UPPER (s)

Data access is divided into three types of 1. Use a function to discard 2 in a new version. An object-oriented approach to the Mysqli class 3.PDO example codename name gender National Birthdays Use the Mysqli class to access the

1. Add Table record Insert a record: Insert [into] tab_name (field1,filed2,.......) VALUES (value1,value2,.......);　　　　　　　　　　　　　　　　　　　　　　　　　　　　 Insert multiple records: Insert [into] tab_name (field1,filed2,.......) VALUES (value1,value2,.......),

How to combine fields from multiple tables in MySQL and then insert them into a new table, implemented by an SQL statement. The case is: there are three tables A, B, C, now you need to check the values of several fields from table B and table C into

CentOS Setup MySQL Character setVim ETC/MY.CNFModified to read as follows:[Client]port=3306Socket=/var/lib/mysql/mysql.sockDefault-character-set=utf8[Mysqld]Datadir=/var/lib/mysqlSocket=/var/lib/mysql/mysql.sockUser=mysql# Disabling Symbolic-links

We, as DBAs at work, may also need to face the various freestyle of developers, but do they know what to look for when working with databases?Today with everyone simple talk about MySQL database development behavior norms, the ten iron discipline.

MySQL 5.7.19 Source Installation1. Installing dependent Packages# yum-y Install ncurses-devel libaio-devel cmake gcc gcc-c++ bison perl-time-hires2. Download and install boost2.1. Download the Package# wget

1. Modify the configuration filesudo vim/etc/mysql/my.cnfChange the value of the bind-address parameter to your internal/external network IP or 0.0.0.0, or comment out the line directly.2. Log in to the databaseMysql-u root-pEnter passwordmysql> use

This time using JMeter to connect to the MySQL database on this computer, query the contents of the User_info table:2. Open JMeter, import in test plan, connect MySQL mysql-connector-java-5.1.30-bin.jar package, enter, no jar package can Baidu

This blog post describes how to optimize the number of internal loops . The number of times in the loop is affected by the number of records in the drive table, the more the number of drive table records, the more internal loops, the more

First, the installation of MySQLDownload Mac OS X 10.12 (x86, 64-bit) from the official website (https://dev.mysql.com/downloads/mysql/), DMG Archive (mysql-5.7.19-macos10.12-x86_ 64.DMG) version, double click on the prompt to install, after the

Test Required: Open two test windows locallyPessimistic lockPessimistic lock it refers to the data is conservative in the external (including the system's current other transactions, as well as the transaction from the External System), the data is

This article is based on the practice of the book "MySQL from the beginning to Master", which was compiled by the national 863 Central software incubator.First, create a data tableThe data table belongs to the database, and you should specify the

Basic operations:CREATE TABLE table_name (field1 type[full constraint condition], field2 type[full constraint condition], ....... ..... fieldn type##field字段名, type field types are required and fields cannot be duplicated) [CHARSET XXX]#Specify

1. Modify the My.ini configuration file, if the simplest way to set a global parameter is to write the parameter configuration directly in the My.ini file, as shown in. Restarting the database service enables the global parameters to take effect.As

How to avoid the url Time Zone traps in mysql Preface Recently, when using mysql's jar above 6.0.x, You need to specify serverTimezone in the url of the Code. An exception occurs: 1. serverTimezone not specified Configure url in

How to modify the IP address restrictions of an account in MySQL Preface Recently, I encountered a requirement in my work: To modify the permissions of MySQL users, you must restrict specific IP addresses for access. The first requirement was met,

MySQL constraints, multi-table queries, subqueries, mysql constraint table queries 1. Primary Key constraints Constraint: A constraint is added to a column to constrain the column. 1. primary key constraint (unique identifier): non-empty, unique,