problem : Linux on MySQL out table ' xxx ' doesn ' t exist errorcause : MySQL on Linux defaults to case-sensitive results.Fix : Change MySQL configuration file, in my.cnf [mysqld] below (position cannot be wrong) Add lower_case_table_name=1 this
Mysqlnd is a good thing. Not only can improve the efficiency of communication with MySQL database, but also can easily set some timeouts. For example, the connection timed out and the query timed out.However, when using MYSQLND, there is a place to
The table looks like this
The code is as follows
Copy Code
SELECT * from ' test_table_draw ' WHERE ' borough_id ' >=10266 and ' borough_id 'huxing tableSELECT * from ' test_table_pic ' WHERE ' borough_id ' >=10266 and '
Example One
The code is as follows
Copy Code
Grant all privileges on wxtest.* to root175@111.34.73.175 identified by ' 11111 '
Add a root175 user, password is 11111, can only login on the 111.34.73.175, and the
1, Judge ApacheFirst execute command to find httpd pathPS aux | grep httpdsuch as httpd path is/USR/LOCAL/APACHE/BIN/HTTPDThen execute the following command/usr/local/apache/bin/httpd-v | grep "Server_config_file"You can find the configuration file
View MySQL Port is open
netstat-tanl | grep 3306
MySQL User's authorization
Mysql-uroot-p
View the existing User authorization table
Select User,host,password from Mysql.user;
Test connection to other MySQL server
Mysql-uroot-p-h192.168.0.100
That's what Rand said in the handbook:
RAND ()RAND (N)
Cases
The code is as follows
Copy Code
SELECT * FROM table_name ORDER BY RAND () LIMIT 5;
Returns a random floating-point value in the range 0 through 1.0
Related Parameters View commands
SELECT @ @join_buffer_size;
SELECT @ @sort_buffer_size;
==========================================================================================
Join_buffer_size
The buffer used when our join is All,index,rang
Maybe a programmer to a del, a backup time set after the data to find can not find it back, check the data using MySQL log can be a good solution to the previous problem, the advantage: is to restore to a point in time, or an operation of SQL
300M High speed PHP free space
The free php space size is: 1000M
The flow limit per month is: 25000M
Single file maximum limit: 8M
Support Ftp/web way to upload and manage files
Supports PHP5 and provides 3 MySQL databases free of charge
Can
ugu.pl Poland 150M can be bound rice free php space
Support FTP upload and management files;
Free to provide two-level domain name, you can also bind their own domain name;
Support PHP4, PHP5, and provide 50M MySQL database, also provide support
Place the following file in the System32 directory,Then, open it with a note.Backupsql.batwill be inside the"The location of the data directory for the e:sql2000 database *.*"Change to your own SQL2000 data directory, such as"E:program
GROUP by (aggregate) functionsThis chapter discusses group (set) functions for a set of numeric operations. Unless otherwise stated, the group function ignores NULL values.
If you use a group function in a statement that does not contain a roup by
Each language will have some keywords or reserved words, MySQL is no exception, here are listed, easy to query:
MYQL keyword list, mark.
ADD all ALTER ANALYZE and as ASC asensitive before BETWEEN BIGINT BINARY
ADD
All
Alter
Method One:
My common practice is to add a Delete identity field to the database.such as: isdel=1 so that the code deleted the field
Method Two:
Direct restriction of MySQL DELETE statement deletion
Add parameter-u when starting MySQL
There are two main ways to handle MySQL transactions.
1, with Begin,rollback,commit to achieve
Begin a transactionROLLBACK TRANSACTION RollbackCommit TRANSACTION Confirmation
2, directly with the set to change the MySQL automatic submission mode
Create an indexIndexing is especially important for queries as a major application. Most of the time the performance problem is simply because we forgot to add the index, or we didn't add a more efficient index. If you do not addIndex, then look for
1. IntroductionIn the Web application architecture, the data persistence layer (usually a relational database) is a key core part that has a very important impact on the performance of the system. MySQL is currently the most used open source
1. Semicolon exceptionsFor MySQL, the first thing you must remember is that every line of its command is ended with a semicolon (;), ...... There is no such thing as absolute. The same is true here. When a MySQL line is inserted in the PHP code, it
Linux cleanup methodDelete the operation log of the database, as shown in the following figure:Mysql-bin.000001Mysql-bin.000002Mysql-bin.0000031. Enter mysql-u root-p and password2. Enter the reset master after successful entry ;!Mysql> reset master;
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