1: View the current transactionMysql> SELECT * from Information_schema.innodb_trx \g2: View the currently locked transactionsMysql> SELECT * from INFORMATION_SCHEMA. Innodb_locks;3: View transactions for the current lockMysql> SELECT * from
Download and decompress MySQL databasewget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.4-m14-linux-glibc2.5-x86_64.tar.gzTAR-XVF mysql-5.7.4-m14-linux-glibc2.5-x86_64.tar.gz-c/usr/local/mysql-5.7.4
2. Create MySQL users and modify the
Backup of the database can prevent the loss of data caused by unexpected situations such as server downtime, disk corruption, RAID card corruption, and so on.Backup tool for MySQL:MysqldumpIbbackupReplicationLVM Snapshotor third-party tools
MySQL Installation issuesproblem description : Reload MySQL encountered a problem, to the last step, configure the four items at the time of the card in the third step, the display program is not responding.Environment :Os:win7 x64Installation
MySQL single-process multi-threaded, that is, the MySQL instance on the system is a process that the schema is similar to SQL Server and the Windows version of the Oraclemysql database is composed of some column physical files. Files similar to frm,
To modify the database character set:
ALTER DATABASE db_name DEFAULT CHARACTER SET character_name [COLLATE ...];
Change the default character set of the table and all character columns (Char,varchar,text) to the new
show databases //List MySQL Server database. show tables [from db_name] //lists the database data tables. show table status [from db_name] //lists data tables and table status
1. Delete the database name of the drop databases database;mysql> drop database test;That is, delete the database schema2 . Create DATABASE Database namemysql> CREATE DATABASE test;Windows and Linux handle database names and table names
#!/bin/bash #This is a ShellScript. For Auto DB Backup #Powered by [email protected] #2014/2/25#setting #设置数据库名, database login, password, backup path, log path, data file location, and backup method # By default, the backup method is tar, or
A MySQL stored procedure can not define a dynamic cursor, but you can use variables. Open, Fetch...into and close. 1. Declare a cursor: --Define useriddeclare userId nvarchar () default 0;--define Cursordeclare mycur CURSOR for select id from user; -
As we all know, increasing the index is improvingEnquiryStill do not use the index, this situation seriously affects performance, here is a brief summary of a fewififThe column key is evenly distributed between 1 and 100, and the
Problem:When using cursor traversal, it is found that theSelect Var into tmp where var=?You can then determine if TMP is NULL when you cannot walk through all of the traversal. After the debug discovery,When Var is empty, it jumps out of the
Description of the MySQL stored procedure: http://www.cnblogs.com/exmyth/p/3303470.html Get, modify, and delete data (same as normal SQL statements): When fetching data, use an into to assign the ID to the newId defined in the stored procedure.
the SQL that establishes the stored procedure is as follows:
CREATE PROCEDURE proc_variable ()
BEGIN
DECLARE dec_var_ VARCHAR (+);
DECLARE rep_num INT;
DECLARE Dec_var CURSOR for SELECT id_ from act_ru_variable WHERE name_ = ' yjdqsj '
There are two methods, one is source installation, and the other is RPM installation. Mainly the latter:
First Check if it is installed, and the-I option of grep indicates that the case is ignored when matching . Rpm-qa|grep-i MySQL. The
Implicit conversions in MySQL1. Environment Description
Blog: http://blog.csdn.net/hw_libo/article/details/39252427
RHEL 6.4 x86_64 + MySQL 5.6.19
Test Table:
MySQL [test]> show create table emp\G*************************** 1. row *******************
Insert multiple data records using one mysql statement and multiple data records using one mysql statement
Assume that there is A data table:
Id name title addtime
To insert n data entries:
$time= time();$data = array( array(
MySQL cold backup solution for important businesses and mysql cold backup solution1. Overview
In the company's business, when the corresponding business data is not very important, we generally write a script to pull the full database data every
Connect to the database using JDBC and connect to the database using jdbc
JDBC (Java Data Base Connectivity) database connection, we need to use JDBC when writing web applications or java applications to connect to the database. To connect to a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service