Address: http://hi.baidu.com/leilei1334/blog/item/2dcfe8ce93df890092457e3d.html
The error is that two MySQL instances installed on the MySQL error number 2003 Machine
One is mysql5.0 port: 3305 Manual start service
One is mysql6.0 port: 3306
Common Errors!1016 error: the file cannot be opened. Use the background or phpmyadmin to fix the problem.1044 error: the database user permissions are insufficient. Contact the Space Provider to solve the problem.1045 error: Incorrect database
1005: An error occurred while creating the table. 1006: database creation failed 1007: the database already exists. An error occurred while creating the database. 1008: the database does not exist. An error occurred while deleting the database. 1
Common Mistakes!
1016 Error: File cannot be opened, use background repair or repair using phpMyAdmin.
1044 Error: Database user permissions are not sufficient, please contact the space provider to resolve
1045 Error: Database server/Database
MySQL does not support subquery optimization.
1. Create a table
Create table tt1 (id int primary key, c1 INT );Create table tt2 (id int primary key, c2 INT );Insert into tt1 values );Insert into tt2 values (1, 2), (2, 2 );
2. Execution Plan and
1. Create a table createtablett1 (idintprimarykey, c1INT); createtablett2 (idintprimarykey, c2INT); insertintott1value
Create table tt1 (id int primary key, c1 INT); create table tt2 (id int primary key, c2 INT); insert into tt1 value
1. Create
Write in front:This article mainly wrote some tips to speed up the blinds and the more elaborate statements in the blinds, although injecting is not a new technology. But database injection vulnerabilities continue to plague every security vendor
Write in front:This article mainly wrote some tips to speed up the blinds and the more elaborate statements in the blinds, although injecting is not a new technology. But database injection vulnerabilities continue to plague every security vendor
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.