MySQL

Directly to the installation method: The fastest installation, the latest stable version, the most provincial resources! root@debianlnmp-jimmyli:~# wget http://sourceforge.net/projects/debian-lnmp/files/DebianLNMP/DebianLNMP-Jimmyli.sh

This article is the creation of a function in MySQL "ERROR 1418" solution to the detailed analysis of the introduction, the need for friends to copy the code code below: Error code:1418 This function has none of the deterministic, NO SQL, or reads

I really have the development of Linux under the food Ah, continue to record learning MySQL problems. Because yesterday according to the online tutorial to the MySQL root (localhost) password changed can not login, and according to the online

MySQL query all the information of the day: The code is as follows SELECT * FROM Test where year (regdate) =year (now ()) and month (RegDate) =month (today ()) and Day (regdate) =day (now) This is a bit cumbersome, but also a simple wording: The

　　1, download mysql free installation version/binary plate software (Do not compile) File format: mysql-version-os.tar.gz 　　2, the creation MySQL group, establishes the MySQL user and joins in the MySQL group (in different versions of UNIX, the

Page level: Engine BDB.Table level: Engine MyISAM, understood to lock the entire table, can be read at the same time, write notRow level: Engine INNODB, separate one-line record lock Table level, locking the entire table directly, and other

With regard to mysql-ha, there are many solutions, such as heartbeat, DRBD, MMM, shared storage, but each has its pros and cons. Heartbeat, DRBD configuration is more complex, need to write their own script to achieve MySQL automatic switching, for

In real life, backing up the database on a regular basis is an extremely important task. When we use MySQL, there is a lot of choice in database backup, and this article will show readers how to use MySQL's mysqldump to back up the database. 　　First,

The role of foreign keys: Maintain data consistency and integrity, primarily to control the storage of data in foreign key tables. Causes the two tables to be associated, the foreign key can only reference the values of the columns in the outside!

Under MySQL, in the Chinese fuzzy search, often return some unrelated records, such as looking for "%a%", the return may have Chinese characters, but no a character exists. I have encountered similar problems before, after a detailed reading of

Unix timestamp converted to date function: From_unixtime () Select From_unixtime (1156219870); Date converted to UNIX timestamp function: Unix_timestamp () Select unix_timestamp (' 2006-11-04 12:23:00′);

mysql| Script | Automatic installation After a few days of testing, finally can be released! 1. Under the MySQL source code directory to create a new script install.sh, add the following code to this script: #!/bin/bash#############################

mysql| user rights You can have 2 different ways to add users: by using the grant statement or by directly manipulating the MySQL authorization table. The better approach is to use the GRANT statement because they are more concise and seem to have

mysql| Security | security | access | server | data | Data Directory This chapter focuses on what you can do to maintain the security and integrity of MySQL installations as a MySQL administrator. We've talked a little bit about security issues in

mysql| optimization 7.2.1 EXPLAIN syntax (get relevant information about Select) EXPLAIN Tbl_name Or: EXPLAIN SELECT select_options The EXPLAIN statement can be used as a synonym for DESCRIBE, or it can be used to get information about a SELECT

The function of the query log is to record all the SQL statements sent by the client, that is, to record all operations of the client Log parameter is going to be obsolete, now replace with General_log Open Query Log Feature Mysql> showvariables

Php+mysql+linux is now becoming a classic combination of small Web servers. Building and debugging a MySQL database in a Windows environment is a preferred choice for many Web developers. I am in the WINDOWS98 environment to learn MySQL, now the

Recently, open source database developers MySQL company in the 2007 MySQL conference announced the latest Mysqlclustercarrier gradeedition (Mysqlcluster telecommunications-grade version) database DBT2 benchmark results. This test was done with

Download page: http://dev.mysql.com/downloads/mysql/5.0.html#downloads To the bottom of the page, find source downloads, this is the source version, download the 1th tarball Groupadd MySQL Create a new user group named MySQL useradd-g MySQL

This period of time MySQL on the development process crashes 2 times, has not found the reason, because the use of the MacBook is fully equipped with memory, top view also no exception. SAR is also normal. The MySQL log also has no valuable