MySQL

About MySQL1. What is a database?A database is a warehouse that organizes, stores, and manages data according to its structure, which is generated more than more than 60 years ago, with the development of information technology and markets,

If an error occurs cannot connect service on ' IP ' (110)Can be considered from the following aspects:1, the connection command has no write error y (especially-P 3306 "p is uppercase")2, the password is not written wrong3, the remote database

Xtrabackup is an online hot backup tool developed by Percona company, which is open source and free of charge. Do not support Windowsxtrabackup website: www.percona.com need to go to the official website to download this tool:

# # Source Compilation Install Mysql take mysql-5.7.15.tar.gz as an exampleSome of the issues involved in the installation need to be explained in advance:All downloaded files will be saved in the/root directoryMySQL will run as a MySQL user and

Problem Description:After starting the transaction, the Java code makes a query, then inserts, which is reported at this time: Java.sql.SQLException:could not retrieve transation read-only status serverresolution process:View MySQL's things

1 Installing the serversudo apt-get install Mysql-server2 Installing the Clientsudo apt-get install mysql-clientsudo apt-get install Libmysqlclient-devThe installation process needs to set the user name password, do not forget3 Check if there is a

Data insert, modify, delete operations for 1.MySQL database tables SQL syntax format:1 CREATE DATABASEdb0504;2 3 Usedb0504;4 5 CREATE TABLEStudent (6SnoVARCHAR(Ten) not NULL UNIQUE PRIMARY KEY,7SnameVARCHAR( -) not NULL,8Ssex enum ('male','female')

First, simple query1. Most simple query (check all data)Select * from table name Note: * represents all columns and does not represent all rowsExample: SELECT * FROM Test2. Querying a specified columnSelect column name, column name from table

Recently accidentally touched a little bit of PHP development, to use the MySQL database, due to MySQL and PHP version of the relationship, PHP5 inside the connection function has mysql_connect (), Mysqli_connect () two, PHP7 and used mysqli ()

About Wait_timeoutOnce went to online set wait_timeout when found changed does not take effect, as follows:Mysql> Show variables like ' wait_timeout ';+---------------+-------+| variable_name | Value |+---------------+-------+| Wait_timeout | 100 |+-

Tag: Bit order identifies important user access 0.00 NULL sign DealerCreate a sample table:CREATE TABLE shop(Article INT (4) UNSIGNED zerofill DEFAULT ' 0000 ',Dealer CHAR (DEFAULT ') ' Not NULL,Price DOUBLE (16,2) The DEFAULT ' 0.00 ' not

First, the basic queryQuerying all Columns　SELECT * from table name;　　Querying a specified column　　Select field 1, Field 2 from table name;　　Second, the conditions of inquiryThe WHERE clause is given when querying to limit the results of the query

Today, we build an Ubuntu 64-bit Tomcat + java + MySQL environment, and now summarize:1. Download the

1. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general, the smaller the tables in the database, the faster queries are executed on it. Therefore, in order to achieve better performance when

MySQL Limit usage select * from TableName LIMIT [offset,] rows; 1. Select * FROM table limit m,n (show number of bars) where m refers to the index at which the record starts (the index is the first record starting from 0) n means starting with

1. Intercept string from leftLeft (str, length)Description: Left (truncated field, intercept length)Example: Select Left (content,200) as abstract from my_content_t2, starting from the right to intercept the stringRight (str, length)Description:

MySQL transaction processing and MySQL Transaction Processing Steps: 1. Enable transaction start transaction When we start a transaction, all SQL operations occur in the memory, but no real feedback is sent to the database disk file! 2. Roll Back

Mysql 5.7.18 installation tutorial and problem summary, mysql5.7.18 Mysql 5.7.18 installation and problem summary: A New mysql is deployed today, and several minor problems are encountered. Record the problem. Step 1: https://dev.mysql.com/downloads/

Mysql database interview summary and mysql database interviewDatabase optimization table creation optimization 1) database paradigm L 1NF: It emphasizes the atomicity of the column, that is, the column cannot be further divided into several other

MySQL modifies table field information and mysql field information. I learned a lot yesterday. First, let's review mysql. When I was querying table information Empty set 0.00 sec I am very surprised. I checked carefully and found that the