First say the problem encountered: There is a MySQL instance ran two libraries, two sets of programs. One of the library's table names is all uppercase, and the other library's table names are all lowercase.The program with the table named lowercase
Outside of MySQL key constraintThere are two common engine types for MySQL: MyISAM and InnoDB. Currently only the InnoDB engine type supports foreign key constraints. The syntax for INNODB FOREIGN KEY constraint definitions is as follows:[CONSTRAINT
With a friend, a good company supervisor. When communicating with the index in MySQL in conditional query and sortMysql> Explain select * from article where title= ' Hope PV Enterprise survived 2 months ' ORder by ID desc\\\\\\\\g1. Row *************
First, view the log app statusmysql> show processlist;+----+------+---------------+-------+-------------+------+--------------- --------------------------------------------------------+------------------+-----------+---------------+|
Database master-slave replication principle:The master-slave replication of the database is copied from the master database to the slave database, and the entire replication between master and slave takes three threads, two of which are on the slave
If you want your website or App to support Emoji, there are some details you need to know when setting up MySQL for the first time. EmojiThe special point of the Emoji character is that it takes 4 bytes to store it. This collate of the UTF8
1 Viewing the default and supported storage enginesMysql->show engines;2 View MySQL's current default storage engineMysql->show variables like '%storage_engine% ';3 Viewing the storage engine for the test Database buyer tableMysql->show table status
Today I would like to compare a variety of performance optimization strategies that can be used on a greenfield project . In other words, the project has not been optimized for the constraints imposed on it by previous decisions.Specifically, the
Use MySQL;Grant USAGE on *. user_name ' @ ' localhost ' identified by ' 123456 ' with Grant option;//authorized user_name user to access the database with password 123456Grant Select,insert,update,delete on db_name.* to ' user_name ' @ ' localhost '
Get ready:To say that truncate table is going to have to talk about the delete all two of them can be used to delete data rows from the table! On the face of it, delete deleted slowly, TRUNCATE TABLEFaster,Delete:It is an honest line of deleted data,
Environment: MySQL 5.6.21 64-bit CentOS 6.5 64-bit VMware 10Navicat for MySQL 11vs20131. First build the CentOS MySQL development environment:Tutorial Connection: http://my.oschina.net/u/258745/blog/3231032. Turn off the CentOS firewallShutdown
1. TargetLearn how to create a stored procedure2. SyntaxCREATE PROCEDURE Sp_name ([proc_parameter])[characteristics...] Routine_body3. Description
CREATE PROCEDURE is the keyword to use for creating stored procedures;
Sp_name
The author of the website has been in the database from the virtual space to a separate server, just installed above the database code with my original, the original is latin1, the current is the GBK format, due to different coding, sometimes the
MySQL is a simple basic operation guide (1)
System: Ubuntu 14.04 LTS
Installation:
Apt-get install mysql // install the database apt-get install mysql-workbench // install the graphical interfaceUsage:
At startup: mysql-h [address]-p [port]-u
Simple MySQL database master-slave synchronization configuration, mysql database master-slave
Master Configuration:
The Code is as follows:Log-bin = mysql-binServer-id = 1Binlog-do-db = powerdns # database to be synchronized
Add an slave account to
Mysql Command for viewing table structure and table Creation
1, desc tablename;
mysql> desc authors;+-------+--------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-------------
MySQL character encoding problem, IncorrectstringvalueAn error is reported when inserting Chinese Characters in MySQL. For details, refer to the analysis below.Incorrect string value: '\ xD0 \ xC2 \ xC8A \ xbew' for column 'ctnr' at row 1MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service