MySQL

Toss for one hours, finally put the module connected to MySQL installed, Because my environment is PYTHON3.5,MYSQL official support to python3.4, the back Google to have pymysql die fast support python3.5, this module is written in Python, not much

Chapter IIIn all the statements that relate to database, the schema keyword and the database synonym1. Query the current reply, and the sql_mode of the global replySelect @ @session. Sql_mode;SELECT @ @global. sql_mode;Set sql_mode = ' traditional

' Is the escape character of MySQL and avoids the conflict with MySQL's own keyword, so long as you don't use MySQL's reserved word or Chinese in Column name, table name, you don't need to escape.All databases have similar settings, but MySQL uses '

1. Create a table: Primary Key ID User name Gender Weight (kg) Birthday Wages Last Login time Personal profile --Terminology: The

Library Management1. Create a databasemysql> help CREATE database; CREATE {DATABASE | SCHEMA} [IF not EXISTS] db_name [create_specification] ... create_specification: [DEFAULT] CHARACTER SET [=] charset_ name | [DEFAULT] COLLATE [=] Collation_name650

To back up the MySQL database script:#!/bin/bash# description:mysql buckup shell script# author:lmj# Web Site:http://www.cnblogs.com/dscode St=$(Date+%s) USER="Root"# User name password="Root"# Password Database="Myblogdb"# Database Mail="[email

1005: Failed to create table1006: Failed to create database1007: Database already exists, database creation failed1008: Database does not exist, delete database failed1009: Unable to delete database file causes database failure to be deleted1010:

Today, the data is submitted to PHP through the form and then inserted into the database. Web page and PHP encoding format are utf-8, when inserted into the database is also set $this->query ("Set names UTF8;");However, there is a case of reading

Dual master replication:1), on the two servers to establish a user with replication permissions;2), modify the configuration file:# on master Server A[Mysqld]Server-id = 10Log-bin = Mysql-binRelay-log = Relay-mysqlAuto-increment-offset = 1 # Start

Query operation for MySQLSingle-table query: Simple queryMulti-table query: Connection queryFederated queriesBoolean conditional expression operator= equivalent comparison : Comparison with null value does not produce the equivalent of additional

DDL (data definition issues)Data definition Language-LanguageObjects used to define a database, such as data tables, views, indexes, etc.DML (data manipulation issues)Data processing language-data manipulation LanguageUpdate, add, and delete records

Basic concepts:A character (Character) is the smallest of the ideographic symbols in a human language. such as ' A ', ' B ' and so on;Encoding (Encoding) is given a series of characters, assigning a numeric value to each character, and representing

In the daily development or maintenance of the large table is often encountered, so-called large table refers to the storage of millions and even tens records of the table. Such tables are too large to cause the database to take too long to query

First, joint inquiryIn both cases it may be used: 1, the desired result in a statement will cause a logical conflict, can only be placed in two statements is to use the Union query2, a table of data volume is very large, will be separated into

Add MySQL from libraryMySQL Master slave replication server 1 master 1 from, now to add a MySQL from the server, require the main library cannot stop the service, previously due to not the server on the line, you can execute the flush tables with

Database backup is becoming more and more important today because of the high speed development of modern computers, programmers tend to neglect backup data because they don't pay attention to it, which leads to the loss of data, which results in

(-1) write in frontThe data of this essay is used in Http://blog.csdn.net/friendan/article/details/8072668#comments , and there are some common Select query exercises. I'm using it. MySQL the command line that comes with it(1) Data MatchingStudent

Install MySQLYum-y Install Mysql-server Modify MySQL ConfigurationVI/ETC/MY.CNF There will be a lot of configuration items to be aware of, followed by special notesTemporarily modify the code (added below the password): Default-character-set

To solve the 1862 (phpmyadmin)/1820 (mySQL) Error in mysql, 1862 phpmyadmin Problems Found I have been running well before, And suddenly mysql cannot work. An error is reported after the request command:ERROR 1820 (HY000): You must set password

Mysql 5.6.24 installation instance tutorial, mysql5.6.24 Preparations before installation: 1) edit the PATH vim /etc/profilePATH=/home/mysql/bin:/home/mysql/lib:$PATHexport PATH 2) Effective PATH source /etc/profile 3) EDIT hosts vim /etc/hosts192.16