MySQL

MyISAM and InnoDB explanationInnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application. The basic difference is that the MyISAM type does not support

What does a business mean?A transaction can be thought of as a business logic processing unit that is either executed or not executed.Second, the principle of acid(1), atomicity (automicity)(2), consistency (consistency)(3), Isolation (isolation)(4),

Today to modify the Ubuntu under the MySQL 5.7 Data directory, found no matter how to toss files/etc/mysql/my.cnfAfter the restart is not valid, in the online view of the relevant documents, said to modify the AppArmor file, to organize the document,

1. Import the databaseUsing the Source commandFirst, connect the database in the cmd window, and then use the Source command to import the operationMySQL> use database name MySQL>source D:/Dbname.sql2. Export the databaseNote When you export a

1. You need to install MYSQL.DATA.ENTITY.EF6, this DLL can search for MySql.Data.Entity.EF6 and install it online in the project-Manage NuGet Package2. The connection string needs to be added providername= "Mysql.Data.MySqlClient"3.

1. Backup with mysqldump commandThe 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 first

1. Call the MySQL formatted decimal function format (x,d)For example:[HTML]View PlainCopy Select Format (23456.789,2); [HTML]View PlainCopy Select Formate (salary,2); Output:[HTML]View PlainCopy

BEGINDeclareLevint;--Query Parent SetLev=1; Drop Table if existsTMP1; CREATE TABLETMP1 (IDVARCHAR( +), Wl_codevarchar( -), Parentcodevarchar( +), LEVVINT); --Splicing table names and parameters in a stitched manner SET @sqlcmd =CONCAT ('INSERT

Implementation method:1. Set the field type to TIMESTAMP2. Set the default value to current_timestampExamples of applications:1. MySQL Script Implementation use case-- add Createtime Set default time current_timestampALTER TABLE ' table_name 'ADD

Since the launch of the blog Park has been no time to update, recently always busy with some project problems, finally came to an end, need to tidy up.This project is a migration from Oracle to MySQL platform, a master three from, do read and write

1. Server-level lock waitsThe thread ID of the wait lock can be seen through show processlist, but there is no way to know exactly which thread holds the lockCan be mysqladmin by debugThe associated thread waiting for the lock and who holds the lock

PHP//header ("content-type:text/html; Charset=utf8 ");//header (" Content-type:text/html;charset=utf-8 "); $end=Array();$id=$_post[' ID '];$name=$_post[' Name '];$age=$_post[' Age '];$sex=$_post[' Sex '];$end[' Name ']=$name;$mysql _server_name= ' 12

Source installation MySQLYum Install Ncurses-devel Libaio-devel-ymkdir/server/tools-pcd/server/toolswget https://cmake.org/files/v2.8/ Cmake-2.8.8.tar.gztar XF cmake-2.8.8.tar.gzcd cmake-2.8.8./configuregmake gmake Installwhich cmake/usr/local/bin/

Environment preparation Mysql:https://dev.mysql.com/get/downloads/mysql-5.7/mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz Linux system version: CentOS 7 Installation

MySQL Production library Big Table DeleteThe general line of business growth faster, resulting in some expression to the critical value of the table, the number of table rows more than 2000w and query frequently, such as the table business does not

Knowledge Key words: Date_format Select Date_format (create_time,'%y%u ') weeks,count (Caseid) count from tc_case Group by Weeks; Select Date_format (create_time,'%y%m%d ') days,count (Caseid) count from tc_case group by  Days Select

MySQL in Myisam,innodb by default is the Btree index, as to how the data structure of btree is not important,Only need to know the result, since is the index that this data structure finally is orderly, like Xinhua dictionary His directory is

1. Download MySQLVisit MySQL's official website http://www.mysql.com/downloads/then you will see a "download" click under "MySQL Community Server" on the page.Go to MySQL Download interface (http://www.mysql.com/downloads/mysql/), if you are using

one).Ubuntu under MySQL installation layout:/usr/bin client program and mysql_install_db/var/lib/mysql Database and log files/var/run/mysqld Server/etc/mysql configuration file My.cnf/usr/share/mysql character set, benchmark program, and error

Forwarding Original address: http://www.cnblogs.com/hanzhao1987/p/6100096.htmlMySQL Benefits:Easy to use, low cost, easy to expand, replication leadingThe life cycle of MySQL:MySQL server listener 3306 port > Authenticate Access user > create MySQL