MySQL

1. Download:The official website download is required to register, or you already have an Oracle account.Can directly Baidu MySQL into the official website, or directly below the link;Attached link:dev.mysql.com/downloads/mysql/The specific download

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:

Use Xtrabackup to do a full backup. After we have installed Xtrabackup, it gives us a few command-line tools where we back up the command to use is Innobackupex, which is a script that encapsulates several xtrabackup of several command lines

MySQL's slow query log is a log record provided by MySQL, which is used to record a statement in MySQL that has a response time exceeding the threshold, which refers to SQL that runs longer than the Long_query_time value, and is recorded in the slow

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

Using the mysqldump command to back upThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very simply. It

Tag: Exactly and log Dex Server module dir supports codeSometimes we just want to set the lamp environment to do a test, do not care about the directory and configuration specification, this tutorial is for this idea and write can be simple and not

MySQL Default character retrieval policy: UTF8_GENERAL_CI is case insensitive , this is the default collation of the UTF8 character set; Utf8_general_cs is case-sensitive, utf8_bin means binary comparison , also case-sensitive:

. Cascade WaySynchronize update/delete out a matching record of a child table when Update/delete records on the parent table. Set NULL modeSet the column of the matching record on the child table to NULL when the record is update/delete on the

Read the words this morning:Order: OrdersConstraint: (mandatory) constraintFOREIGN key: FOREIGN keyReferences: Point toOrderItem: Order ItemsJoin: JoinResourceBundle: Resource BundleClassLoader: Class LoaderProperties: AttributesInputStream: Input

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

This article "My MySQL Learning experience (11)" will explain the MySQL viewWhat are the reasons for using a view?1, security: This is generally done: Create a view that defines the data that the view operates on.The user rights are then bound to

This article "My MySQL Learning Experience (ii)" will explain the MySQL triggerA trigger is a special stored procedure, in which the stored procedure is called with call, and the trigger does not need to use the callingIt does not need to be started

%W Week name (Sunday ... Saturday)%d The date of the month with English prefixes (1st, 2nd, 3rd, etc.). ）%Y year, number, 4 bit%y year, number, 2 bit%a abbreviated weekday name (Sun ... Sat)Number of days in the month of%d, number (00 ...).

#!/bin/bashport=3306Basedir=/application/mysqldatadir=/data/$port/datapidfile=/data/$port/mysql.pidsock=/data/$port/mysql.sockbindir= $basedir/binStatus=$1USAGE () {echo "Usage:/data/$port/mysql {Start|stop|restart}"}Start () {if [!-F $sock]ThenEcho

Differences in syntaxI'm mainly talking about grammatical differences here.1. Default ConstraintsDifference: MySQL does not use parentheses after the default keyword--sqlservercreate table emp (ID int default ())--mysqlcreate table emp (ID int

Figure can include the implication and meaning of words can not be compared to the first one you will know the main content of this article is about what the problem. Save a lot of text of the statement. Take a look at this picture below:The

In MySQL 5.7, how do I modify the root password ?, Mysqlroot For a long time, MySQL's application and learning environments are both MySQL 5.6 and earlier versions, and they have not paid attention to the changes and new features of the new version

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