1.1 MySQL database N MySQL Performance Blog (www.mysqlperformanceblog.com)
N MySQL PUB (www.mysqlpub.com)
N MySQL performance tuning and Architecture Design
N exploring MySQL
1. Install MySql 1. Extract
Tar-xvfz mysql-5.0.21.tar.gz
2.
Oracle's fast return mechanism has been very tangled. Although there are many result sets, it can quickly display the first result. Although it can be done through the MYSQl client, it cannot be achieved through JDBC.
It took more than an hour today
The recording program has the function of writing recorded file information to the MySQL database for query by the BS system.
Therefore, a MySQL class is encapsulated for database operations.
The main interface is Update (): Execute SQL statements.
When using mysql, you sometimes need to query records with unique fields. Although mysql provides the keyword distinct to filter out redundant duplicate records, only one record is retained, but it is often used only to return the number of
How to check and analyze logs under Freebsd is still a new topic for me. I haven't processed it before, and I don't even know where the logs are stored or how to record them.
There are some good information on the network. mysql manuals can also
First, I would like to recommend a book for beginners, a booklet: "mysql must know", which is practical and authoritative. It was a little expensive and I bought it yesterday.
Http://www.bkjia.com/ebook/201112/30389.html
Body:
Mysql
1. Copy the table structure and data to the new tableCreate table new table select * FROM old TABLEThis method will copy all content in oldtable. Of course, we can use delete from newtable; to delete it.However, the worst thing about this method is
MySQL optimization is divided into two parts: one is the optimization of the server physical hardware, and the other is the optimization of MySQL itself (my. cnf. I. Impact of server hardware on MySQL Performance① Disk seek capability (disk I/O).
1. Download The pdo_mysql package Wget http://pecl.php.net/get/PDO_MYSQL-1.0.2.tgz 2. append and compile php so that pdo_mysql.so files are generated under the module Directory.Tar zxf PDO_MYSQL-1.0.2.tgzCd
MYSQL 5.1 and later versions support the scheduled execution (event) function, which is similar to linux crontab. First, check your MSYQL version and the SQL statement for querying version information: Select VERSION ()After confirming the version
After mysql is installed, the server uses lat1 encoding by default. The procedure is as follows: Startup method:/etc/init. d/mysql. server start Effect: Database changedMysql> status--------------Mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (
Show variables;/** view the actual running parameter values of the server **/02/* check whether the stored procedure exists. If yes, delete */03 drop procedure if exists helloword04/* test the Stored Procedure */05 DELIMITER //06 create procedure
When MySQL was started earlier, it was not quite normal. I had to restart it several times but I was not concerned about it. Today, the test has encountered a problem. MySQL started normally but cannot be closed: [Root @ rac2 mysql] # service mysql
The characteristic ACID of a transaction, that is, atomicity, consistency, isolation, and durability. Atomicity ensures that a transaction is a minimum unit and cannot be split internally. Consistency ensures that each operation thread in the
Method 1: 1. in the last column of the data to be imported, write an Excel Formula (in this example, it is the cell under "SQL", "SQL" is not necessary, just for convenience ). = CONCATENATE ("insert into employee (name, birthday, email, Hober)
When installing mysql in windows xp, a problem with mysql-5.1.45-win32.msi occurs: the cocould not start the service mysql error: 0 prompts an error. After research and try, the reinstallation was successful! The procedure is as follows:1.
The method for adding fields in MySQL is not complex. The following describes how to add and modify fields in MySQL. It is helpful for you to learn how to add fields in MySQL.1. log on to the database> mysql-u root-p database name 2. query all data
This article will take a closer look at group by and order by in mysql. below is my content table simulationNow I need to retrieve the latest content in each category. select * from test group by category_id order by 'date'. The result is as follows:
Environment: MySQL Server 5.1 + Navicat for Mysql 8.2 problem: a 121 error occurs when the foreign key is deleted. Solution: Change the foreign key name to another name. For details about the error message www.2cto.com, refer to: error121. This is a
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