MySQL

If you have an important table BTB, you need several administrators to manageadmin: [email protected], [email protected], [email protected]Required to create a trigger for table BTB:Trigger Trigger Requirements:1 , when an INSERT, UPDATE, delete

Installation configuration and uninstallation of MySQL:Installation:(1) Put the green version of MySQL free install package on the D drive, the command line into the MySQL green version of the bin directory after decompression:CD D:\mysql-5.6.35-win3

I had two problems writing a collection today.1. MySQL server has gone away2. Maximum execution time of seconds exceededThe capture program is written to run about a minute after the MySQL server has gone away, found that MySQL inside the

1. Modify it on the basis of MySQL master/slave:#master1上[Mysqld]server-id=101 L Og-bin = Mysql-binAuto-increment-increment = 2auto-increment-offset = #master2上[Mysqld]server-id=103 Log-bin = Mysql-binAuto-increment-increment =

1.select_type　　Simple: It represents a single select, with no union and sub-queryDependent union:union dependent outer-layer queryDependent subquery:subquery dependent outer-layer query2.typeSystem: Table has only one row, this is a const type of

If the two table is associated with a field that is not set in the table structure, it cannot be used even if the index is set.For details, please refer to:Https://yq.aliyun.com/articles/69138?spm=5176.100239.bloglist.185.xQpeswFor MySQL explain,

MySQL TransactionMySQL transaction is mainly used to deal with large-scale and high-complexity data. For example, in the Personnel Management system, you delete a person, you need to delete the basic information of the person, but also to delete the

Build an indexIndexing is a way of optimizing queries, and we usually establish a correlation index on the where column, either as a single column index or as a composite index.Add Index to noteYou can consider adding an index on the relevant column

The Max function is an aggregate function in hive, so the return value is double and must be followed by the group by, which differs greatly from MySQLBuilt-in Aggregate Functions (UDAF)DOUBLEMax (COL)Returns the maximum value of the column in the

Only_full_group_by is the legality check that MySQL uses for group by, and with it, you can troubleshoot errors that use the semantics of the group, just like Oracle's large databases.Like whatMySQL> Create database test charset utf8mb4; MySQL>

In the local installed CentOS 7 virtual machine, the first to install the environment, the choice of MySQL is 5.6, the following is the installation process:1. Download MySQL 5.6 packwget

Last_io_error:got a packet bigger than ' Max_allowed_packet ' bytes due to MySQL error from libraryMysql>show slave status\g;***************************1. Row ***************************Slave_io_state:master_host:192.168.90.190master_user:rsync

Want to count both the number of boys and the number of failed.SELECT COUNT (1) as Boynum from t_student WHERE sex= ' male ';SELECT COUNT (1) as Poornum from T_student WHERE scoreFailed attempts:SELECT count (sex= ' man ') as Boynum, COUNT

1. Open and close the strict mode methodLocate the MY.CNF (the Windows system is the My.ini) file under the MySQL installation folderAdding strict_trans_tables in Sql_mode means that strict mode is turned on. If no increase is not strict mode, after

Create a database CREATE DATABASE [IF not EXISTS] CHARACTER SET [=] UTF8;The code in brackets is optional; Charater is created as the default character if you do not write.After you have created the database, you can:SHOW DATABASES;See how many

Background: Full Library backupBackup process:1. Generate DB list, write DB name to file2. Define the backup function and write the result to the SQL file3. Compress files to reduce disk usage4. Set the number of days to retain, periodically delete

Creating a table is a simple way to create a table person (number INT (11), name VARCHAR (255birthday DATE), or create TABLE IF not EXISTS person (number INT (11), name VARCHAR (255), birthday DATE); View MySQL CREATE table: Copy code show create

Linux Installation Mysqllinux NetworkingIP A View network informationModify/etc/sysconfig/network-scripte/ifcfg-eth0Onboot value of the file, no change to YesTo restart the Network service:Service network restart//or compare the original

Fatal error:the slave I/O thread stops because master and slave have equal MySQL server IDs;Cause Analysis:Similar to Server_uuid, SERVIER_ID has to be guaranteed to be different.Workaround:Locate the server_id in the MY.CNF configuration file,

Spring integrates mybatis to implement mysql read/write splitting and mybatismysqlPreface When the number of website users reaches a certain scale, the database becomes the bottleneck of the website because of the high load pressure. Fortunately,