MySQL

A vertical table to the horizontal table1. Create a vertical table firstCREATE TABLE Student (ID varchar (+) primary key,Name varchar (NOT NULL),Subject varchar () NOT NULL,result int);2. Inserting dataINSERT into student (ID, name, subject, result)

Ext.: http://blog.sina.com.cn/s/blog_1512521570102wrfl.htmlSelect Cost,@a:[email protected]+1 from Testone, (select @a:=0) as A;The variables in MySQL do not have to be declared beforehand, use "@ variable name" when using it.First usage: Set @num =

Summary of the differences between collation Utf8_unicode_ci and Utf8_general_ci in MySQLAfter such a long time, found that they do not know Utf_bin and utf_general_ci the difference between the two exactly.CI is case insensitive, that is, "casing

Reference official website: https://dev.mysql.com/doc/refman/5.7/en/replication-implementation-details.htmlThe MySQL replication feature is implemented through three threads, including the Lord's Binlog dump tread and the SQL thread from the top,

Problem background Description: Execute SQL statements in MySQL, such as insert, thief slow, obviously may be just a row of data inserted, the amount of data is very small, but the time spent is many, why?First, storage structure analysisMySQL

Set MySQL passwordSET PASSWORD = PASSWORD (' [email protected] ');Setting up a MySQL remote connectionGRANT all privileges on * * to ' root ' @ ' 192.168.4.0 ' identified by ' [email protected] ' with GRANT OPTION;Forgot MySQL PasswordUPDATE

First, B-treeB-tree is the most common type of index, and all values (columns indexed) are ordered, with each leaf node being equal to the distance from the node. So B-tree is suitable for finding data in a range and can directly support data

1. Login SQLyog password is inconsistent with MySQL settings.2. Last installed MySQL did not uninstall clean, (Troubleshooting Delete: Search c disk Delete related files, search registry Delete relevant items, into the DOS interface Delete Service

A little security policy after MySQL installation is to remove empty users and host users who are not localhost1. Delete Empty usersRemove Empty usersMysql> Select Mysql.user,host,password from user whereuser= "; Query usersmysql> Delete from user

MySQL is a relational database management system developed by the Swedish Mysqlab Company and currently belongs to Oracle products. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBMS

1. Start MySQL:brew services start MySQL2. Login to MySQL: mysql-u root-pMySQL command. -U followed by user nameRoot Super Administrator, with the highest privileges.-P followed by password3. Exit MySQL:Brew services stop MySQL4. Open MySQL:brew

IntroducedSometimes we need to copy the table structure of a table intact to generate a new table, and MySQL provides two convenient methods.Cases:CREATE TABLE tb_base (id INT not NULL PRIMARY key,name VARCHAR (Ten), KEY ix_name (name)) engine= '

Download Linux generic version tar.gz file, such as: mysql-5.7.18-linux-glibc2.5-x86_64.tar.gzUnzip to the target directory, such as:/test/mysql-5.7.18-linux-glibc2.5-x86_64Mkdir/test/mysql-5.7.18-linux-glibc2.5-x86_64/dataCd/test/mysql-5.7.18-linux-

Installing MARIADB Yum Install-y mariadb*2. Start MARIADBSystemctl Start mariadb3. Modify the MARIADB root passwordMysqladmin-u root-p Password 1234564. Modify the master configurationVi/etc/my.cnf.d/server.cnf[Mysqld]Log-bin=mysql-binserver-id=

First, delete the original MySQL1. Execution of commands1 Yum remove mysql mysql-server mysql-libs mysql-server;2. Find the relevant file delete1 Find/-name MySQLDelete Folder command1 rm-rf/user ...3. Check if there is any MySQL software, if

MySQL Multi-instance:is to open a different service port (for example: 3306,3307) on a single machine and run multipleMySQL service process, these service processes through different sockets to listen to different service ports toTo provide their

1: Under the terminal: Mysql-v. Here is the code snippet:[[email protected] ~]$ mysql-14.74.1 for Redhat-linux-gnu (i686)2::mysql> status in MySQL;Here is the code snippet:　Mysql>status; --------------MySQL Ver14.7Distrib4.1.10a, forredhat-linux-GNU

VMware virtual machine installed, and then installed a CentOS7 system, the above environment self-Baidu ...One, Linux under check whether MySQL installed1. Instruction Ps-ef|grep MySQL[[Email protected] Desktop]# ps-ef|grep mysqlmysql2688 1 0 -: to?

Common mysql optimization methods and common mysql Optimization Methods 1. select an appropriate field attribute. For exampleDefine zip codeWhen this field is set to CHAR (255), it obviously adds unnecessary space to the database, and even uses the

MySQL manual, mysql5.6 Chinese manualMySQL configuration file The configuration file used by MySQL is my. ini, which is in the installation directory. MySQL common configuration parameters: 1. default-character-set: default character set of the