Introduction: MySQL 5.0.94, which is a later version (5.5, 6, and so on) does not support recursive queries. Compared with SQL Server and oracle, it is difficult for mysql to traverse child nodes in a tree table. This program focuses on the
1. Use phpmyadmin to modify the TABLE. repair table 'your TABLE name' or directly on the database management interface, select a TABLE, as shown in figure
2. If the modification fails, we can try to stop mysql first when replacing the local mysql
MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for adjusting and optimizing MySQL installation. Some tips are applicable to specific
If there is no problem with using hql statements, there will be a problem through SQL. The reason is that the SQL query field contains the field type such as mediumtext. If an error is reported, an error will be reported in ejb SQL. Just change it
I have been studying mysql database optimization over the past few days. I checked the information on the Internet and stayed here. I will continue my new research experience later. Below are some online materials
In some cases, MySQL can directly
Of course, the last part of my code is wrong. It is not a real random data fetch. Back home, hurry up to Baidu, so that we know how to randomly retrieve data ..
The rest of the code is not mentioned. Here we will show you the core data table search
MySQL server hardware and operating system adjustment:
1. Have enough physical memory to load the entire InnoDB file into the memory. The speed of accessing files in the memory is much faster than that on the hard disk.2. Avoid using Swap to Swap a
I. Generally, You need to restart Mysql if you forget the password.1. skip-grant-tablesThe common method is to use the skip-grant-tables option. After mysqld server is started, it does not use the permission system (privilege system ). The user does
REPLACE runs like INSERT. There is only one exception. Assume that an old record in the table and a record used for PRIMARY
If the new record of a KEY or UNIQUE index has the same value, the old record is deleted before the new record is
1. Field Auto-Subtraction
UPDATE 'table _ name' SET 'Total' = IF ('Total'
Generally, when performing field subtraction, we need to determine a value externally.
This can save a query for an external value judgment, or prevent the overflow of
MySQL query High-Speed Buffer
The query cache stores the SELECT query text and the corresponding results sent to the client. If the same query is received subsequently, the server returns the query result from the query cache, instead of parsing and
When you create a foreign key in Mysql, you will often encounter problems and failures. This is because Mysql still has many details to pay attention to. I have summarized and reviewed the relevant information and listed the following common causes.
SQL language basics I. Overview
SQL statement comments
1) All contents starting with "#" until the end of the line are comments
2) All content starting with "--" (-- and then a space) until the end of the line is annotated.
3) All content ending
If you have installed mysql before, uninstall it and delete the "windows Service" corresponding to mysql by running the "SC delete mysql" command.
Mysql installation
MySQL Advanced Operations (I)
I. MySQL table replication
Create table t2 like t1; # copy the table structure. t2 can learn all the table structures of t1.
Insert into t2 select * from t1; # copy table data, but this still has a defect, because the
It's time to replace MySQL with PerconaDB.
Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs
Percona Database Server is an enhanced MySQL version. It is not complicated to replace MySQL.
1. Features of PerconaDB
1) Faster
Oracle had to get MySQL approval from regulatory authorities in order to buy Sun. Currently, these efforts may be a waste of time and money and may be suddenly discovered, mySQL is on the verge of extinction.
At the MySQL conference held last month,
MySQL Proxy version 0.8.0 is released!
0.8.0 new features:
Added a thread event processing layer.
Support auth-response change
Timing infrastruture is added.
Added support for out-of-tree plugins build and pkg-config.
And bug fixes
MySQL uses the value of the environmental variable TMPDIR as the path name of the directory for saving the temporary file. If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. If the file system that
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