MySQL

MySQL's one-way copy operation is simple: it takes about 20 minutes to read this article to get it done. http://11837782.blog.51cto.com/11827782/1885967In order to improve the robustness of the master-slave server, we chose the method of MySQL

Database as a warehouse for storing data, the query can be said to be the daily operation of the database accounted for the largest proportion, and select tone can be said to be the most complex.Select is one of the DML tones, and other DML tones

A web-connected JSP code snippet for MySQL, which gives the backup file of the database. But there is only frm,Each table in MySQL has three files. Individually, *.frm is a descriptive narrative of the structure of the table. *. MyD saves the data

Using the mysqldump command to back upThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very simply. It

Tag: Exactly and log Dex Server module dir supports codeSometimes we just want to set the lamp environment to do a test, do not care about the directory and configuration specification, this tutorial is for this idea and write can be simple and not

MySQL Default character retrieval policy: UTF8_GENERAL_CI is case insensitive , this is the default collation of the UTF8 character set; Utf8_general_cs is case-sensitive, utf8_bin means binary comparison , also case-sensitive:

. Cascade WaySynchronize update/delete out a matching record of a child table when Update/delete records on the parent table. Set NULL modeSet the column of the matching record on the child table to NULL when the record is update/delete on the

Read some of the books that optimize MySQL operations, as summarized in this record:Enter the following SQL into the MySQL client:1. Connection settingsShow variables like '%max_connection% ', show status like '%max_used_connections%

Read the words this morning:Order: OrdersConstraint: (mandatory) constraintFOREIGN key: FOREIGN keyReferences: Point toOrderItem: Order ItemsJoin: JoinResourceBundle: Resource BundleClassLoader: Class LoaderProperties: AttributesInputStream: Input

MySQL just installed only to recognize the host is: localhost and 127.0.0.1, suppose you want to let your on-machine IP can log in normally there are two ways:One is to authorize your IP 172.16.1.10.Grant privileges on dbname.* to "user" @ "172.16.1.

Fault:Before Phpmyadmim and Yii connected to MySQL are all right. One day, the same time, such as the following error:1, Linux under phpMyAdmin "missing mysqli extension, please check the PHP configuration." ”2, Yii appears cdbconnection failed to

After: is the data before and after the deletion and modification, and then triggered. Trigger the statement later than the monitoring of additions and deletions, can not affect the previous additions and deletions to modify. This means that the

As a small white I, this problem took half a day to solve, hereby recorded.Two tables: Article table and comment formArticle table (article): IDComment form (comment): Id,c_aidRequirements: Query the number of all articles and comments and then

This article "My MySQL Learning Experience (ii)" will explain the MySQL triggerA trigger is a special stored procedure, in which the stored procedure is called with call, and the trigger does not need to use the callingIt does not need to be started

Differences in syntaxI'm mainly talking about grammatical differences here.1. Default ConstraintsDifference: MySQL does not use parentheses after the default keyword--sqlservercreate table emp (ID int default ())--mysqlcreate table emp (ID int

MySQL backup script, record:Fully prepared:#!/bin/sh set -x                                                               user=root password=123456time= ' date + '% Y-%m-%d-%h-%m "'   date >> /data/mysqlbackup/logs/$time ' _allbackup.log '    #1

Create Table 'User'('ID' int(Ten) not NULL,'username' varchar( -) not NULL,'Password' varchar( -) not NULL,Primary Key('ID'),Unique Key 'username');Reason for error: Remove the single quotation mark and change to the followingMysql> CREATE TABLE

In MySQL 5.7, how do I modify the root password ?, Mysqlroot For a long time, MySQL's application and learning environments are both MySQL 5.6 and earlier versions, and they have not paid attention to the changes and new features of the new version

For some time, Start Initialization installer and startinitialization will pop up in Mysql. As the most urgent development project was to work overtime, the CMD window suddenly appeared on the computer desktop (figure 1), which meant the new

Mysql to convert NULL data (mandatory), mysqlnull Use mysql to query the database.Left joinSome associated fields areNULLTherefore, after obtaining the record set, you need to convert NULL data. This article provides a way to directly execute the