MySQL

MySQL master-slave replication and semi-synchronous replication principle1, master-slave replication is mainly based on the binary log (binlog), the binary logging is a complete event.2. Take the binary log of the primary server and run it again

The login account used does not have permission to log on remotely, so it can only be logged on the server via the command line.The solution is as follows:1. Log on to MySQL on the server via the command line or client;2. Perform the following

Definition of a stored procedureA stored procedure is a lump of declarative SQL statements stored in a database directory.Applications such as java,python,php can call stored procedures.Since the MySQL 5.0 release, stored procedures, stored

[Experience Skills] "Php+mysql+apache" Environment Construction and "Manual SQL injection"1. Construction of "Php+mysql+apache" environment Environment Carrier: Virtual Machine Window7 Service Pack 1 Ultimate Edition Download

Main content:　　Introduction and use of NAVICAT tools　　1. Introduction and download Installation IntroductionNavicat is a visual management tool for MySQL database development that operates the MySQL database as a graphical interface. However, it is

The function of the MySQL online DDL is to read and write to the table as well as the DDL operation on the table, that is, the DDL operation on the table does not affect transactions on the table.Advantages of this feature: Improve response

The following is an official MARIADB document explaining how MARIADB is installed on a host that already exists on a MySQL instance:https://mariadb.com/kb/en/library/installing-mariadb-alongside-mysql/However, if you install the MARIADB first, then

one, key and primary key differenceCREATE TABLE Wh_logrecord (logrecord_id Int (one) not NULL auto_increment,User_name varchar (+) default NULL,Operation_time datetime default NULL,Logrecord_operation varchar (+) default NULL,PRIMARY KEY

Configure two hosts MySQL dual liveHost:a:192.168.199.2b:192.168.199.4One, the installation service, two hosts perform the same operation:[Email protected] [192.168.199.4] [/tmp]# Tar xvf Mysql-5.6.40-1.el6.x86_64.rpm-bundle.tar[Email protected] [192

Linux under a lot of ways to build MySQL, online also explained a lot of ways to build, there are direct yum, have rpm, in short, "pit" is endless, there are related file dependencies, permissions, GPG keys and so on.I also set up a bit today, is

MySQL table name ignores caseProblem Description:A development colleague in the Linux downgrade a program always error said can not find the table, but landed mysql,show tables view is already created this table!! As follows: 12345678910

Reprint Address: http://blog.itechol.com/space.php?uid=33&do=blog&id=66811, in the MySQL statement "'" function: To avoid the indication, the field name and MySQL existing "reserved word" conflict, causing an unknown error.2, so we build tables and

Reference addressEntity Framework Official websiteASP. NET core MVC and EF Core-tutorial SeriesEnvironmentVisual Studio 2017Latest version of the. NET Core 2.0 SDKLatest version of Windows PowerShellStart building1. Create a new project in Visual

Infi-chu:http://www.cnblogs.com/Infi-chu/relational databaseRelational database is a database based on relational model, and the relational model is saved by a two-dimensional table, so the storage of relational database is a table composed of

--Using the test library ' test_project_management ' oel_project_management ' use test;--the old table drop table old_column_info; CREATE TABLE ' old_column_info ' (' ID ' INT (one) not null auto_increment, ' Table_schema ' VARCHAR (UP) ' NOT null

I was surprised to have spent two hours today tinkering with PHP toolboxes.Because XAMPP is not suitable for beginners just started to learn PHP use, so I installed her PHP toolbox, this is a version of the software can be switched, I recommend, and

Python generates model from a database tableLooking for a long time to find this, I am a novice ...Now has a built database, need to do data analysis based on the original data Web application, I choose Python+tornado, because do not want to write

Because you used Oracle before, you know that you can lock a table with SELECT * for update. So it is natural to think in MySQL can not adapt to the for update to lock the table.Learn the following referencesBecause the InnoDB preset is Row-level

MySQL database itself provides the master-slave replication function can easily achieve multiple automatic data backup, to achieve the expansion of the database. Multiple data backup can not only enhance the security of data, but also can further

This article transferred from: http://blog.sina.com.cn/s/blog_4c197d420101fbl9.htmlView the size of all libraries mysql> use information_schema;database changedmysql> select concat (Round (sum (data_length/1024/1024), 2 ), ' MB ') as data  from