MySQL

Download MySQL RPM installation package (including server, client) from MySQL website1. Installing the serverRPM-IVH mysql-server-5.6.19-1.el6.x86_64.rpmForce installationRPM-IVH--force mysql-server-5.5.17-1.linux2.6.x86_64.rpmReport the following

1. Backup# Export Database: Mysqldump-u username-P database name > exported file nameMysqldump-–add-drop-table-uusername-ppassword databasename > Backupfile.sqlNote: 1, enter the password, enter the password of the database user name2. If you export

The previous content introduced the view concept of the MySQL database at the end stage, which is a fine introduction to the centralized usage of the view. Create a student table, a college table, and a learner's information table before creating a

A few days ago to build a lamp environment, want to write a small thing to move to Linux running, involving the MySQL database files migrated to Linux, directly with the FileZilla pass the past should not, I tried, anyway did not succeed. Here's

MySQL Transaction在MySQL中只有使用了Innodb数据库引擎的数据库或表才支持事务，所以很多情况下我们都使用innodb引擎。事务处理可以用来维护数据库的完整性，保证成批的SQL语句要么全部执行，要么全部不执行。一般来说，事务是必须满足4个条件（ACID）： Atomicity（原子性）、Consistency（稳定性）、Isolation（隔离性）、Durability（可靠性）1、事务的原子性：一组事务，要么成功；要么撤回。2、稳定性 ：

One, MySQL businessA transaction is a logical set of SQL operations that make up the individual SQL statements of this set of operations, either completely successful or fail at execution time.For example, Xiao Ming to the small red transfer 100

I. Download and InstallationFirst go to the official website to download the Mac version of MySQL, the suffix of the. DMG Package: https://dev.mysql.com/downloads/mysql/After downloading, a step-by-step fool installation, after installation, MySQL

4. Install MySQL[[email protected] ~]# wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.45-linux2.6-x86_64.tar.gz # download MySQL 5.5 version, the download process is long, need to wait for a moment[[Email protected] ~]# tar XF

MySQL---binary logRecords all modifications to the MySQL database, including additions and deletions and modification events to the table structureBinary Log on#是否启用了日志mysql> show variables like ‘log_bin‘; +---------------+-------+| Variable_name |

When querying the database, we sometimes need to add a sequence to the queried data, 1,2,3,......NFor example, we sort the data according to a field of the table, we want to add a sequence to this, when the serial number is often not the

First, modify the My.ini configuration file (MySQL configuration file)Character_set_server = UTF8 #设置字符集Restart MySQL database serviceView the current database character setShow VARIABLES like ' character% ';Second, modify the database character

Objective1. mysql InstallationCentOS 7 's Yum source does not appear to be properly installed when MySQL mysql-sever file, need to go to the official web download # wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# RPM-IVH

InnoDB supports transactional features, MyISAM not supported.Myisam executes faster and performs better.2, select, UPDATE, INSERT, delete operationMyISAM: If performing a large number of select,myisam is a better choice InnoDB: If your data performs

Physical file compositionLog files: error log, query log, slow query log, transaction log, binary logLogs are a part of the MySQL database's perception. Log files record changes in the running of the honing MySQL database, which is used to record

Tools: EclipseMySQL DatabaseJar Package used: Mysql-connector-java-5.1.27.jarCreate SqldemoAfter the jar package is downloaded, create a new Lib folder in the demo to hold the jar package. Right-click Demo Build path to add jar packageDatabase

First, the basic operation of the database1 CREATE DATABASE Mybookstore; 2 DROP DATABASE Mybookstore; 　　　second, the basic operation of the table　　1. Create a table　　　　　Insert into table name (field name 1, field name 2) VALUES (value 1,

A brief introduction: Today we talk about JVM memory tuningTwo basic theories:1 Basic concepts of JVM heap (heap):1 for most applications, the Java heap (Java heap) is the largest piece of memory managed by a Java virtual machine. The Java heap is a

Sometimes arise, no mysql.sock, no problems,Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)In general, Systemctl start mariadb re-enable MySQL.However, if it is not, such as accidentally paired with the wrong,

MySQL database insert Chinese garbled solution, mysql Chinese In the mysql database, garbled characters occur when Chinese data is inserted. My Test method: My solution:   Note: I only changed the client encoding format to gbk, and then

Detailed analysis of mysql database transactions and mysql Database Analysis       Let's explain the background before writing! I have been doing development for a long time, but I have not learned much about it. Now I want to analyze my