MySQL

The following script is a simple command used to execute remote database queries. I believe everyone can understand it. This is for some brothers who need to automatically check the database or execute certain statements every day, it is very

To know the size of each database, follow these steps:1. Enter the information_schema database (storing information about other databases)Use information_schema; 2. query the size of all data:Select Concat (round (sum (data_length/1024/1024), 2),

Generally, the Master/Slave Mechanism Based on LAN can meet the requirements of 'realtime' backup. If the latency is high, first confirm the following factors:1. network latency2. Master Load3. Slave LoadThe general practice is to use multiple slave

Unique query for a single table: distinct Unique query for multiple tables: group When distinct queries multiple tables, left join is still valid and full join is invalid, When using mysql, you sometimes need to query records with unique fields.

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 shoshould be uniquely named throughout the database, an effective method is to

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 remotely access the MySQL database. Cause:In Ubuntu, the default MySQL

Apache:If the RPM package is used for installation, the installation path should be in the/etc/httpd directory.Apache configuration file:/etc/httpd/conf/httpd. confApache module path:/usr/sbin/apachectlWeb directory:/var/www/htmlIf source code is

Query is the core of the database. The following describes how to implement Mysql multi-Table query. If you have encountered any problems in Mysql multi-Table query, take a look. Mysql multi-Table query: Copy codeThe Code is as follows: create

Generally, the table has a Create date Field, and other databases have default options. MySQL also has the default value timestamp. However, in MySQL, the value of timestamp is updated even if it is inserted or modified! In this way, it is not the

MySQL Order By keyword is used to classify the data in the record.MySQL Order By Keyword ClassificationOrder by keyword is used to classify the data in the record. Copy codeThe Code is as follows: SELECT column_name (s) FROM table_name Order by

Drop user deletes all user information, while delete only deletes the user table. Other information, such as the information in the db table, still exists. If you create a user with the minimum permission after the delete operation, the user will

Copy codeThe Code is as follows: Class MySession extends DBSQL { /*** _ Construct ()*/Public function _ construct (){Parent: :__ construct (); } /*** Open ()** @ Param $ sSavePath* @ Param $ sSessionNames** @ Return true*/Public function open ($

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: zhxia Copy

We often encounter the problem of setting the current time as the default value in MySQL. The following describes how to set the current time as the default value in MySQL.Database: test_db1Create Table: test_ta1Two fields: id (auto-increment and

I have read a lot of questions about mysql. sock on the Internet before, but I didn't pay attention to the significance of this issue until I encountered the same problem in my mysql. It's confusing ...... Copy codeThe Code is as follows: zhouqian @

I installed a mysql on the virtual machine, modified its my. cof file, and found that this configuration file is powerful, but encountered a problem: When setting character sets, set default-character-set = utf8 under [client], [mysql], and [mysqld]

When I used the mysql database in my experiment today, I forgot my password and asked me to find it for a long time. Now I want to introduce my own method: I used mysql functions for testing. Copy codeThe Code is as follows: mysql> select user,

This article mainly describes the actual operation steps of connecting Java to the MYSQL database (taking MySQL as an example). We use related instances to introduce the actual operation process of connecting Java to the MYSQL database, the

1. Each client connection is divided into a thread belonging to the server process. The corresponding queries of the connection are all processed by this thread. 2. The Server caches the thread. Therefore, no threads are created or destroyed for

Copy codeThe Code is as follows: #/bin/sh # Check whether mysql server provides services normallyMysqladmin-u sky-ppwd-h localhost ping # Obtain the Current Status values of mysqlMysqladmin-u sky-ppwd-h localhost status # Obtain the current