PHP

Batch delete SQL statement bitsCN.com of a specified prefix table in MySQL Select CONCAT ('drop table', table_name ,';') FROM information_schema.tables Where table_name LIKE 'dede _ % '; "Dede" is the prefix of the table to be deleted. after

How to unbind MySQL database from a local machine in Ubuntu BitsCN.com Problem:In Ubuntu, you have added a MySQL account, granted full database operation permissions, and allowed the database to access external links.However, you still cannot

How to automatically convert the integer parameters of the hql statement in ValueList through configuration bitsCN.com the parameters passed through the queryMap of valuelist are of the string type by default. in the hql of the valuelist

Restore mysql database parsing error: (mysqlErrorCode: 1005errno121) bitsCN.com The reason is that the primary key must be unique, that is, there may be duplicates in the database with the current restored database. a restriction that Foreign Keys

Experience in optimizing mysql database bitsCN.com 1. select the most suitable field attributeMySQL can support access to large data volumes, but generally, the smaller the table in the database, the faster the query will be executed on it.

A detailed description of mysql merged tables: bitsCN.com The creation and merging of mysql tables is similar to that of partition tables. it is a feature of mysql that combines multiple myisam tables with the same structure into a virtual table.

Mysql basics: mysqld_safe detailed description of the execution process for enabling bitsCN.com The basic process of mysqld_safe script execution:1. search for basedir and ledir.2. search for datadir and my. cnf.3. check my. cnf. for details about

Analysis of the Master-Slave architecture based on MySQL database replication bitsCN.com In order to expand the scalability of the application system, we often need to scale out the database. the scale out design increases the overall processing

Parsing the differences between max_connections and max_user_connections in mysql bitsCN.com has explained in the mysql manual that max_user_connections is used to restrict user resources. how can we limit user resources? A small test is conducted

Go deep into the detailed description of using parameters for table names in mysql stored procedures bitsCN.com BEGIN Declare date_str varchar (8 );Declare table_prefix varchar (20 );Set table_prefix = 'mail _ rare_visit _';Set date_str =

For details about how to configure the MySQL dual Master, bitsCN.com just took the time to perform Master-Master synchronization for MYSQL. Write down the steps and update them at any time for any problems. Here, the database I synchronized is TEST.

BitsCN.com Environment:PC: ubuntu 10.10 192.168.1.112 (master) 192.168.10.245 (slave) MySQL: 5.1.49-1ubuntu8. 1-log The database test already exists in the master. First modify the mysql configuration file:/etc/mysql/my. cnf[Master] # Author:

Analyze the differences between dropuser and deletefrommysql. user bitsCN. comddrop user will delete all the user information, while delete will only delete the user table, and other information such as the db table still exists. If you create a

Summary of the msyqlshow command bitsCN.com MySQL has many basic commands, and the show command is also one of them. in many users, the use of the show command is also prone to confusion,This article brings together the many usage of the show

Parsing auto_increment problems in mysql bitsCN.com When I visited the forum today, I found a seemingly simple problem, but it attracted wide attention:This is a very early interview question:A table contains an ID auto-incrementing primary key.

Detailed explanation of the basic process for jdbc database operations bitsCN.com All JDBC applications have the following basic procedures:1. load the database driver and establish a connection to the database. 2. execute SQL statements. 3.

Memcached learning process BitsCN.com Some time ago, our lab's sister-in-law came to show us all the new technologies in our company --------- memcached. I felt very strong. I had to go through the example of my sister-in-law, as a result, too many

In-depth analysis of limit usage in mysql Select * from table limit m, n where m refers to the index at the beginning of the record, starting from 0, and n refers to taking n records starting from entry m.Mysql (root @ localhost: test)> select *

In-depth explanation of mysql master/slave replication latency When I interviewed mysqldba, I encountered a question: Describes the implementation principle of the msyql replication mechanism. how can I restore the database node of the slave with

MySQL Query optimization-detailed explanation of adjusting internal variables bitsCN.com MySQL is so open that you can easily adjust its default settings to achieve better performance and stability. Key variables to be optimized are as