MySQL

Turn from: (translate) friends with MySQL please do not use "UTF8", please use "UTF8MB4"Friends with MySQL Please do not use "UTF8", please use "UTF8MB4"Today I'm trying to insert a UTF-8 encoded string into a MARIADB database that uses "UTF8"

1. CodeSELECT a.id, A.activity_name, ( case when A.activity_end_time>Now () Then' Participation 'ELSE (A.activity_doubt<> ' * 'and A.activity_doubtc.doubt) OR (a.activity_praise<> ' * 'and a.activity_praise> c.praise * 100) Then' Not compliant 'ELSE'

First-level caching:Also known as local cache, sqlsession level cache. The first-level cache is always on, and the data queried during the same session with the database is placed in the local cache.If you need to get the same data, take it directly

The realization of MySQL dual-machine hot standbyOriginal: http://www.zjian.me/web/php/mysql%E5%8F%8C%E6%9C%BA%E7%83%AD%E5%A4%87%E7%9A%84%E5%AE%9E%E7%8E%B0/The MySQL database does not have a mechanism for incremental backups, which is a big problem

Simple additions and deletions via JDBC (take MySQL for example)DirectoryPreface: What is JDBCI. Preparatory work (i): MySQL installation configuration and basic LearningIi. preparatory Work (ii): Download the jar package for the database and import

PrefaceToday go to fitness, feel the body practice good or good, gossip not to say, the data types encountered in this database today all here to speak clearly, after seeing what data type, I should know, for me, the most unfamiliar should be the

Possible causes and solutions1. may be/usr/local/mysql/data/rekfan.pid file does not have permission to writeWorkaround: Give permission, executechown -R mysql:mysql/var/datachmod755 /usr/local/mysql/dataThen restart mysqld!2. The MySQL process may

First, IntroductionWhat is lampLamp is a Web network application and development environment, is the abbreviation of Linux, Apache, MySQL, Php/perl, each letter represents a component, each component in itself is a very powerful component in the

In MySQL, if you want to see the definition of a table, you have the following options1. Show CREATE TABLE statement:Show CREATE TABLE table_name;2. DESC TABLE_NAME Statement:CREATE TABLE person ( ID int. NOT NULL auto_increment primary key,

Preparation (two sheet t1,t2):Table T1:Mysql> select * from T1;+-------+---------+| t1_id | T1_name |+-------+---------+| 1 | T1_1 || 2 | t1_2 |+-------+---------+2 rows in Set (0.02 sec)Table T2:Mysql> select * from T2;+-------+---------+| t2_id |

MySQL Plus Lock Processing analysis Original: http://hedengcheng.com/?p=7711 background 11.1 Mvcc:snapshot Read vs current Read 21.2 Cluster Index: Clustered Indexes 31.3 2pl:two-phase Locking 31.4 Isolation Level 42 A simple SQL Lock implementation

Often site administrators for various reasons and operations, resulting in site data mistakenly deleted, but also did not do site backup, the results are overwhelmed, and even to the site operation and profit negatively. So this article we will

Development said that a test environment of MySQL, unable to restart, reported the following error message:# service mysqld restartshutting down MySQL. success! Starting MySQL. error! The server quit without updating PID file

I. Install MySQL database under CentOS7CentOS7 The default installation package does not already have a Mysql-server installation package, and there is no remote mirror. The default is MARIADB (a branch of MySQL, one of the reasons for developing

First, what is the storage engine?Tables created in MySQL = = FolderTables created in the Library = = "FileIn real life, the files we use to store data should have different types: for example, TXT type for storing text, Excel for storing tables,

Aliyun Host Environment: cpu:1c mem:2g Os:centos 6.81. Install the Percona package source Yum Install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm 650) this.width=650; "Src=

# my Ubuntu comes with python3.5, so install python3.6sudo add-apt-repository ppa:jonathonf/python-3.6sudo apt-get updatesudo apt-get install python3.6sudo update-alternatives--install/usr/bin/python3 python3/usr/bin/python3.5 1sudo

Transferred from: http://blog.sina.com.cn/s/blog_605f5b4f01013xkv.htmlMySQL uses Init-connect+binlog to implement user operation tracking log record of Access IPin MySQL, each connection executes the Init-connect first, and the connection is

How to use:CONCAT (STR1,STR2,...)Returns the string that results from the connection parameter. If any one of the arguments is NULL, the return value is null.Attention:If all parameters are non-binary strings, the result is a non-binary string.If

Premise:1. The Hosts file has been configured and password-free login2. The required Yaml file has been uploaded to the main control sideFirst, using Ansible installation Nginx1. nginx.yaml file1 ---2 -Hosts:clong3 Remote_user:root4 Gather_facts:no5