MySQL

steps to operate MySQL :1. Import MySQL Module2. Create a connection3. Creating Cursors4, perform Select/update/delete/insert and other operations (except select other operations need commit)5. Close the cursor, close the connectionImport

To export a database:1, Windows cmd Open command line2, CD to the bin directory of the installation directory of MySQL, if the bin directory is added to the environment variable does not need to switch to the bin directory3. Export database:

1. Create a new SH script (you can first build a txt text and then change to SH file).The code is as follows:#!/bin/bash#set up MySQL backup directoryfolder=/**/**CD$folder Day=`Date+%y%m%d ' RM-rf$daymkdir $dayCD$day#Database ServerIp=ip

Have encountered this problem a few times before, all feel that the problem is not big, so there is no record, but this time again met, and did not think of the first time, so there is a record of the necessaryMySQL DELETE statement throws when

The project was originally an Oracle driver + Druid data source configuration and is now being modified to MYSQL+DRUID data source configurationWhen you start the project, report: Java.sql.SQLException:com.mysql.jdbc.DriverThe reason for the error

Tag: Ike DESC Score--Cannot use CREATE database processingModelCreate Database Sky;Use Sky;CREATE TABLE M1 (ID Int (11),Name Char (20),Age tinyint (10),Sex enum (' Male ', ' female '),Score tinyint (10),Address char (20)) default Charset=utf8;INSERT

MySQL is an open-source relational database management system (RDBMS) that uses the most common database management language-Structured Query Language (SQL) for database management. Let's try to think about what's most important in a production

Vim/etc/profileThe bottom#jdkjava_home=/usr/local/jdk1.8;PATH = $PATH: $JAVA _home/bin;Export Java_home PATH: WqSource/etc/profile let environment variables take effectInstall MySQL:Rpm-qa | grep mysql* See if MySQL is installedYum install MySQL

Reference linksCentOS7 installing MySQLInstallationwget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmyum -y install mysql57-community-release-el7-10.noarch.rpmyum -y install mysql-community-serversystemctl start

MySQL Supplement:MySQL is a relational database, a relational database, a database based on a relational model,The various entities in the real world, as well as the various connections between entities, are represented by a relational model (table).

1. Turn off MySQL service before uninstallingOff way one, if the way one does not please use the way two,[[email protected] ~]# systemctl status MySQL[[email protected] ~]# systemctl stop MySQL[[email protected] ~]# systemctl status MySQLClosing

# # #开发规范Development specification: keyword capitalization, library name lowercase, to have character setCREATE databse oldboy CHARSET UTF8; # # #建议采用第一种CREATE databse Oldboy CHARSET utf8mb4;# # #lower_case_table_names begin###Mysql> Show variables

To understand grouping, you can: group the column names followed by the GROUP BY clause, and then manipulate each grouping instead of the entire table.For example: In the Product table, retrieve the quantity of goods supplied by each supplier.Mysql>

This article does not involve complex underlying data structure, through explain interpretation of SQL, and according to the possible situation, to do the specific optimization, so that millions, TENS data Table Association query first page results

to MySQL:Install: Permissions:Chown-r Mysql:mysql mysql/Error:./mysql.server StartStarting mysql.logging to '/home/mysql/data/izm5e5xf4ylewnqwanhz1mz.err '.2018-06-29t05:32:57.435169z mysqld_safe Directory '/var/lib/mysql ' for UNIX socket file don '

Objective:Because there is not much time and effort, it is not possible to delve into the transactions in the database, such asHowever, some basic knowledge of the transaction, still need to be firmly mastered, to understand the basic knowledge of

Binlog Introduction:A binary log that records SQL statements that occur to or potentially change data, and is stored in a binary form on disk.function:MySQL functions like Oracle's archive logs, which can be used to view the history of a database's

Create a tableincrease, delete, change and check the data in the tableCheckRight-click the table you just created-choose to view the top 1000 dataIncrease, changeThe table must have a primary key to add data, and the primary key cannot be duplicated1

Database optimizationThe online reference method is as follows: One row of data using limit 1; Avoid using SELECT *, you should use specific fields Table join join guarantees that the field type is the same and has its index Use

1. Back up the data folder in the MySQL installation directory before reinstalling the MySQL database server,   2. Uninstall the MySQL database and reinstall the MySQL server. Right-click my computer and choose manage. The following dialog box is