MySQL

1.1 to view the installation path for MySQL: [[email protected] ~]# Whereis MySQLMySQL:/usr/bin/mysql/usr/lib/mysql/usr/share/mysql/usr/share/man/man1/mysql.1.gz1.2 to view the installation package for MySQL: [[email protected] ~]# rpm-qa|grep

MySQL Character Set introductionIncludes two-part character set character and proofing rules collationCharacter sets are used to define how the MySQL string is storedProofing rules are the way to define a comparison stringIf the database has more

1. Data type: Refers to the data characteristics of columns, stored procedure parameters, expressions, and local variables, which determines the storage format of the data and represents the different types of information(1) integer type (by storage

Database design: The process of planning and structuring the data entities in the database and the relationships between those entities.Design process: Demand analysis: Analyze the customer's business and data processing needs. Summary

1. Installing MysqlclientError when installing mysqlclient because of the /bin/sh mysql_config not found need to install Mariadb-develError error: command ‘gcc‘ failed with exit status 1 , lack ofgcc。1.yum Install GCC Mariadb-devel2.PIP3 Install

Data type Char 0~255 Varchar 0~65535 Text 0~65535 (only characters are saved) Longtext 0~4294967295 (only characters are saved)Commands and actions (common items) Action options The command should be entered in the

CauseToday in the company for the first time link a new MySQL database, I see in spring configured in JDBC Datasource.url configuration Characterencoding=utf8. Then use navicat Open Select UTF8 link database, results see table data Chinese all

#!/bin/sh# 备份数据库 mkdir -p /data/backup/mysql mkdir -p /data/backup/dbdata# Mysql 用户名密码MYSQL_USER=rootMYSQL_PASS=vrv123456.BACKUP_DIR=/data/backup/mysqlDATA_DIR=/data/backup/dbdata# 查询mysql中所有数据库名字SQL_STRING="SELECT SCHEMA_NAME AS db FROM information_

MySQL Master-Slave introductionPreparing, configuring hosts1. Two primary and standby machines are installed MySQL.2. Edit the configuration file:[[email protected] ~]# vim /etc/my.cnfAdd the following two lines[mysqld]datadir=/data/mysqlsocket=/tmp/

Binlog file logging is a binary fileMaster needs to open Binlog to startRelaylog Final Log inApplication scenario make a backup of the data 1. Master Read and write operations if hardware is damaged you can provide services immediately2. Do a backup

"1" existsFor the appearance with loop-by-article query, each query will see exists conditional statements.When a conditional statement in exists can return a record row (regardless of the number of records, as long as it can be returned), the

1, Xid_eventWhen a transaction commits, either statement or the row format Binlog adds a xid_event as the end of the transaction. The event records the ID of the transaction. When MySQL is recovering from a crash, it decides whether to commit a

MySQL version 5.5.58The first step is to configure the hostThe host configuration is as follows:Server-id = 1#服务器id (master and slave must be different)Log_bin=MySQL-bin#Open the log (the host needs to open),This mysql-bin can also be customized,

Yesterday on-line app feedback night19:30-19:43 and 20:13 to 20:21 two time periods everyone, including our own classrooms, can't get in, classroom b Set Unable to login, homepage inaccessible, More than 10 teachers and students have received

DecimalDecimal (N,M) indicates that the value has n digits, where the integer n-m bit, and the fractional m bit. Example: Decimal (10,6), a total of 10 digits in the numeric value, where the integers accounted for 4 bits, and the decimals accounted

1. installation package Download:Official website Https://dev.mysql.com/downloads/mysql/5.6.html#downloads, I downloaded this version mysql-5.6.39-linux-glibc2.12-x86_64.tar.gzUpload to Linux under/usr/software after download is complete2. Unpack

Slow query log (mysql), query log mysql Reference Mysql provides support for slow query logs for mysql optimization. Mysql slow query is a log record provided by mysql. It is used to record SQL statements whose response time exceeds the threshold

Install Mysql in the Liunx environment and mysql in the liunx Environment1.1View the installation path of mysql: [Root @ bogon ~] # Whereis mysql Mysql:/usr/bin/mysql/usr/lib/mysql/usr/share/man/man1/mysql.1.gz  1.2 View the mysql installation

Mysql database index optimization and Practice (I), mysql IndexPreface Mysql database is currently the most widely used database system. Dealing with databases is one of the daily work of every Java programmer. index optimization is one of the

Centos6.8 install mysql and configure remote login, centos6.8mysql 1. wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm 2. yum install mysql-community-release-el6-5.noarch.rpm 3. yum install mysql-community-server 4. service mysqld