The installation graphic tutorial for MySQL is for beginners. Currently, MySQL is the latest stable version.Mysql http://www.jb51.net/softs/2193.htmlThe following is an example of MySQL installation. It is installed using an executable file! Open
Analyze Table When optimizing SQL statements, MySQL Optimizer must first collect related information, including the cardinality of the table (which can be translated as "hash degree "), it indicates the number of different values in the column
Description:When using mysqldump to export a Trigger, you may encounter a problem and paste it to avoid mistakes.When you perform the following operations:Copy codeThe Code is as follows:[Root @ ytt ~]
1. The concat function is often used to convert Int to varchar. For example, the concat (8, '0') string '80' is obtained'2. Convert varchar into an Int string of the varchar type using cast (a as signed).Summary: type conversion is similar to SQL
First, add the login user permissions on the master server:Grant replicate slave on *. * to 'username' @ 'host' identified by 'Password'Set the my. ini file of the master server.Server-id = 1 # master server idLog-bin # enable binary
PhpMyAdmin was used for execution at the beginning, and a bunch of errors occurred later. begin was removed and can be executed normally after the end, but the stored procedure cannot be executed in phpMyAdmn, in the mysql command line text box, you
Using MYSQL_PWD is insecure. See connection to MySQL server in MySQL 6.3."Mysql" uses the file named in the environment variable MYSQL_HISTFILE to save the command line history. The default value of the historical file is "$ HOME /. mysql_history ",
If you have hundreds of thousands of data records, you can search for some popular words, and then read the last few pages to repeat the old dream. Mysql is so tragic that it does not stop operating hard disks.Therefore, you can try to make mysql
In MySQL, some irrelevant records are often returned during fuzzy search of Chinese characters. For example, when searching for "% a %", Chinese characters may be returned, but no a character exists. I have encountered similar problems before. After
1After installing MYSQL, change the ROOT password and useNet startmysqlI encountered this problem at startup.C: \ mysql \ bin \ mysqladmin-u root-p shutdownNet start mysql does not have this error prompt!*************2MySQL error 1067Q: I
Copy codeThe Code is as follows:Create or replace view BLOG_V_ADMIN(ID, NICKNAME, SEX, EMAIL, PHONE, QQ, MSN, HTTP, REGISTER_TIME,IP, LAST_LOGIN_IP, LOGIN_TIME)ASSELECTA. ID, A. NICKNAME, A. SEX, A. EMAIL, A. PHONE, A. QQ, A. MSN, A. HTTP, A.
The general fuzzy query statement is as follows:
Copy codeThe Code is as follows:SELECT field FROM table WHERE a field Like Condition
SQL provides four matching modes for conditions:
1, %: represents any 0 or multiple characters. It can match any
Rsync is used to configure a large number of mysql instances, saving a lot of time for compilation and configuration. After modifying my. cnf of the master and slave servers one by one, it is found that the data cannot be synchronized,On the slave
How to obtain the number of occurrences of a long string in SQLFor example, there is a string:
X-BGS-2010-09-15-001
I want to know the number of occurrences of '-', which can be implemented using the following method without complex one-Character
If on duplicate key update is specified at the end of the INSERT statement, and DUPLICATE values appear in a UNIQUE index or primary key after the row is inserted, the old row UPDATE is executed; if the unique value column is not duplicate, a new
Solution 1: Use the ignore keyword
If you use the primary key primary or the unique index unique to distinguish the uniqueness of a record, you can use the following to avoid repeated insertion of records:
Copy codeThe Code is as follows:Insert
Some netizens asked me how to automatically back up the MySQL database under win2003. Since it is an automatic backup, I must write a script. I thought, this is not very difficult, it is very easy to implement, backup can be implemented using
1. Check and modify the my. ini configuration file of mysql.Copy codeThe Code is as follows:Default-character-set = utf8
2. To create a database, you must specify the character set.Copy codeThe Code is as follows:Create database mydb default
I. SQL Mode
SQL pattern matching allows you to use "_" to match any single character, while "%" matches any number of characters (including zero characters ). In MySQL, the SQL mode is case-insensitive by default. Some examples are shown below. Note
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