MySQL

Mysql SQL statements, View table information, View table field information, Java code SELECT column_name AS 'column name', data_type AS 'data type', character_maximum_length AS 'character length ', numeric_precision AS 'numeric length',

The mysql log command has the following types of logs:-log-err query log:-log slow query log:-log-slow-queries Update log: -log-update BINARY log:-log-bin in the mysql installation directory, open my. ini, add the above parameters to the end, save

Mysql database maintenance Statement 1. alter table t1 rename to t1_back_20130502 2. export structure SQL code mysqldump-h192.168.1.1-uroot-p1234 -- default-character-set = utf8 -- opt-d-R dbname tablename> d: \ data_file_table_130507. SQL 3. then

MySQL Statement Review show databases; // display all databases select database (); // view the current database show tables; // display the Table Name USER db_name [;] // switch database desc tb_name; /DESCRIBE city;/EXPLAIN city; // display

MySQL InnoDB manages and backs up binary logs (I) Importance of binary logs if there is data backup at a certain point in time and all binary logs since then can replay the binary logs since the last full backup and" roll back "all changes (ii)

When the character utf8 encoding exceeds 3 bits, the error message is inserted into the Mysql database, and the Incorrect string value is resolved: '\ xF0 \ xA1 \ xBF \ xA8 \ xE9 \ x82... for column 'last _ name' this problem occurs in mysql. If

In linux enterprise 5, mysql 5.6 is installed with cmake after mysql 5.5. cmake is an essential tool for installing mysql 5.5. Install cmake as follows. Download the source code installation package from the cmake website [root @ localhost ~] # Wget

Mysql table sharding guidelines when using Mysql in large quantities and with high data access, to improve performance, table sharding is required. The following section describes the mysql table sharding standards and will continue to supplement

Mysql uses the stored PROCEDURE to CREATE test DATA [SQL] DELIMITER $ DROP PROCEDURE IF EXISTS message_insert_procedure; CREATE PROCEDURE 'test '. 'message _ insert_procedure '(loop_times INT) begin declare var int default 0; WHILE var  

How does MySQL avoid using swap Linux? There are many good memory and IO Scheduling Mechanisms, but they are not applicable to all scenarios. One of the headaches for DBA Linux is that it does not avoid ing the address space allocated to MySQL to

Advantages of creating and calling stored procedures in My SQL Server Stored Procedures: ① fast execution speed ② templated Program Design ③ reduce network traffic ④ provide system security. what is stored procedure stored Procedure (stored

Mysql dynamically creates and deletes partition tables because of project requirements. Recently, I have studied how to dynamically create and delete partition tables in the mysql database. If all stored procedures are used, creating and deleting

Mysql deletes tens of millions of data in mysql. When the delete operation drops tens of millions of data records, the table will be locked and even put a lot of pressure on the mysql server. This is an unavoidable problem in mysql. It can be said

The three locking mechanisms of MySQL database locking mechanism is a rule designed by the database to ensure data consistency and enable the access of various shared resources in an orderly manner during concurrent access. MySQL storage engines use

Mysql has a large number of sleep processes and solutions. mysql server has a large number of sleep processes. This article analyzes the causes and solutions for the large sleep process in mysql. Possible cause: why are there too many sleep

The mysql backup script writes a mysql backup file today, mainly using the mysqldump tool. The requirement is to back up some databases at three o'clock every day and keep the backups for two days. Simple requirement: The following script #!

Export records from mysql to hdfs 01 ConnectURL = jdbc: mysql: // localhost: 3306/user_action0203UserName = root0405PassWord = 1234560607 OutputPath =/hdfs/recommend/user_action/login = watch_record1011Columns = id, uid, mid, handler = 'sqoop job

MySQL reserved keywords today, when we use hibernate to associate ing to export tables, because a table named option is mapped to a MYSQL keyword, errors are always generated. At first, we thought it was a ing file and code problem, the reserved

The user and password generation management application in mysql is launched, involving user name and password management. As the application is launched, managing user names and passwords becomes a problem. We also need to grant permissions to

On a single machine, install and run two mysql database instances to facilitate testing and use two mysql database instances. Taking windows as an example, of course, installing the first mysql database is quite simple. But you need to install it