MySQL

This article transferred from: https://www.cnblogs.com/hanmk/p/7574376.html1. Import the databaseUsing the Source commandFirst, connect the database in the cmd window, and then use the Source command to import the operationMysql>use database

Delimiter//create procedure OneKey (in NewName varchar (+), in oldname varchar (+), in Idnum INT) beginset @sqlStmt = CONCA T (' insert INTO ', NewName, ' (' Name ', ' age ', ' sex ', ' major ', ' Pass ', ' photo ') Select ' name ', ' age ', ' sex ',

Install the Atlas software and make the relevant configuration[Mysql-proxy]Admin-username = admin//admin Interface AccountAdmin-password = admin//password for admin interfaceProxy-backend-addresses = 10.2.6.10:3307//main library address and

One, MySQL allows to specify IP remote access1. LoginMysql-u root-p After entering the password to login2. View the user tableYou first need to specify the MySQL database and then the query operationEnter MySQL database mysql> use mysqlmyql> select

1. Database operationsAfter entering the database, you should manage the database. The management database is done through SQL.SQL is a tool used to control and manipulate databases, a language used to communicate with databases. So, the statements

When we perform API testing, WEB service, or other system module testing, you may need to obtain and record data from the database. The purpose of these tests is to examine the data specified in the database, or to add the specified data to the

MySQL implicit type conversionThe understanding in the official documentation is generally:If two parameters are compared with at least one null, the result is null, except that the Nullnull will return 1. Do not type conversionsTwo parameters are

The previous introduction of Mysqldump backup method is the use of logical backup, the biggest drawback is that the backup and recovery is slow, for a database less than 50G, this speed is acceptable, but if the database is very large, then use

1. Background*.sql data files are available every day under Windows Server 2008Need to be uploaded to a MySQL database in LinuxOPS is operated under Windows Server using Xshell Connection Linux for import and exportCustomer Requirements: 1. Click on

1, the Absolute function abs (x) and return pi function pi (x)　　　　ABS (x) returns the absolute value of XPi () returns the value of Pi, which is shown by default after 6 bits2, square root function sqrt (x) and the remainder function modSQRT (x)

Date and time types are datetime, date, TIMESTAMP, time, and year. Note: In MySQL, datetime values are quoted in single quotes. Equivalent to Date,calender in Java.Most commonly used integer types: MySQL column type java data type------

1. Stop the MySQL service; Locate the My.ini in the MySQL installation directory, locate the following fragment in the My.ini [mysqld], and add another line to the code:skip-grant-tables and save2. Start the MySQL service and log in to MySQL (no

8.14 Mysql Multi-instanceWhat is a multi-instance?is to open several different service ports on a single machine and run multiple MySQL service processes that provide their own services through different sockets that listen to different service

InnoDB Index Organization tableI. Index organization TABLE definitionIn the InnoDB storage engine, tables are organized according to the primary key order , which is called the Index Organization table (Index organized table IOT).In the InnoDB

Index: Constraint + Quick FindAn index is a data structure that is used in a database to help users quickly query data. Similar to a directory in a dictionary, you can find the contents of the dictionary based on the directory to locate the data,

--Seventh Chapter--1, check the earliest and latest date of entry dateSelect min (hiredate), Max (HireDate)From EMP--2. Check the average salary of all employees starting with sales, minimum wage, most-high wages, wages andSelect AVG (sal), Min (Sal)

Test environment for this experiment: Windows 10+cmd+mysql5.6.36+innodbI. Basic elements of a transaction (ACID)　　1, atomicity (atomicity): All operations after the start of the transaction, or all done, or all do not, it is impossible to stagnate

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements. Simply put, its role is to analyze query performance.The Explain keyword is very simple to

MySQL connector/j is very flexible for the conversion between MySQL data type and Java data type.In general, any MySQL data type can be converted to a java.lang.String, any MySQL number type can be converted to any kind of Java number type (of

Master-Slave replication principle As master server master, each of its changes will be recorded into the binary log binarylog. (The server I/O thread is responsible for reading the master binary log, then writing itself to the relay log