MySQL

How to view MySql status-how does MySql view the number of connections and status and how does it enter the mysql command line? There is a bin directory under the mysql installation directory. first enter the directory with the command line, and

In linux, how does one implement daily automatic backup of mysql Databases and create a backup Folder: mkdir mysql_data_bak script file: touch autobackupmysql. sh www.2cto.com open the file vi autobackupmysql. sh adds the following content to the

MySql numeric functions abs (N) returns the absolute value of N www.2cto.com mysql> select ABS (2);-> 2 mysql> select ABS (-32);-> 32 sign (N) returns the parameter symbol (-1, 0, or 1) mysql> select SIGN (-32);->-1 mysql> select SIGN (0 ); -> 0

MySQL queries do not use index summary. We all know that adding an index is an effective way to increase the query speed. However, in many cases, even if an index is added, the query still does not use an index, which seriously affects the

MySQL 1594 error solution MySQL 1594 error solution: Example: www.2cto.com Master_Log_File: mysqld-bin.000042 Read_Master_Log_Pos: 99749808 Relay_Log_File: mysqld-relay-bin.000083 Relay_Log_Pos: 15995 runtime: mysqld-bin.000041 runtime: Yes Slave_

MySQL 1236 error solution due to the master server abnormal reboot, resulting in an error from, the error is as follows: www.2cto.com show slave status error: mysql> show slave status \ GMaster_Log_File: mysql-bin.000288Read_Master_Log_Pos: 627806304

Use BINLOG to find the SQL statement of the specified date and search for posts on the 95 database server. post_thread's postid = 1652971, the SQL statement www.2cto.com # grep datadir/etc/mysql/my that was executed on February 24. cnfdatadir

[MySQL] converts the date and time formats. Here is an example of using the date function. The following query Selects all records. The value of date_col is within the last 30 days: www.2cto.com mysql> SELECT something FROM table WHERE TO_DAYS (NOW (

MySQL DATA export and import tool: mysqldump (Database Backup command) backup database # mysqldump Database Name> Database Backup name # mysqldump-A-u username-p Password Database [size = large] Name> Database Backup name # mysqldump-d-A -- add-

Connection between left and right of mysql and internal connection of cainiao1. create a table: boy and insert several lines of data. Java code: create table boy (Name varchar (10 ),Flower varchar (10)); Java code insert into boyValues("Lin shuhao",

Mysql inserts large data into a table. Method 1: The data volume is not large and there are thousands of rows of data. use notepad to edit the data. The result is as follows: insert into 'web4399 _ vote '. 'frxz2 _ hlwjhj_code '(active_code) values (

Record the helpless power failure caused by a failure to start mysql after a power failure. Mysql cannot be started. 1. view error 130313 15:31:13 [Note] Plugin 'federated 'is disabled. 130313 15:31:13 InnoDB: Initializing buffer pool, size = 107.0

The first step (generally omitted) for executing SQL scripts in mysql is to enable the mysql service (which runs automatically at startup by default): control panel --> management tools --> services, find the item named mysql in it, and double-click

MySQL master-slave replication several important startup options (1) log-slave-updateslog-slave-updates this parameter is used to configure whether to write updates from the server to binary logs, this option is disabled by default. However, if the

MySQL InnoDB Storage engine lock mechanism experiment MySQL's InnoDB Storage engine uses row-level locks, and the default transaction isolation level is Repeatable read, unlike Oracle's default transaction isolation level commit read. What is the

Mysql common options binlog-format can be set to STATEMENT (default), ROW, and MIXED. SUPER is required. It is not recommended to modify the binlog-format value when replication is in progress. Binlog-do-db (binlog-ignore-db, replicate-do-db,

The rational setting of SQL _mode in mysql SQL _mode is a variable that is easily ignored. The default value is null. In this setting, some illegal operations can be allowed, such as the insertion of some illegal data. In the production environment,

MySql quick INSERT and batch update INSERT: MySql provides the function of inserting multiple data records at a time: [SQL] insert into tbl_name (a, B, c) VALUES (1, 2, 3 ), (, 6), (, 9), (, 12 )...; in the program, you can add the list of Values

Mysql 5.6.10 parameters (verification) my. there are two INI files that must be changed: Cancel table_cache and log-slow-queries = slow. log must be changed to slow-query-log-file = slow. log [mysqld] port = 3306 available basedir = D:/wamp/mysql

Mysql displays the number of connections and the status show processlist. If it is a root account, you can view the current connection of all users. If it is another common account, only the show processlist connections occupied by you can be seen.