1) Error logThe error log logs the start, run, and shutdown processes of MySQL.Locate the file by show variables like ' Log_error '.Mysql> Show variables like ' log_error '; +---------------+---------------------------------+| variable_name | Value
It's already midnight, and May Day is boring.
You can't sleep. You can install a virtual machine on your computer. Then, you can build a php environment on the virtual machine.
First, install MYSQL. I found many problems .. I will try again
After installing mysql, we can perform SQL statement operations:
Run the following command to connect to the MySQL service:
Mysql-h localhost-u root-p
-H parameter specifies the address of the MySQL server to be connected
-U parameter specifies
1. Introduction to mysqlcheck
The mysqlcheck client can check and repair the MyISAM table. It can also be optimized and analyzed.
The function of mysqlcheck is similar to that of myisamchk, but it works differently. The main difference is that
Join is to splice two tables into a large table according to a public field.
The left join is used to traverse the right table based on the table on the left.1. Introduction
Left join, self join
SELECT * FROM test_visit t1 left join
How to increase the number of connections to the MySQL database. After the MYSQL database is installed, the default number of connections is 100. The number of connections to forums or websites with a slightly higher traffic is insufficient, so how
Mysql cache function analysis:
1. The key Generation Principle of the mysql cache function is to generate a unique key based on the select statement according to certain hash rules. The select result generates a value, that is, key => value.
Program = Data + algorithm. This is the simplest definition of a program. Without a doubt, a program will inevitably store a large amount of data. for data storage, most developers should immediately think of the database, however, not all data is
A simple table tells you some query skills and index creation knowledge points. In a database table, you can create an index on fields to greatly improve the query speed. Suppose we have created a mytable table:Create table mytable (Id int not
MySQL queries table indexes in two command forms:
Mysql> SHOW index FROM 'tblname ';
Or:
Mysql> SHOW keys FROM 'tblname ';
The result obtained by running the preceding command is as follows. The meaning of each column in the result is described
The following is a summary of some common commands used in MySQL.
1. Start and exit
1. Go to MySQL: Start MySQL Command Line Client (MySQL DOS Interface) and enter the password for installation. The prompt is: mysql>
2. exit MySQL: quit or exit
Ii.
Recently, it was found that php website publishing information is slow, and asp under the same website directory often logs on again immediately after logon, taking into account the server resource occupation issue immediately, therefore, the
1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard
Sometimes we need to know the space occupied by a table in the MySQL database because of work needs. How can this problem be solved? In fact, it is very simple. Have you noticed that all databases will come with a information_schema database that
The following configurations have been successfully configured on the local machine:Function: A is the master server and B is the slave server. In the initial state, the data information in A and B is the same. When the data in A changes, B also
How can I optimize MYSQL Data insertion into the database? The following lists the optimizations.
1. if many rows are inserted from the same client at the same time, use the INSERT statement containing multiple values to INSERT several rows at the
Occasionally, you need to use php to perform some mysql Database Operation tests. It is too troublesome to write by yourself. The search results generally contain a lot of useless code. Here we will summarize the operations of php mysql, I hope you
How to use SQL statements to determine whether a known table exists
A: The solution is as follows:
Note: The following code is a module that typically references Dao.
Function fExistTable (strTableName As String) As Integer
Dim db As Database
Dim I
How to determine the maximum value in the SQL Server Column
Create table [dbo]. [MinMax] (
[MinMaxID] [int] IDENTITY (1, 1) not null,
[Value1] [int] NULL,
[Value2] [int] NULL,
[Value3] [int] NULL,
[Value4] [int] NULL,
CONSTRAINT [PK_MinMax] PRIMARY
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