MySQL

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. 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:

MySQL Chinese garbled processing Locate the My.ini file (default in the C:\ProgramData\MySQL\MySQL Server 5.7 folder); In the My.ini:Search to [client], modify or add Default-character-set=utf8;Search to [mysqld], modify or add

Project Address: HTTPS://GITHUB.COM/EVA911128/EXPRESS4-MICROBLOG/TREE/V1The effect is as follows: Home: Login page: Registration interface: Post-Login Interface: After sending the content interface:

Copy filter: Copy only one or a few database-related data, not all; by the replication filter;There are two filtering methods, filtering on the primary server or filtering from the server(1) Filtering on the primary serverEnable selective

MySQL master-slave replication configurationConfiguration principle (the slave database is audq by a binary log file)First, demand: Version consistent System startup MySQL Second, master configuration: Modify the binary log, and

Master/slaveMaster:write/read, write operations are done on the master nodeSlaves:read, read operations are sent from the node side.Why do you want to copy?Redundancy: promte (promotion-oriented), offsite disaster preparedness, can be achieved

The concat () function is used to concatenate strings.Exact query: SELECT * from user where name= "Zhangsan"fuzzy query; select * from user where name is like "%zhang%"In actual use, the condition is passed in as a parameter. So we use the concat ()

(1) Cleanup log:PURGE, delete the binary files, can not be directly physically deleted, or restart the MySQL service may cause a variety of exceptions, need to use the command PURGE to delete, because after MySQL restart, will not find the

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

MySQL Reset passwordMay for various reasons, we accidentally lost the MySQL password, to use the time can not login, can only reset the password! This configuration modification document is in the Linux Ubunt environment, other operating systems can

MySQL's built-in replication capabilities are the foundation for building large, high-performance applications. The distribution of MySQL data across multiple systems is done by copying data from one of the MySQL hosts to the other host (slave) and

First, export the data imported into all databases1. Export　　　mysqldump -u root-p123456 --all-databases > All.sql　　　2. Import　　　MySQL -u root-p123456 　　　Export Import only specifies data for the database1. Export　　　mysqldump -u root-p123456 Test >

The scenario is as follows:"Today's front-end suddenly said, I need to make a judgment, can not repeat the collection, I like the neck of the icy shudder, so think what I should do?" Why did she think that I didn't think it was my job?Think of three

1. JDK InstallationNote: RPM and software-related commands are equivalent to software Assistant management software under WindowsSteps:1) See if the current Linux system has Java installedInput Rpm-qa | grep java1) Uninstall two X OpenJDKEnter RPM-E-

1. Create automatic backup directories and scripts# mkdir/data/mysqlbackup/# VI backdb.shAdd the following script content#!/bin/bash/usr/local/mysql/bin/mysqldump-uacm-pacm123 acmdb >/data/mysqlbackup/acmdb_$ (Date +%y%m%d_%h%m%s). sqlTar

1 MMM Overview1.1 About Mysql-mmmMySQL Primary master Replication ManagerMySQL master replication configuration for monitoring, failover and management of a set of script suites;Can read load balancing and data backup for any number of slave servers

Mysql storage engine and mysql StorageStorage engine Definition The database storage engine is the underlying software organization of the database. The database management system (DBMS) creates, deletes, modifies, and queries data through the

MySQL Chinese garbled characters and mysql garbled characters MySQL Chinese garbled Processing   MySQL viewing code -H indicates the server name, And localhost indicates local; -U indicates the database user name, and root indicates the

[SQL] mySQL is started in windows and sqlmysqlwindows Different SQL versions have different startup configuration methods in Windows. The configuration method of 5.7.20 is described here;   1. log on to the mysql website to download the compressed