MySQL

MySQL Learning notes- custom Functions1. Introduction to Custom FunctionsCustom functions: User-defined Functions (user-defined function,udf) are a way to extend MySQL, using the same functionality as built-in functionstwo prerequisites for a custom

MySQL function library, this library is an external function library! This function provides common functions for working with MySQL databases, such as connecting to a MySQL server, opening a database, executing SQL statements, and so on. So the

First, installation1. IntroductionXtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and XTRADB databases.

master server Master[[email protected] ~]# vim /etc/my.cnf[mysqld]log-bin=mysql-bin #必须开启log-binserver-id=129 #服务器IDfrom server slave[[email protected] ~]# vim /etc/my.cnf[mysqld]log-bin=mysql-bin #开启log-bin（可选）server-id=129 #服务器ID[root@localhost ~]#

If you have entered this post, then you must have encountered the same problem as me. Do not look at the set case of the topic when ..., I started with the first reaction is to use case when but found not to work.It's a little bit bigger than that:

ObjectiveRecently in the case of some loopholes box background project Summary, in the box multi-phase project, found that the injection class of loopholes accounted for relatively large. The order by injection type of vulnerability also accounted

CENTOS7 installation Lnmp (linux+nginx+mysql+php) and ApacheNginx is a very lightweight HTTP server written by the Russians, Nginx is a high-performance HTTP and reverse proxy server, Nginx beyond the performance and stability of Apache, so that the

Monitor MySQL with Zabbix ODBC monitoring1. Create a group ODBC Templates650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none;

0x01 backgroundThe day before yesterday in a CTF topic, a blind question, in fact, blinds may also be able to echo the data, such as using DNS or HTTP logs to obtain data quickly, MySQL can use the Load_file () function to read data, and send data

First, create the database:CREATE DATABASE database_name;Two ways to create a database in PHP: (mysql_create_db (), mysql_query ())$conn = mysql_connect ("localhost", "username", "password") orDie ("Could not connect to localhost");1.mysql_create_db

Contact MySQL for more than a year, but is always an occasional use of the State, on its principle of things research is not enough, in a lot of MySQL related summer vacation mentioned MySQL architecture, very clear analysis of the MySQL module

Take a look at the results of the left join and the right join with the Inner join and the full join to manipulate the table. Create a new two table in the database and insert the data you want to test. New table:[SQL]View PlainCopy

What is a transactional transaction is a rigorous set of operations in an application, and all operations must be completed successfully, otherwise all changes made in each operation will be undone. That is, transactions are atomic, and a series of

Import and export data using into outfile and load data infileThe advantage of this method is that the exported data can be self-defined format, and the export is pure data, there is no table information, you can directly import another database

This chapter mainly configures the heartbeat v2 based on the Crm+hb_gui interface and configures the highly available Httpd,mysql,lvs.650) this.width=650; "src=" Http://www.heartbeat.com/wp-content/uploads/2016/05/heartbeat-logo-300x300.png "alt="

When the amount of database data rises to a certain amount, performance becomes the problem that we can't help but how to optimize? There are a few common ways:1, sub-table, that is, a large expression of data into several tables, so that each table

First, MySQLMySQL is a relational database management system developed by the Swedish MySQL AB company and is currently part of Oracle's product portfolio.　　MySQL is one of the most popular relational database management systems, and MySQL is the

Service MySQL start error, MySQL can not boot, resolve mysql:unrecognized Service error method is as follows:[[Email protected] ~]# service MySQL startMysql:unrecognized Service[[Email protected] ~]# service MySQL restartMysql:unrecognized

1. Installation of Nginx Yum1) Add Nginx to Yum sourceAdd the CentOS 7 Nginx Yum Repository, open the terminal and use the following command:sudo rpm-uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm2)

Install mysql 5.7.13 and mysql 5.7.13 in VMWare linux 1. Basic Environment Description Virtual Machine: VMWare Operating System: linux Database Version: mysql 5.7.13 community edition (do not ask why the Enterprise Edition is not installed because