MySQL

This article mainly introduces the mysql stored procedures and functions in detail, the content is very detailed, the need for friends can refer to the followingStored procedures and functions are collections of SQL statements that are defined in

I. Aspects of database optimization inclusionDatabase optimization is a kind of comprehensive technology. There is not a way to improve the efficiency of the database very much. But through a variety of improvements. This makes the database

First you need to download MySQL Community server:https://dev.mysql.com/downloads/mysql/Go to MySQL Download interface (https://dev.mysql.com/downloads/mysql/), if you are using Mac OS to access, then it will be the default for you to choose

To master the necessary conditions to meet the singleton pattern----three private and one public.① private constructor-to prevent the instantiation of an object with the new keyword outside of the class.② Private member Property-to prevent the

0x00 backgroundThese two days in the horn point of the state, very bad. But the question mentioned in the last article is finally a summary of something.Portal: Question Point 0x02 (4)0X01 Test Process(1) test environment: created the following test

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

For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting system, the time spent on data import every day can be as long as a few hours or more than 1

I've written an article before Python uses the MySQL Database blog, mainly using the Python2 and mysqldb drivers. Python uses MySQL databaseHowever,at the beginning of the year, I switched from Python2 to Python3,Python2 Already basically no longer

Today to see how Zabbix monitor MySQL performance, this way using MySQL comes with the template, you can monitor the following: OPS (increased deletion check), MySQL request traffic bandwidth, MySQL response traffic bandwidth, the final will be

1, Field: General and column (synonymous), often used interchangeably, but the database column is generally referred to as a column, the field is usually used in the connection of the calculated field.2, splicing: The values are concatenated

GROUP BY relatedThe "only_full_group_by" Sql_mode is turned on by default and only gets the fields affected by the group by when turned on, and the information for non-group by needs to be obtained through the Any_value (name) function (after MySQL 5

Set the MySQL service to allow extranet access, modify the MySQL configuration file, some my.ini, some my.cnf "Linux".Find the MySQL configuration file path for Zen Trails:/opt/zbox/etc/mysql1: Setting up the MySQL configuration

First we create a comma-delimited string.CREATE TABLE Test (id int (6) NOT NULL auto_increment,primary KEY (ID), pname varchar (a) not null,pnum varchar (a) NOT null) ;Then insert the test data with a comma-delimitedINSERT into Test (pname,pnum)

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

Create tables, populate test dataCreate TableGEOM1 (IDint not NULLAuto_incrementPrimary Key, Geo geometry);Insert intoGEOM1 (GEO)Values(St_geomfromtext ('Point (1 1)',3857));Insert intoGEOM1 (GEO)Values(St_geomfromtext ('Polygon ((0 0,10 0,10 10,0

Today found that the site is slow to visit, once a troubleshooting, start thinking confusion, below to comb underFirst, Fault AnalysisFirst of all, to judge the slow phenomenon of access, is individual or collective ???Personal phenomena : Check

Use inner join in MySQL to implement intersect and set operationFirst, business backgroundWe have a table design such as the following:CREATE TABLE ' user_defined_value ' ( ' resource_id ' varchar) default NULL, ' column_name ' varchar (default)

Change the password to update mysql. user set authentication_string= password 123456 ( ‘123456‘ ) where user = ‘root‘ andHost = ‘localhost‘;Change Password to update mysql. user set authentication_string= empty password ( ‘‘ )  where user = ‘root‘

Log in Administrator right after enter sudo suEnter the following command to disable the MySQL authentication feature after entering the carriage return./mysqld_safe--skip-grant-tables &MySQL will restart automatically after carriage return (the

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