MySQL exercises one

DROP TABLE IF EXISTS ' Liuyan '; CREATE TABLE ' Liuyan ' (' id ' int (11) not NULL auto_increment, ' title ' varchar (32) not NULL, ' author ' varchar (16default NULL, ' Addtime ' datetime DEFAULT null, ' content ' text, ' status ' char (1) Not NULL

Mysql 5.7.21 Single-machine multi-instance installation

Download MySQL 5.7 Two package[[email protected] ~]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.5-x86_64.tar.gz Unzip the MySQL 5.7 binary package to the specified directory[[email protected] ~]# tar zxvf mysql-5.7

MySQL Database optimization One

First look at the entire process of sending and receiving requests from the MySQL databaseMySQL logical architecture is divided into three layers, the top layer is the client tier, not unique to MySQL, such as: Connection processing, authorization

Implementing the MySQL Primary master replication architecture

experimental Environment, suppose the company wants to run a MySQL server for a period of time, do a primary master replication architecture to improve the database read and write ability. Old server with M0

The use of InStr functions in MySQL

Test database: MySQL DatabaseINSTR (STR,SUBSTR) searches for the specified character (SUBSTR) in a string (STR) and returns the position (INDEX) of the specified character;STR is searched for stringSUBSTR the string you want to searchConclusion: In

MySQL User management

Based on the mysql5.7.21 versionAside: Some commands if not available, please refer to the official version of the document, because, some of the command format, in the slowly obsolete (such as: IDENTIFIED BY PASSWORD ), or not recommended (such as:

7. Configuration and installation of MySQL

Installation of MySQL in Linux environment sudo yum install Mysql-server Modifying a configuration file Vim/etc/my.cnf Add default-character-set = UTF8 Set up MySQL to start automatically

MySQL master-slave replication technology Detailed

M-sPrimary server: Master1The first step: Open the Bin-log log, set as follows:Vim/etc/my.cnfLog_binServer-id=1Gtid_mode=onEnforce_gtid_consistency=1Step two: Access to the database authorized usersMysql-uroot-p ' Password 'Grant Replication

MySQL common operations (bottom)

MySQL User management1. Create User: Grant commandmysql> grant all on *.* to ‘user1‘@‘127.0.0.1‘ identified by ‘123456a‘;Query OK, 0 rows affected (0.00 sec)Test[[email protected] mysql]# mysql -uuser1 -p123456a -h127.0.0.1Warning: Using a password

Maven initially builds a basic project (Spring MVC+SPRING+JDBC mysql+)

Technology selection:I. Project CONSTRUCTION:1) Create a MAVEN project (I have an introduction in my blog)Choose Aptach's Maven-archetype-webappFill in Groupidhe Artifactid, etc.Confirm Project NameThe Maven plugin automatically generates the

Set change mysqlroot password, connect mysql,mysql common commands

Set Change mysqlroot passwordEnter MySQL database for the first time,!The MySQL absolute path can be added to the environment variable,You can also set the boot load,Reload environment variable for MySQL to take effectRe-login to Mysql-urootAdd a

MySQL server has gone away

MySQL server has gone awayScene:MySQL Backup to import times this mistakeReason:The imported data is too large to exceed the MySQL default size limitSolve:To view MySQL settings: Show global variables like ' max_allowed_packet '; Adjust

Orthogonal difference in MySQL

MySQL only provides the union, does not provide the difference set, and the intersection, but we can use the Union to achieve the intersection and the difference, the following is the implementation method:First create two tables:ERROR 1064

NO4. MySQL database master-slave replication error Resolution

Of course, to solve the problem, we have to have the environment first.A master one from the configuration flow:Main: Configure DNS resolution first, the experimental environment can use/etc/hosts parsingVim/etc/hosts192.168.122.45 Master1192.168.122

MySQL One: primary knowledge database

First, the origin of database management softwareBased on what we've learned before, data is stored in a file for permanent preservation, without a doubt that a file can only exist on a single machine.If we ignore the efficiency of accessing data

MySQL size and length of each data type

Digital type Type Size Range (signed) Range (unsigned) Use TINYINT 1 bytes (-128,127) (0,255) Small integer value SMALLINT 2 bytes (-32 768,32 767) (0,65

Mysql has the problem that the table 'xxxxx' is full, mysqlxxxxx

Mysql has the problem that the table 'xxxxx' is full, mysqlxxxxx When this problem occurs, the first response is that the table is full and the disk is full, but the server is not long before it is started. No, Then my friend sent me an article ..

Mysql database index optimization and Practice (I), mysql Index

Mysql database index optimization and Practice (I), mysql IndexPreface Mysql database is currently the most widely used database system. Dealing with databases is one of the daily work of every Java programmer. index optimization is one of the

Translation: select into Statement (submitted to the MariaDB official Manual), intomariadb

Translation: select into Statement (submitted to the MariaDB official Manual), intomariadb This article is the translation of the mariadb official manual: select. Original article:

How to modify the default mysql character set to utf8 in MAC, mysqlutf8

How to modify the default mysql character set to utf8 in MAC, mysqlutf8 1. Check the character set of the default installed mysql Mysql> show variables like '% char % ';+ -------------------------- + --------------------------------------------------

Total Pages: 3233 1 .... 1721 1722 1723 1724 1725 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.