MySQL

1. IntroductionIn a traditional relational database, views are sometimes referred to as virtual tables, which are based on a specific SQL result set. In some cases will become very convenient, such as: The original system reconstruction, the old

INSERT INTO after get auto-insert Id:select @ @IDENTITY as IDIf SQL Server is best with select Scope_identity () as IDBecause @ @identity a globalThe same kind of ident_current (' table ')Ident_current returns the identity value that was last

Requirement: After you insert a record into the MySQL database using MyBatis, you need to return the self-increment primary key value for that record. Method: Specify the Keyproperty property in Mapper, as shown in the following example: insert

MySQL Master Master replication setupSet the Bin-log, and configure the other person for their master1. Build1.1 Master1 is configured as a master for Master2Master configuration

MySQL Master Copy Build1. Build1.1 MasterMaster configuration (MY.CNF)[mysqld] log-bin=/usr/local/mysql-5.6.16/log/mysql-binserver_id=1Start Master./bin/mysqld_safe--defaults-file=/usr/local/mysql-5.6. /my.cnf--user=mysql &Create a user for

1: You can view information_schema.index_statistics to view the usage information for the index. You can also use the Pt-index-usage tool to analyze the logs and combine explain to analyze the indexes used.2:innodb locks the row when it accesses the

About MySQL: Rdbms:relational Database management System: relational databases Management systems MySQL directory structure: Bin: Mysqld.exe. Server-side program, open it for client access (cmd–> net start[stop] MySQL {can also be

This error occurs if you want to connect to your MySQL:The following is the reference content:ERROR 1130:host ' 192.168.9.1 ' isn't allowed to connect to this MySQL serverWorkaround:1. Change the table method. It may be that your account is not

sudo apt-get install mysql-client-core-5.5It then appears:ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock ' (2)Then:sudo apt-get install mysql-server Mysql-commonIn the middle where you need to

mysql> SHOW VARIABLES like ' character_set_% ';+--------------------------+----------------------------+| variable_name | Value |+--------------------------+----------------------------+| character_set_client | Latin1 || character_set_connection |

1. Log in to the database>mysql-h localhost-u root-p Database name2. Querying all the databases>show databases;3. Select a database>use database name;4. Querying all data Sheets>show tables;5. Querying the table for field information>DESC table name;

Select_type: represents the type of select, the following are common Simple table, which does not use a connection or subqueryPRIMARY: main query, which is the outer queryUNION: The second or subsequent query statement in a unionsubquery: The first

When the unique column inserts a record with duplicate values on a unique key, the default insert will report a 1062 error, and MySQL has three different processing methods, as described below.Create a unique constraint on the ID column by creating 2

Export all librariesmysqldump-uroot-p123456--all-databases > All_databases.sqlImport all librariesmysql-uroot-p123456 The issues to be noted in the Data guide:1. ERROR 2006 (HY000): MySQL server has gone awayThis typically occurs when you import an

1, first, look at MySQL several built-in time functionsSELECT Current_timestamp Current_time (), sysdate ();The results are as follows:2, built-in function to calculate the time difference TimestampdiffTimestampdiff (INTERVAL,DATETIME_EXPR1,DATETIME_

1, choose the most applicable field properties, as far as possible to reduce the definition of field length, as far as possible to set the field not NULL, such as ' Province, gender ', preferably set to enum2. Use connection (join) instead of

1. Creating a stored Procedure 1.1 parameter-free stored procedureCREATE PROCEDURE bruce_procedure () BEGIN -- 1. Declaring Variables -- 2. Execute business logic END1.2 Stored procedures with parametersCREATE PROCEDURE bruce_procedure (inINTVARCHAR

The version I installed is MYSQL-5.6.21-OSX10.9-X86_64.DMG, which prompts installation to fail when installed on a Mac OS X 10.10 system, such as.WorkaroundDuring the third step of the installation process, select Custom when the installation type

Install mysql in linux 1. Download mysql. Here I advocate binary installation. Use winSCP to transmit the downloaded mysql to the linux Server 2. decompress the downloaded mysql package #tar -zxvf /{MySQL5.6_path}/mysql-{version}.tar.gzHere there

An exception is thrown when MySQL queries the default time.The problem occurs when a mysql table is created, with a field of the Date type in the table. The default value is 0000-00-00 00:00:00. PrepareStatement is used for query, and the query