MySQL

Website Original: https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.htmlNote: The following is my reference to the official website documents and the combination of their own understanding written, because the English level is

Not much nonsense to say, directly on the operation of the diagram, the operation will be more thorough understanding.1, MyEclipse in the project structure, the first web-inf-lib under the import jar package, note that the Web APP libraries This

I. OverviewOn the principle of mycat on the web there are many, here no longer detailed, for me, mycat the main functions are as follows:1.Mysql master-Slave read/write separation2.Mysql Large Table Shard3. Read-write separation and sharding of

mysqladmin Kill all/specify MySQL connection1. Batch kill all MySQL connectionsMysqladmin-uroot-pxxx processlist |awk-f ' | ' ' {print $} ' |xargs-n 1 mysqldamin-uroot-pxxx Kill2. Kill the specified MySQL connection in bulkMysqladmin-uroot-pxxx

Type-relatedInt (1) and int (20) have the same meaning for storage and computation, and he does not limit the legal scope of a value, but some interactive tools are used to display the number of charactersThe default is signed, can be specified as

1. Data Warehouse. As with the plain text that we have learned before, properties,xml these techniques. Used to save data. and provide the operation of the data to be added and censored. When we do the project later,The data in the project is saved

1. ApacheThe default port number is 80Test: Enter http://localhost in the address bar to display the results: it worksConfiguration folder: Conf folderConfiguration file: conf/httpd.confDefault virtual directory: Htdocs2. PhpConfiguration file:

http://repo.mysql.com/yum/1. Newly opened cloud server, need to detect whether the system comes with the installation of MySQL# Yum List Installed | grep MySQL2. If you find a system that comes with MySQL, do it decisively# yum-y Remove mysql-libs.x8

MySQL uses the where command to qualify data query criteria.Syntax: SELECT Property 1, Property 2 from table name WHERE condition 1 OR Condition 2 and Condition 3Description: Where the same applies to update, delete and other commands;Using or, and

1.1 Database Introduction1. What is a database?1. A database is a warehouse that organizes, stores, and manages data in accordance with its structure, each with one or more differentAPI (interface) for creating, accessing, managing, searching, and

1. Add the following code to the MySQL configuration file my.cnf:[mysqld]innodb_force_recovery=1 #可以设置1-6innodb_purge_thread=0 #如果上边的配置值大于1，此处就要设置为0，否则就会出现InnoDB: Waiting for the background threads to start的错误Parameters for the configuration file:

mysql-5.5.47 Installation1. Download the source package in advance or enter the server to upload the source package and extract it.Cd/home/rich/toolsRz-y "Mysql-5.5.47-linux2.6-x86_64.tar.gz"Tar XF mysql-5.5.47-linux2.6-x86_64.tar.gz2. Create an

Create a processcreate procedure demo(in par int)//in out inout 参数名字 参数类型 beginset @a = 123;//会话变量 对当前会话有效，全局的变量declare a int;//用普通变量要声明类型，只对一个作用域有用declare a int default 5;//直接声明并赋值set a = 123;//普通变量if a = 123 thenend if;if a = 12345

TurnNon-consolidated situationSELECTa.ID,B.nameAs "role"FromSys_user AINNER JOIN sys_user_role C on a.id=c.user_idINNER JOIN sys_role B on b.ID =c.role_idWHEREA.del_flag=0andB.del_flag=0ResultsID role1 system Administrator1 Test roles2 system

1. Installation 12345 $ sudo apt-get install mysql-server$ apt install mysql-client$ apt install libmysqlclient-dev Once installed, enter the following code to check if the installation was successful.

Import Pymysql#其他数据库, such as the Oracle module is pyoracle#1, link database mysq IP port number password account database#2, creating Cursors#3, Execute SQL#4, Get results#5, close the connection, close the cursor# 1, Show Table example1 #conn =

MySQL BASICS (1)   Mysql: Dbs Database SystemBdms Database Management SystemBda Database AdministratorDb database DBAs operate databases through dbms! Database Design During software project development cycle01. Demand analysis stage: Analyze

MySQL Study Notes 2 (Multi-Table operations) and mysql Study Notes Foreign key: Associate two tables Features: 1. The foreign key value from the table is a reference to the primary key of the master table. 2. The foreign key type of the slave table

Mysql explain (analysis index) and explain Explain shows how mysql uses indexes to process select statements and connect tables. It can help you select better indexes and write more optimized query statements. You can use the explain statement

MySQL Event scheduled task flushing slow logs, mysqleventPreface Recently, a log system graylog is used to collect mysql slow query logs for subsequent analysis, monitoring, and alarms. The log has been successfully collected to the graylog during