Reinstalling the system is always a good solution, but who would like to do so :(
Later, I did not intend to find that the uninstallation was not completely caused by the uninstallation. The following describes how to unmount MySQL 5.1:
1. add
1. Connect to the database1. mysql_connect: Enable the MySQL link.
Mysql_connect ('host', 'username', 'Password ')
2. mysql_select_db: open a databaseMysql_select_db ('database name', $ link identifier) // if the link identifier is left blank,
It seems that the string function of MySQL intercepts characters.
Program The interception (such as PHP or Java) is powerful, so we will make a record here and hope it will be useful to everyone.
Function:
1. Extract strings from the left
Left (
The problem is that when you directly use MySQL c api to build an application, a connection can only execute a stored procedure once, no matter how free we use this connection again, there will be a prompt that we cannot execute qurry. I think such
2.1 log on to the mysql console [the user name is root, and the password is blank by default]
Switch to the mysql bin directory cd d:/wamp/mysql/bin
Log on to the mysql Console
Syntax: mysql-h hostname-u username-p
Connect to another host
Code:
Later, I was working on WordPress. I didn't know that WordPress was using the InnoDB Data Engine at the beginning, so I built a database in the original database. I didn't find any problems at the beginning, it's okay to import the SQL statement. I
MySQL supports several storage engines as processors for different table types. The MySQL storage engine includes the engine for processing transaction security tables and the engine for processing non-transaction security tables:
◆ MyISAM manages
XOR algorithm principle
From the main method of encryption, the location change method is too simple, especially when the amount of data is small, it is easy to guess the plaintext by the ciphertext, And the replacement method is an effective and
Solution 1:Recursive Algorithms are also the most frequently used. Most open-source programs do the same, but generally only use level 4 classification. The database structure design of this algorithm is the simplest. Id of a field in the category
At first, I did not expect that the data of the 10 million yuan would be inserted into a single number for only 2 w in half an hour. Later, an SQL batch insert statement was improved.
Copy codeThe Code is as follows: --
Insert into table (mobile)
Recently, some troubles have occurred. The newly installed official PHPwind6.0 community found that the mail addresses of many Members seem to be filled out randomly when importing the previous Member account information, in PHPwind5.5, mail address
Yesterday, a colleague mentioned in the PHP discussion group that a project he created had too many results (up to 0.1 million results) returned by MySQL queries, resulting in insufficient PHP memory. therefore, he asked, before executing the
1. View Indexes
(1) Unit: GB
Select concat (ROUND (SUM (index_length)/(1024*1024*1024), 2), 'gb') AS 'total Index size' FROM information_schema.TABLES WHERE table_schema LIKE 'database ';+ ------------------ +| Total Index Size |+ ------------------
WINDOWS1. MySQL has some environment variables that can be set,
You can enter show variables to view the current environment variable settings;
2. Some of these variables have character-related settings,
You can enter: show variables like 'character
If your configuration file uses a configuration file like a my-innodb-heavy-4G.cnf.
Mysql can be started normally, but innodb tables cannot be used.
The following output is displayed in the error log:
InnoDB: Error: log file./ib_logfile0 is of
I felt that the code was a little messy, and the comments and codes were written at random. There seemed to be no uniform specification, and there were also differences in the Code styles in different files. Maybe Mysql had gone through a lot of
The back_log value indicates how many requests can be stored in the stack within a short time before MySQL temporarily stops answering new requests. Only if you want to have many connections in a short period of time, you need to increase it. In
Import notes:Using tools such as phpmyadmin or navicat to import data is still quite slow. You can directly use mysql to import data.
The import command is as follows:
Mysql>-uroot-psupidea jb51.net You can
Note:
Mysql>-umysql user name-pmysql
Copy codeThe Code is as follows: /*
MYSQL database access Encapsulation
MYSQL Data access method. php4 supports process access methods starting with mysql _. php5 supports processes starting with mysqli _ and mysqli object-oriented
Access method.
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