MySQL

The MySQL stored procedure of the Python full stack Road seriesA stored procedure is a collection of SQL statements in which the internal SQL statements are executed logically when the stored procedure is actively invoked.Stored procedure

Python full stack Road series of mySQL in-table operationsFirst create a table for testing--  Creating a database Create database dbname default charset utf8 collate utf8_ general_ci;--  CREATE TABLE create table  ' TB '   (   ' id '  int (5)

Python full stack road series MySQL TriggerLWhen you want to 增/删/改 trigger a particular behavior before and after a table, triggers are used to customize the behavior of the user 增/删/改 before and after the rows of the table. To create a

PrincipleHttp://www.tuicool.com/articles/N7fueaBulk ScriptMysql-uroot-p ' xx '-e "select User,host from Mysql.user;" >/root/user.txtsed-i ' 1d ' user.txt#sed-i ' s/[[]*/@/g ' user.txtsed-i ' s/\s\+/@/g ' User.txtcat alter.sh #!/bin/bas Hfor i in '

MySQL Community Edition: http://dev.mysql.com/downloads/mysql/Because my system version is 64, download the x64 version here. After downloading, unzip to D:\Dev\Mysql (that is, the custom unzip directory for Mysql. ）My habit is to first register the

One, the Linux kernel and the release versionUname-aCat/etc/issueSecond, the glibc version/lib/libc.so.6---Dynamic link library with no man-letter dataThird, the MySQL versionThe MySQL binary distribution version has the file name format:

User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user  zx_ Root   identified by ' xxxxx ';  //identified by will use plaintext password encryption as a hash value to store modifications

Planning:Primary MySQL server: 192.168.1.21From MySQL server: 192.168.1.22MySQL read-write splitter: 192.168.1.231. Unpack the installation package on the read-write separation server, add the corresponding user, and edit the startup script;# Tar XF

File synchronization rsync synchronization http://www.cnblogs.com/itech/archive/2009/08/10/1542945.html in the current production work, most applications MySQL master-slave synchronization is asynchronous replication mode, That is, data

One, MySQL multi-instance deploymentVersion: 5.7.181. Software Installation# tar XF mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz-c/usr/local# cd/usr/local# chown-r root.root MYSQL-5.7.18-LINUX-GL ibc2.5-x86_64# ln-sv mysql-5.7.18-linux-glibc2.5-x86_64

1, new data directory, check the directory is the host permissions, under normal circumstances belong to the MySQL group, MYQL users, because we install MySQL will create a new account and group.2, the directory permission check is complete, stop

After installing MySQL. Suppose to store Chinese. When you read it again, there will be garbled problems.Today there are hundreds of character sets, which are defined by some companies or organizations.We should use a character set that can hold all

Objective: To monitor MySQL's status from the library, if you copy the exception from the Library and alarmIdeas:1, first find MySQL from the library of 4 parameter values (show slave status according to this command), respectively, the IO thread

Adapting to the environment: product upgrade in the project, design to two versions database structure is differentUse tool: Navicat1. Prepare two versions of the database2. Open Tool Navicat3. Connect two databases respectively4. Click

Linux install Tomcat download Linux version tomcat put it in usr/local and unzipTAR-ZXVF apache-tomcat-7.0.73.tar.gzThen rename it to Tomcat and then we'll use Tomcat in the same Windows environment, startingSh./usr/local/tomcat/bin/startup.shStop

In general, we add the configuration in the configuration file my.cnf:[Client]default-character-set = UTF8 [mysqld]default-character-set = utf8character-set-server = Utf8init-connect = ' Set NAMES UTF8 ' collation-server = utf8_general_ci

The first thing to do is to prepare the tool as an environment MySQL Community Server 5.7.x My Workbench 6.3 VS2017 Create a new project, NetmysqlcodefirstSelect MVC, and then select No user authenticationThen install three

Recently, the company did three level certification, nor how to update the Java blog, the recent busy is updated. One of the three-level certifications has a very interesting feeling:General company MYSQL/MARIADB Tomcat doing JDBC authentication is

Mysql Database Study Notes index and mysql Study Notes What is an index: There are two types of SQL indexes: clustered index and non-clustered index. The index aims to improve the performance of the SQL Server system, speed up data query, and

Use MySQL to calculate the number of different values in a column. Preface This requirement is quite common in this article. For example, we have a user source table to mark the channel from which the user registers. The table structure is as