MySQL

> MARIADB InstallationYum Install Mariadb-server> Create related directories, and set permissionsMKDIR/MYSQLDB; Mkdir/mysqldb/{3306,3307,3308}/{etc,socket,pid,log,data}-PVChown-r Mysql:mysql/mysqldb#目录结构如下/mysqldb├──3306│├──data│├──etc│├──log│├──pid│

Add when building a tableDROP TABLE IF EXISTS' student ';CREATE TABLE' student ' (' stu_id ' )int( One) not NULLauto_increment, ' name 'varchar(255)DEFAULT NULL, PRIMARY KEY(' stu_id '),UNIQUE KEY' Uk_student_name ' (' name ')) ENGINE=InnoDB

= { ‘default‘: { ‘ENGINE‘‘django.db.backends.mysql‘, # 数据库引擎 ‘NAME‘‘mydata‘, # 你要存储数据的库名，事先要创建之 ‘USER‘‘root‘, # 数据库用户名 ‘PASSWORD‘‘0000‘, # 密码 ‘HOST‘‘localhost‘, # 主机 ‘PORT‘‘3306‘,

SELECT Case3 when1Then' One' when2Then' Both'ELSE' More'END; SELECT Case1>0Then'true'ELSE'false'END as' One', case0>0Then'true'ELSE'false'END as' Both'; SELECT Case BINARY'BB' when'a'Then1 when'BB'Then2END; SELECT Case'B' when'a'Then1

Self-correlating query (self ID associated with its own ID (primary key), the query can be logically divided into two tables, and then a separate alias to distinguish)SELECT * FROM areas as CityInner join areas as provinces on

Original: http://bbs.landingbj.com/t-0-246222-1.html http://bbs.landingbj.com/t-0-245851-1.htmlOptimization of the MyISAM storage engine in MySQL performance tuning.The points to consider in optimizing the MyISAM storage engine are as follows:As far

1. BusinessIt is a sequence of actions that are either executed or not executed. It is an inseparable unit of work.2. ACIDTransactions have four characteristics: atomicity, consistency, isolation, persistence.Atomic NatureA transaction is an

As the following table structure:CREATE TABLE' trade_order ' (' order_id ' )bigint( -) unsigned not NULLAuto_increment COMMENT'Order Number', ' Total_price 'bigint( -)DEFAULT NULLCOMMENT'Order Total Price', ' Item_name 'varchar( -)DEFAULT

With the accumulation of data, slowly some of our bad habits will be exposed in the system, the efficiency of the program execution is low, the user experience is reduced, if we do not take some measures, then users will be lost.Improving the

$sql = "Select P.*,q.md from Xz_laptop as P inner join xz_laptop_pic as Q in p.lid=q.lid title like '%10% ' GROUP by lid limi T 0,8 ";This query statement synthesizes the cross-table query, involving foreign keys, fuzzy queries, pagingmeans

In a general query, it is required to do as much as possible around the created index. For indexes, there are primary key indexes, single-column indexes, combined indexes, index merging and so on.When evaluating an index, it is critical to see the

First, Reason:One day to see the master-slave replication delay alarm a bit frequently, thinking is not completely can be solved.General master-slave replication, with three threads involved, is single threaded: Binlog Dump (Master)----->io thread

1.MySQL need to redeploy, delete which two files and what commands to executeDelete Arch and data directories2.MySQL Create a DB, create a user to this DB has all permissions, password 123456, only allow 198.168.137.110 machine to access the

MySQL database modify character set, introduce the method of modification1) System Tools Iconv#file filename#mysqldump--default-character-set=utf8 >20180523xxx.sql#file 20180523xxx.sql#iconv-t utf8mb4-c 20180523xxx.sql>20180523xxxutf8mb4.sql#file 20

Get MirrorDocker pull MySQLTo start the container:Docker run-p 3306:3306--name pf-mysql-v/usr/pf/docker/volumn/mysql_conf/my.cnf:/etc/mysql/my.cnf-v/USR/PF /docker/volumn/logs/mysql:/logs-v/usr/pf/docker/volumn/db/mysql:/mysql_data-e

MySQL5.5The steps are as follows:1. Set Global Innodb_fast_shutdown = 0;2. Mysqladmin shutdown3. Modify MY.CNF innodb_log_file_size to specify SIZE4.MV ib_logfile*/bak (no removal, start error) 5.mysqld_safe--DEFAULTS-FILE=/ETC/MY.CNF-- User=mysql

Lamp Architecture IntroductionLAMP是Linux apache MySQL php的简写，即可吧apache MySQL和PHP安装在Linux系统上，组成一个坏境来运行PHP的脚本语言，通常是网站。Linux是操作系统apache提供web的一个软件MySQL 存储的一个软件，数据库PHP 脚本语言 三个角色可以在一台机器，也可以分开。不过 MySQL和PHP要在一起。 For example, if you point a picture

When we use MySQL, we often need to change the root user password for different reasons, this blog mainly describes several ways to modify the root user password. Before the root password is set: How to SET the password command:mysql -u

First, meaningA SELECT statement nested inside another statement is called a subquery or an inner query, and the outer statement can be INSERT, UPDATE, delete, select, and so on, the general select as the outer statement is more, outside if is a

First, the application scenarioWhen the number of entries to be queried is too many, one page is not fully displayedSecond, the grammarSelect query list from table limit "offset," size;2.1. Note:Ffset represents the starting entry index, which