MySQL

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

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

MySQL database design specification 1, the database naming specification uses 26 English letters (case-sensitive) and 0-9 natural number (often do not need) with underscore ' _ ' composition; The name is concise and clear (the length cannot

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

Premise: The action table has a primary key or a unique indexINSERT INTO: The table does not have a corresponding record, then inserted, if there is a corresponding record, then error;INSERT INTO IGNORE: The corresponding record does not exist in

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

8.1 What is SQLSQL English full name is Structured query Language, Chinese meaning is structured query language. It is a language method for defining and manipulating data in a relational database. Is the industry standard supported by most

SQL database structure + data, if the data is bulk INSERT will be error: 2006-mysql server has gone away.Workaround: Locate the My.ini configuration file in your MySQL directory and add the following

MySQL master-slave replication and common error problems analysisFirst, master-slave Replication introduction:1, MySQL master-slave replication principle:MySQL Master-slave replication implementation, mainly rely on the binary log to achieve, the

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

Simulating a backup databaseMysqldump DB1 > Db1.sqlTo enable the new Bin-log fileMysql>flush logs;Mysql> Show master status;+------------------+----------+--------------+------------------+-------------------+| File | Position | binlog_do_db |

1:unknown column '????? ‰ ' in ' WHERE clause ', this problem, Baidu a search, quite a lot of, but seems to have not solved my problem. How do I splice the SQL? Solve this SQL stitching bug. Hope can help to the fortunate to see the people, thank

Environment:debian 8Installing MySQLReference material:https://linode.com/docs/databases/mysql/how-to-install-mysql-on-debian-8/sudo Install mysql-serversudoInstalling the Default JRE/JDKReference

9.8 creating MySQL users and giving them permissions9.8.1 Help view the grant command1. Obtain the following help information by entering "assist Grant" in MySQL.mysql> help grant;……省略部分…….CREATE USER ‘jeffrey‘@‘localhost‘ IDENTIFIED BY

MYCAT link mysql hint error 3009 (HY000): Java.lang.IllegalArgumentExceptio resolution 2017-02-03 17:59:42Classification: system operation and Maintenance 1: The problem with the control permissions of the new version of DDL that intends to test 1.6

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

Detailed description of mysql permissions and indexes, detailed description of mysql permission Indexes Mysql permissions and Indexes The highest user of mysql is root, You can CREATE a USER in the database. The statement is "create user username