MySQL

DDL (data definition Language), which is used primarily to alter the structure of tables, data types, links between tables, and constraints, are used to build tables. The main orders are create,alter,drop.DML (data manipulation Language)

After installing MySQL at night (System: Deepin WINXPSP2, MySQL version: 5.1.32), the default data storage path is configured with MySQL's own configuration tool: C:/Documents and Settings/all users/ Application Data/mysql/mysql Server 5.1/data/.

Download MySQL and upload to the server1. Download MySQL binary installation package on MySQL websiteHttps://edelivery.oracle.com/osdc/faces/SearchSoftware?_afrLoop=2326871189822158&_afrWindowMode=0&_ Adf.ctrl-state=hqkzyoa95_92. Upload to the

How to modify MySQL character encodingDescription: MySQL character encoding modification there are several ways to modify the configuration file directly, or through the way of the command, here only to modify the configuration file method. I.

Script Monitoring Database Master-Slave synchronizationSource: http://oldboy.blog.51cto.com/2561410/1632876Source:(production case): monitor MySQL master-slave synchronization is abnormal, if abnormal, send sms or mail to the administrator. Note: If

A view is a virtual table exported by one or more tables in a database, so that the user can only care about the data that is useful to them and the security of the database system without seeing the data in the whole database table. The database

--Trigger is a special kind of monitor and delete operation, and produce corresponding operation--1, monitor who 2, monitor action 3, monitor time (before or after) 4, trigger event--simple syntax of triggerCreate TRIGGER Trigger name

Stop MySQL service under Windows:1. Open the Windows command prompt:2. Go to the bin location of MySQL installationnet stop MySQLSimilarly, open: net start MySQL (where MySQL is the service name)If there is no system serviceThen mysqladmin shutdown

Transferred from: http://blog.chinaunix.net/uid-23284114-id-3196638.htmlThe MYSQL LOAD Data infile command can import a CSV flat file into a database.Under Linux: LOAD DATA INFILE '/home/test/dump/ip_location.csv ' Into TABLE

MySQL tuning (mamcache) Architecture Web+memcache [192.168.5.14]Memcached [192.168.5.16]Mysql [192.168.5.15] Building lamp Architecture [5.14] Yum Install http* php* mysql*-yAdd a Web site/ETC/INIT.D/HTTPD startModify Web

Information reference: Http://xiezhenye.com/2015/01/%E6%89%BE%E5%88%B0-mysql-%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E7%9A%84%E4%B8 %8d%e8%89%af%e7%b4%a2%e5%bc%95.html Create a ' problematic ' table1. Create a table test1CREATE TABLE test1 (id int

1. Change the My.ini file for the MySQL installation folder (C:\Program files\mysql\mysql Server 5.5)Settings: Default-character-set=utf8Character-set-server=utf8Then restart the MySQL service. MySQL does not have to restart the command, to stop

During the week:SELECT * FROM Wap_content where week (created_at) = Week (now)Query Day:SELECT * FROM table where to_days (column_time) = To_days (now ()), select * FROM table where date (column_time) = Curdate ();Query 7 days:SELECT * FROM table

1. Extract the source code package (unzip to/usr/src/)tar zxvf keepalived-1.2.18.tar.gz-c/usr/src/2. Source code installation (under Unzip directory)(1)./configure(2) make(3) make install3. Generating RPM packages with source code packages(1)

backup and restore of MySQL under Linux2.1 Backup[[email protected] ~]# cd/var/lib/mysql (go to MySQL library directory, adjust the directory according to your MySQL installation situation)[[email protected] mysql]# mysqldump-u root-p

1. Add your own data directory and XML file2.lib Dependency Commons-logging-1.1.1.jar Dbunit-2.4.8.jar Junit-4.9b2.jar Mysql-connector-java-3.1.12-bin.jar Slf4j-api-1.6.1.jar Slf4j-jcl-1.6.1.jar 3.ant file as

First talk about MySQL data distribution, the most commonly used is replication (replication) technology. There are many middle architectures based on this technique, and the classification is summed up as follows:1, tree structure

MySQL Basic operationTo display the currently existing database:show databases;DatabaseInformation_schemaMysqlPerformance_schemaCreate a databaseCreate database user;Note: Under UNIX, the database name is case-sensitive (unlike the SQL keyword), so

MySQL High-Availability service deploymentMySQL master-slave setup is complete, (MySQL master-slave deployment please see MySQL master-slave replication now has a problem, if the master server down, how to quickly restore service? We have two sets

Sometimes, for example, to build a test environment, or to clone a Web site, you need to copy an existing MySQL database. It can be implemented very simply by using the following methods. Suppose the database name already exists is called DB1, want