For people who often use MySQL, phpMyAdmin is a necessary tool. This tool is very powerful and can perform almost all database operations, but it also has a weakness that can be very slow to import large data files to a remote server, or even a long
The company's Web site access more and more large, MySQL naturally become a bottleneck, so recently I have been studying MySQL optimization, the first natural thought is the MySQL system parameters optimization, as a large number of visits to the
This problem occurs when the delete is followed by the condition.
Delete from table_name WHERE condition
When you delete data, the amount of space that the datasheet occupies does not change.
When you do not follow the conditions directly delete.
Install MySQL under Windows, with the Official Configuration Wizard generated My.ini, this thought very stable, who knows more than 10 hours past, the system response is very slow, look at the performance of the Resource Manager card, found that the
My personal practice is: phpMyAdmin export utf-8 insert mode Abc.sql
FTP Abc.sql to Server
SSH to Server
Mysql-u abc-p
Use KKK (database name, if not on create DB KKK)
Set names ' UTF8 '
SOURCE Abc.sql
Note: I see set character set UTF8; Saying,
One, the connection MySQL format:Mysql-h Host Address
-U user Name
-P User Password
1, Example 1: connected to the MySQL on this computer:
First in the Open DOS window, and then into the directory Mysqlbin, and then type the command mysql-uroot-p,
1, MyisamchkThe MySQL server must be temporarily stopped using MYISAMCHK. For example, we need to overhaul the Discuz database. Perform the following actions:# service MySQL stop (stop MySQL);# myisamchk-r/Database file absolute path/*myi# service
MySQL software version: 64-bit 5.7.12
1, first configure MySQL environment variables, at the beginning of the system environment variable path to add MySQL Bin directory path to ";" At the end, my path is configured as follows:
2, modify the
1. Create a table:
Copy Code code as follows:
drop table if exists photo;
CREATE TABLE Photo (
ID INT not NULL auto_increment PRIMARY KEY,
Name VARCHAR (m) COMMENT ' names ',
Photo blob COMMENT ' photo '
)
Engine=innodb
Environment Description:
Ubuntu 10.04.2
QTSDK (the one in the 1.5G installation package)
mysql5.1
1. Install MySQL
Linux under the full MySQL development needs to install the server side, if the installation of the client is nothing bad. Search
Copy Code code as follows:
mysql_query ("Set autocommit=0");
$list _one = $db->fetch_first ("SELECT * from prizes where id =". $id. " For UPDATE ");
$db->query ("DELETE from prizes WHERE id =". $list _one[' id '));
mysql_query
You should know more about HTML forms, and the following code is a very simple HTML form:
Surname:
Name:
When you enter the data and press the Submit button, the form will send the data to the SUBMITFORM.PHP3. This PHP script is
See Zhang Yi Blog on the "Http/rest client article", how to install what the direct skip, the following directly into the test phase, test environment: virtual machine
Copy Code code as follows:
[Root@localhost ~]# Uname-a
Linux
This example describes the MySQL subquery usage. Share to everyone for your reference, specific as follows:
Suppose the table my_tbl contains three field a,b,c; now you need to query the number of records for which column B is the minimum for each
Recently in CentOS 7, through the Yum installed MySQL, after the successful installation, using root login, there are the following error:
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
MySQL
When MySQL is installed, the system defaults to creating a root user that does not require a password, and an anonymous user (Anonymous account) without a username and no password. Perform the following initialization actions to enhance security
There is a character set translator between the MySQL client and the MySQL server.
Character_set_client =>GBK: The converter knows that the client sent the code in GBK format.
CHARACTER_SET_CONNECTION=>GBK: Converts data transferred from client
1, connect MySQL
Format: mysql-h host address-u user name-P user Password
1, connected to the MySQL on the computer.
First open the DOS window, and then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the
MySQL replication is actually a copy of the data from one node (master) to another node (slaves), of course, depending on the application architecture, the way is different, MySQL server replication between the use of binary logging mechanism.
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