Today I would like to try Qt How to connect the database. Who knows how to write the hint driver not loaded I was depressed. I myself is VS2010 + Qt4.8.4 + MySQL5.1 environment on-line check is C:\Qt\4.8.4\plugins\sqldrivers without MySQL dll and
MySQL Lock-related viewsView transactions, and the thread ID corresponding to the transaction if a blockage, deadlock, etc can be executed kill thread ID kill thread Kill 199SELECT * from INFORMATION_SCHEMA. Innodb_trxSELECT * from
1.if statements delimiter \create procedure P1 () BEGIN DECLARE I int default 0 ; if i = 1 then select 1 ; ElseIf i = 2 then select 2 ; else select 3 ; End if ;end \delimiter; 2. Cycleintset num =0whiletendo Select
Log a bug that myeclipes remote connection to MySQLtoday, when playing the framework hibernate, there is a very confusing bug, say not much, first look at the bug for user ' root ' @ ' localhost ' (using Password:yes)Then a variety of search Baidu,
Enumeration types and collection typesThe value of a field can be selected only in a given range, such as a radio box, a multi-marqueeThe enum radio can only select a value within a given range, such as gender sex sex male male/female femaleSet
MySQL formatted date: date_format (date, format)Date: Time fields format: Date formatFormat the date value according to the format string:%s,%s two digits in seconds (00, 01, ..., 59)%I,%I two digits in the form of points (00, 01, ..., 59)%H two
1.1 MySQLmaster-slave replication:Environment Planning : There are DB01 servers in the cluster as the database master server , because of the notebook space problem here the Backup server as Slave server , Don't install new machines , save some
caused by inconsistent codingAlthough most of the exports are not problematic, the problem occurs when the data table stores some scripts (Rich text content), forcing the specified encoding to be resolved.Specify the encoding when MySQL
If a commit is not executed in the stored procedure, the operations performed by the stored procedure are rolled back once the spring container has a transaction rollback. If the stored procedure executes a commit, the transaction for the database
MySQL basic command
SQL featuresDML(数据操作语言):用于检索或修改数据。DDL(数据定义语言):用于定义数据的结构,如创建、修改或者删除数据库对象。DCL(数据控制语言):用于定义数据库用户的权限。
View Databaseshow databases;
Working with databasesuse test1;
View tables in the databaseshow tables;
View table
To optimize a query, we need to know exactly where this query's performance bottleneck is, is it consuming too much CPU, or does it require too many IO operations? To be able to understand this information clearly, in MySQL 5.0 and the MySQL 5.1
51ak shows you MYSQL5.7 source code 2: compile existing code, 51akmysql5.7
Have worked as a DBA for many years
MYSQL source code is also the first contact
Try to record the process of viewing the MYSQL5.7 source code by yourself
Directory:
51ak:
Mysql index description
I. What is an index?
An index is an independent storage unit in which the physical space of a field and field in the data table is recorded. Indexes are supported by algorithms, which can make queries very fast.
With the
MySQL optimization: three simple minor adjustments to optimize mysql Adjustment
I don't want to be an expert DBA, But when I optimize MySQL, I respect the 80/20 principle, specifically by simply adjusting some configurations, you can squeeze out
Mysql Big Data Query Optimization experience (recommended) and mysql Experience Sharing
Mysql optimized!
Mysql has a small amount of data and is not necessary for optimization. It has a large amount of data and is indispensable for optimization. If
Mysql Time query optimization skills based on time, mysql Time query skills
For example, to query newly registered users yesterday, the statement is as follows:
EXPLAINselect * from chess_user u where DATE_FORMAT (u. register_time, '% Y-% m-% D') =
Database ~ Notes for Mysql derived tables ~ Mysql is derived from the slow query of millions of data
Basic Concepts
A derived table is a virtual table returned from a SELECT statement. A derived table is similar to a temporary table,SELECTIt is much
A good mysql interview exercise, having comprehensive application, mysqlhaving
Write an SQL statement to calculate the average score of two or more failed subjects.
> Two or more subjects must fail.
> Calculate the average score of all the subjects
How to synchronize data from MySQL to MongoDB !, Mongodb Data Synchronization
With the business development of many companies, a single database instance can no longer meet business needs, and data exchange needs to be conducted regularly to
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