MySQL

#!/bin/sh# File:/data/backup/dhdatabak.sh# Write By:sandy# Last Modify:2013-09-11# Database InfoDb_name= "Osite"Db_user= "USER"db_pass= "PWD"# Others VARsBck_dir= "/data/backup/dhdata"Date= ' Date ' +%y%m%d-%h_%m

A site that uses a MySQL database, "Too many connections" error occurs when there are too many access connections. There are two cases of this error, one is that the Web site access is too large, the server can not afford, at this time should

Select curdate(); --Get the current dateSelect Last_day(curdate()); --Get the last day of the month. Select Date_add(curdate(),interval - Day(curdate())+1 Day); --Get the first day of the monthSelect Date_add(curdate()- Day(curdate())+1,interval 1

1. Check the MySQL character setting: If it is not GBK, make the relevant settingsMysql>set character_set_client =gbk ;Mysql>set character_set_connection = gbk;Mysql>set character_set_database = gbk ;Mysql>set

Mysql> Show index from tblname;mysql> show keys from tblname; The name of the table sheet. Non_unique 0 If the index cannot include a repeating word. 1 if it is possible. · The name of the Key_name index. Seq_in_index the column sequence number in

Remember a very long SQL, in order to facilitate reading, I have added the paragraph: SELECT * from ( (SELECT 1 asAcheck, S1.id, S1.plan_name, S1.cost_mode, S1.sta_type, S1.cost_type, S1.cost_period_time, S1.cost_period_value, S1. '

[Understanding Index]To understand an index, you first need to understand how the data is stored on your hard disk. Different storage engines may not take the same action, for example, the MySQL client defaults to MyISAM, which creates a separate

Sometimes you write your own tools to get a variety of table information from a remote database, so you get the data dictionary first.Make a list of how MySQL gets Use Information_schema; Select from schemata; Select from where

Create a test tablemysql> desc; +-------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+----------------+| ID int(one) | NO |

First, the main advantagesThe concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized.Operations on any one database are automatically applied to another database, keeping two of the

For English, MySQL's Fulltext property is quite convenient and efficient to implement full-text retrieval, but there are some things to be aware of in the process of using.First, we add the Fulltext attribute to the field we need to retrieve

Last night to help friends set up a server, has been a yum MySQL can not install. The error message is as follows:Transaction Check Error:File/etc/my.cnf from install of mysql-libs-5.1.66-2.el6_3.x86_64 conflicts with file from package lunamp-1.1.9

MySQL index type overview enables MySQL to run efficiently Index is the key to quick search. The establishment of MySQL indexes is very important for the efficient operation of MySQL. The following describes several common MySQL index types. Index

MYSQL database Naming and Design Specifications1. Design Principles 1) standardization and standardizationData Standardization helps eliminate data redundancy in databases. There are several forms of standardization, but Third Normal Form (3NF) is

The founder of the technology company talked about the future of MySQL As the stable version of MySQL 5.7 is approaching its official release, we have joined various MySQL branches to continue to compete for market share. We interviewed Peter

MongoDB and MySQL operations On the left is the mongodb query statement, and on the right is the SQL statement. It is easy to use. Db. users. find () select * from users Db. users. find ({"age": 27}) select * from users where age = 27 Db. users.

Explore paging performance-mysql Paging technology is very common in development. I used paging technology for the two projects I just joined the company, so I thought about in-depth exploration of paging technology. Several common paging

Some Suggestions on using Perl DBI for MySQL operations, perldbi Using perl to connect to mysql, there are many cases on the Internet. Generally, we use the DBD: MySQL module under DBI. Here we create a mask to get a TIPS:Perl DBI MySQL Character

Mysql common SQL statements (1)[1] Clear TABLE statement truncate table fke_message; [2] resetting the start value of the auto-increment Field alter table fke_message auto_increment = 10001; [3] common table creation statements Drop table if

A simple paging Optimization Method for MySQL in Big Data scenarios. Usually, an application needs to flip the data in a table. If the data volume is large, it may cause performance problems: root@sns 07:16:25>select count(*) from reply_0004 where