MySQL

Tag:sts   class   return   ring    Auto     iconv   des   param   func    _ooooo_//o8888888o//88 ". "88//(| -_- |) o\ =/o//____/'---' \____//. ' \\| |//'.///\\| | | : ||| // // / _||||| -:- ||||| - // | | \

The problem has arisen several times. Each time with a new person, will ask, with the old driver will also ask. Last weekend, the ox sister also asked. This morning, I will summarize the operation process.Modify a database connectionFirst of all, in

MySQL Master-slave replication principleMysql Master-Slave synchronization is actually an asynchronous replication process, in order to achieve replication first need to open the Bin-log log on master, the entire process needs to open 3 threads,

Column Properties (constraints)1: Whether NULL is allowed (NOT NULL)--not null is not allowed to be emptyCREATE TABLE T_1 (A tinyint (3) Zerofill NOT NULL,b tinyint (3));Example: INSERT into t_1 values (18,29);Example: INSERT into t_1 values (null,12

One, install MySQLIf you are a Windows user, MySQL installation is very simple, download the installation files directly, double-click the installation file step by steps.Linux installation may be more simple, in addition to download the

Initialize database default command:./scripts/mysql_install_db--user=mysql--datadir=/data/mysql Error message:-bash:./scripts/mysql_install_db:/usr/bin/perl: Bad interpreter: No file or directory, Workaround: Yum Install

This article explains in detail the use of the ALTER command in MySQL syntax, which is a much more useful syntax, and the functionality is very powerful. Use Learning (to be built in advance) CREATE TABLE INT not NULL , CHAR (tennotnull, INTis

DefinedFOREIGN key: If a field of one table points to the primary key of another table, it is called a foreign key. The table that is pointed to, called the main table, also called the parent table, then the other table is from the table, also

Attached: MySQL Common error code description1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file

1. Create a connection pool:Why was it created? Because the database is expensive to create connections to the server each time, if a lot of people want to connect to the database, each user creates a connection and the performance is greatly

Data types in MySQL1. Integral type MySQL data type Meaning (Signed) tinyint (m) 1 byte range ( -128~127) smallint (m) 2 byte range ( -32768~32767) Mediumint (M) 3 byte

Like statements and wildcard charactersINSERT into teacher_1 values (' chubby ', ' male ', 18),(' xiaoming ', ' male ', 19),(' Zhang San ', ' Male ', 30),(' John Doe ', ' Male ', 27),(' spanned ', ' male ', 21),(' Three fat ', ' female ', 31),('

Service, of course, can not be separated from the database, if you see the data on the cry, I suggest you still look at this article, do not do data cry ah hahaTo do ' data cool ', hahahaAn installation1. Wget-i-C

Translation: create database statement, createdatabase This article is the translation of the mariadb official manual: create database. Original article: https://mariadb.com/kb/en/create-database/Https://mariadb.com/kb/zh-cn/create-database/ I

In linux, mysql databases are automatically backed up on a daily basis. Overview Backup is the basis for Disaster Tolerance. To prevent data loss caused by system operation errors or system faults, the process of copying all or part of data sets

Configuration text tutorial for MySQL5.7 without installation, text for mysql5.7 Mysql is a popular and easy-to-use database software. The following is a record of the configuration experience of mysql free of installation. I. Software Download   5.7

MySQL curdate () function instance details, mysqlcurdate Functions of MySQL CURDATE If the string context or YYYMMDD format is used in the numeric context, the CURDATE () function returns the current date as a value in YYYY-MM-DD format. The

The reason why the mysql database cannot be remotely connected in centos 7 is solved. Preface Recently, I encountered a problem in my work. I found that I could not remotely connect to mysql in Centos7. By searching for relevant information, I

MySQL database queries and updates the same table at the same time. In normal projects, I often encounter the following problem: I need to update and query data simultaneously in a tag. For example, if there is a table data, the update operation is

Mysql5.1 command line client crash upon logon. mysql5.1clientBecause mysql command line client is not used for a long time. In use today, open the interface, enter the password, and a crash occurs. The workbench platform also shows that the database