The most comprehensive MySQL query statement (Review)
-- Basic QuerySelect * from pet
-- List specified ColumnsSelect name, owner form pet
-- Performs arithmetic operations directly to alias A FieldSelect sin (1 + 2) as sin
-- Where
I have been compiling and installing myself, and the installation directory is clearly allocated. Today I saw a friend who did not know me. I checked that it was installed by default,
I am not familiar with the default installed directory
Content:
*************
1
After installing MySQL, change the root password and use
Net startmysql
I encountered this problem at startup.
C:/MySQL/bin/mysqladmin-u root-P Shutdown
Net start MySQL does not have this error prompt!
1. After MySQL is installed in SuSE Linux, the default value is: case-sensitive for table names, not case-sensitive for column names;
2. log on to the/etc/My. add lower_case_table_names = 1 after [mysqld] In CNF and restart the MySQL service. The
B + Tree Index
One feature of B + tree indexes in dB is high fan-out. Generally, the height of B + tree in dB is about 2-3 layers, which means that only 2-3 Io operations are required. The current disk has approximately 100 I/O operations per
Use MySQL 5.1.33 for compilation and installation, and manually specify the installation path
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
/Usr/sbin/groupadd MySQL/Usr/sbin/useradd-G
There are dual virtual tables similar to those in Oracle in MySQL: the official statement is purely to satisfy the habit of select... from,MySQL ignores the reference to this table.
You can pay attention to the following:
Select * from
1. Floor Error
You can use the followingCode
And select 1 from (select count (*), Concat (version (), floor (RAND (0) * 2) X from information_schema.tables group by X) );
And (select count (*) from (select 1 Union select null Union select! 1)
Variables in SQL Server must be affirmed first and then assigned values:
The local variables are identified with one @ and the global variables with two @ (common global variables are usually defined );
Declare the local variable Syntax: declare @
Skip-name-resolve
Symptom:
On the MySQL 5 Server in Windows 2003, the local machine is connected to the MySQL service very quickly. There are two Linux machines in the LAN, one of which is quickly connected, and the other one enters the
I have changed from Oracle practitioners to MySQL practitioners. Of course, the reason for giving up oracle is mainly because I can write as little as possible in the new unit.Code.
Now I am facing a data warehouse. Just like the previous company,
The hompy project uses two data servers with 8 GB and 6 GB Master/Slave databases respectively.At the beginning, I always went down the machine. I used my-huge as the basic configuration many times,Later, I borrowed the configuration of
MySQL database is the first choice for Small and Medium-sized website back-end databases because it is free for non-commercial applications. website developers can build a "Linux + Apache + PHP + MySQL" platform, which is the most cost-effective and
MySQL --------
Select a. dname,
Max (If(B. Mon ='February', B. YJ,0) In March,
Max (If(B. Mon ='February', B. YJ,0) In March,
Max (If(B. Mon ='February', B. YJ,0) February
From T2 a left join t1 B on A. Dep = B. Dep
Group by dname
Turn: http://www.cnblogs.com/yidianfeng/archive/2011/02/24/1964148.html
MySQL has two common engine types: MyISAM and InnoDB. Currently, only the InnoDB Engine type supports foreign key constraints. The syntax for defining foreign key constraints
From: http://www.liuhui.info/article38.html
In the first phase of the MySQL database index Research Series, MySQL created, deleted, re-built, and viewed index commands, mastered how to create, delete, recreate, and view indexes.
1. Create an
From: http://www.111cn.net/database/110/44f4c8e26e35c649a9b42e2754a69e5d.htm
MySQL Stored Procedure error handler Exception HandlingExample: when insert fails, I want to record it in the log file,
"" Here we need to create a primary key table
Solutions to errors during mysql addition, deletion, modification, and query
Information 1: Error: Access denied for user: 'linanma @ localhost' (Using password: YES)Error Analysis: This is one of the common problems for new users to install
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