MySQL

Format: Update table name set field name = Field name + 1 For example, there is a student table in the database, to add 1 to the student score (score) with ID 1Update student set score=score+1 where id = 1If you do not add the where system will not

Preface, what is the storage engineTable ===> files created in the Library ===> folder library in MySQLThere are different types of files that we use to store data in real life, and each file type corresponds to a different processing mechanism: For

Nginx Series-2. Configure LNMP (Linux, Nginx, MySQL, PHP) schema directory-Nginx series Nginx Series -1.linux Installation NginxNginx Series-2. Configuring the Lnmp (Linux, Nginx, MySQL, PHP) architectureNginx Series-3. Configuring Nginx

 1. Download linkNavicat for MySQL ClientLink: Https://pan.baidu.com/s/1dGbzgbR Password: i43gMySQL serverLink: Https://pan.baidu.com/s/1qYE01BI Password: qz9s2. Install MySQL and navicatNavicat for MySQL, downloaded itself is an app, do not have to

Like operatorTo use wildcard characters in a search clause, you must use the LIKE operator.Note: When is the operator not an operator? The answer is when it is used as a predicate. Percent percent (%) wildcard character % indicates any

MySQL transaction autocommit Auto-commitThe MySQL default mode of operation is autocommit auto-commit mode. This means that unless a transaction is explicitly started, each query is executed automatically as a separate transaction. We can change

Learn last_insert_id First LAST_INSERT_ID has its own storage space, can save a number Returns the value of the self-increment field for the last insert row record without parameters. With parameters, the number you store will be

Often play MySQL database on the server, but the Linux-based operation of MySQL is more inconvenient, so I would like to use GUI tools to remotely manipulate the MySQL database. It is not three times to use Navicat-for-mysql, but each connection to

CREATE DATABASE db_name DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;The syntax for CREATE DATABASE:CREATE {DATABASE | SCHEMA} [IF not EXISTS] Db_name[Create_specification [, Create_specification] ...]Create_specification:[DEFAULT] CHARACTER

MySQL database Advanced (ii)--Custom function One, introduction to custom functionsCustom Functions (user-defined function UDFs) are a way to extend MySQL, with the same usage as built-in functions.Two prerequisites for a custom function:A,

One. Official website: https://dev.mysql.com/downloads/mysql/1. Select the corresponding version and download the free install version:2. Do not register account, click "No thanks,just start my download":3. Download to local after direct

This article is included in the Linux operation and Maintenance Enterprise Architecture Combat SeriesI. Collect custom logs from the cutting companyMany companies ' journals are not consistent with the default log format for services, so we need to

1.mycat Binary Package InstallationTAR-ZXVF mycat-server-1.6.5-release-20180122220033-linux.tar.gzCD MycatMV mycat/opt/Useradd MycatChown-r Mycat:mycat Mycat2.mysql operationBuilding the main library environmentOmitted......Create a databaseCREATE

use of the Mysql-utilities Management toolset:For more detailed parameters, refer to the official documentation: https://dev.mysql.com/doc/mysql-utilities/Go directly to the MySQL website to download the RPM package installation. If the installation

Application Scenarios:1, in the data table, to record when each piece of data was created, do not need the application to deliberately record, and the data database to obtain the current time automatically record creation time;2, in the database, to

Note: This article is reproduced from http://www.hollischuang.com/archives/914In computer science, a lock is a synchronization mechanism used to forcibly restrict access to resources when executing multiple threads, which is used to guarantee the

Note: This article is reproduced from http://www.hollischuang.com/archives/923Row-level locks, table-level locks, page-level locks are described in MySQL, row-level locks are the most granular lock in MySQL, and row-level locks can significantly

If MySQL was installed before XAMPP was installed and added to the Windows serviceTwo MySQL conflicts in Windows services when using XAMPPThis means that you have used MySQL on your computer before, and the path and port are occupied.In this case,

MySQL work everywhere, countless installation, optimization, has no time, the collation of the archive, recently in the MySQL Dass service, the recently encountered problems, to collate, carding a guide for everyone; Preface MySQL

Mysql adds a column, deletes a column, modifies a column name, and mysql columns at a certain position in the table. To add a column to a created table, run the following code: alter table name add column name varchar (20) not null; this statement