1.
The code is as follows
Copy Code
$connection =mysql_connect ("localhost", "root", "password"); Connect and select a database servermysql_select_db ("Test", $connection);$query = "INSERT into users (user_name)"; Insert
When there is too much SQL paging (for example, limit 1000000, 20), the efficiency is significantly reduced, how to optimize?
SQL Server uses a similar:
The code is as follows
Copy Code
SELECT Top * from USER order by
Thread_cache_size
Query process Usage
The code is as follows
Copy Code
Mysql> show global status like ' thread% ';+ ——————-+ ———-+| variable_name | Value |+ ——————-+ ———-+| threads_cached | 26 || threads_connected | 510 |
If you want to ensure the integrity of your data, the best thing to do is to stop the service, not write the data to the database, and then restore it all on the new db. But in this case, a lot of data may take several hours to back up and restore
First of all need in the same LAN two machines (of course, can also use a machine virtual two machines out), are installed on the MySQL service.
Host a:192.168.1.100
From Machine b:192.168.1.101
Can have more than one from the machine.
1, first
Test example, I login to my local MySQL database in phpMyAdmin, the default username password is root,root but I try to enter root, the password is www.111cn.net the following error reminder.
The following illustration shows a reminder that #1045
Error connection
Warning:mysql_connect () [Function.mysql-connect]: [2002]
Hostname should be modified at this time, for example, in the CI configuration database (database.php) from:
$db [' Default '] [' hostname '] = ' localhost '; To:
$db ['
MySQL defaults to only local logins, and the following actions allow users to have remote permissions, taking root as an example.
in command state
First, allow users to log on at any IP, and have all the permissions of all databases:
Grant all
Use the MySQL command to view
MySQL built-in directly to see the status can see the system common information, such as the following example:
The code is as follows
Copy Code
1.$ Mysql-u Root-p2.mysql> s"Threads:2
One, uptime can view the running time of the system
Show global status like ' uptime ';
Second, use the Linux command to view
[Root@dbserver ~]# ps aux | grep MySQLRoot 29090 0.0 0.0 70232 1364? S Jun05
The current value of the EC variable can be checked by executing the mysqladmin variables command. Variable available--set-variable var_name = value option is set on the command line (-ovar_name = value is equivalent). If you want to set several
The following UPDATE statement executes the replace test in www.test.com with ABC
UPDATE table name SET field name = replace (field value before substitution, ' replace keyword ', ' replace keyword ') WHERE field name REGEXP "field value before
A set can contain up to 64 members whose value is an integer. (Set type base check MySQL data type set type) The binary of this integer indicates which members of the set's value are true. For example, there is a ' Status ' set
The code
Wildcard description_ and any single character match% matches a string that contains one or more characters[] matches any single character in a particular range (for example, [a-f]) or in a specific set (for example, [abcdef]).[^] matches any single
Often encounter the need to export data from the database to Excel files, with some open source class library, such as Phpexcel, it is easy to implement, but the support for a large number of data is very bad, it is easy to reach the PHP memory
When we do a statistical query, sometimes we need to use the same date/position and other conditions of different information for the row of the statistics, this time will need the following methods to statistics, very convenient.1. Table structure>
Absrtact: Using Binlog Flash-back error operation data.Basically, every programmer working with the database (and probably your colleagues) will have a problem, how to quickly rollback after MySQL misoperation? For example, delete a table, forget to
Look in the system log for
Event Type: ErrorEvent Source: MySQLEvent Type: NoneEvent id:100Date: 2016-11-10Event: 10:00:11Users: N/AComputer: xxxxxx005dDescribe:Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.
For more information, the
In the next window of the configuration wizard, the system asks if you wantMySQLInstall as a Windows service and whether the service should be started along with the server. In addition, you must decide whether to add the MySQL command to the
When you uninstall the old MYSQL database service from your computer, stop the MYSQL service in the WINDOWS service first. Go to the add and delete programs in the control panel to delete the MYSQL service. However, if you cannot completely delete
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