MySQL

The following is just a simple example We first prepare the MySQL datasheet, assuming that the project has a record of student information on the table student, and have id,name,sex,age record the student's name, gender, age and other information.

MySQL database received a network connection, first get the IP address of the other side, and then the IP address for the reverse DNS resolution to get this IP address corresponding host name. Use the host name in the permission system to determine

For operations on string positions, the first position is marked as 1. ASCII (str) Returns the ASCII code value of the leftmost character of the string str. If Str is an empty string, returns 0. If STR is NULL, returns NULL. Mysql> Select ASCII (' 2

In the reconstruction of the site, the data structure is usually modified, so add, delete, add the MySQL table field is unavoidable, and sometimes for convenience, but also increase the modification of the table or field comments, the same field

1. mysql Installation:EC2 installing MySQL directly with Yum is easy:Yum install MySQL mysql-server mysql-libsThere are three packages installed hereCan be used directly after the finishedService mysqld StartStart the MySQL serviceChange root

Environment: mac10.12Source: http://www.cnblogs.com/kerrycode/p/3861719.htmlError 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password:no) errors encountered using root login. As shown below[[email protected] tmp]

If you ' re just completely itching to start using the This tool, here's what you need:1, a MySQL database to store query analysis data in.2, Pt-query-digest. You could as well just get the whole Percona Toolkit when you ' re at it:)3, a slow query

Today to join a new from the library, to synchronize the master data, but the MY.CNF configuration file directly copied, did not modify the Server-id, resulting in an error:2017-04-01 14:57:16 140661325472512 [note] slave: received end packet 

Online Linux installation MySQL service is divided into two installation methods:① source installation, the advantage is that the installation package is relatively small, only about dozens of M, the disadvantage is that the installation depends on

Rotor http://www.linuxidc.com/Linux/2015-06/119354.htmDirectoryPreparatory workOperating EnvironmentConfirm your version of the installationDownload MySQLInstall MySQLPreparing the installation EnvironmentCompiling and installingConfigure

Original http://www.cnblogs.com/xuejie/archive/2013/01/11/2856911.html We will certainly encounter the backup database in the course of running the project, restore the database situation, we generally use two ways to deal with: 1. Import and export

MySQL is divided into development version and stable version (GA), the development version has the latest features, but not stable, nor completely tested, there may be serious bugs, and stable version is a long time testing, eliminate the known bugs,

MySQL study--linux installation MySQL Workbench toolSystem environment:Operating system: RedHat EL6.4 (64)workbench:mysql-workbench-community-6.0.9MySQL Workbench is a er/database modeling tool designed for MySQL. It is a successor to the famous

Grant MySQL account access to specified database under Linux systemRequirements: 1, create a database in MySQL mydata2, new MySQL account admin password 1234563, give the account admin to the database MyData have full operation rights ===============

Task: Further explore mysqli_multi_query () usage.   1. Connect to MySQL: $ DBC = mysqli_connect (host, user, password, databasename ); It is equivalent: $ DBC = mysqli_connect (host, user, PWD); mysqli_select_db ($ DBC, db_name );   If an error

Mysql database performance optimization 1. mysql Performance Optimization Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance,

MySQL log-slow query log (slow-query-log)Slow query log: All SQL statements that run longer than long_query_time in MySQL slow query log records help you find slow SQL statements, so that we can optimize these SQL statements. Slow query log

Mysql master-slave replication principle and Configuration1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a Mysql host to

MySQL 1042 Can't get hostname for your address Problem Analysis Solution Process [Comment 1] former colleague penguin said he installed mysql 5.5, found that when using the mysql client remote connection, the error 1042-Can't get hostname for your

Mysql tutorial alter name table name structure add Column Alter table statementThe alter table statement is used to add, modify, or delete columns in an existing table. SQL alter table syntaxTo add columns to a table, use the following syntax: Alter