Common operations for the "Code learning" MySQL Database

==============================Common operations for MySQL databases==============================I. Connection and shutdown of MySQL-H: Specify the server location to which you are connected-U: The user name of the database-P: Database password1

MySQL full-text index ranking

Mysql> CREATE TABLE articles (ID INT UNSIGNED auto_increment not NULL PRIMARY KEY, title VARCHAR (200 ), Body TEXT, Fulltext (title,body), Engine=innodb; Query OK, 0 rows affected (2.48 sec) mysql> select * from articles; Empty Set (0.00 sec) mysql>

MySQL Proofing set

First, the concept of proofing setsProofing sets are the way data is compared, and the proofing set works when the data is compared.Two or three different formats1, _bin:binary, binary comparison, take out bits, a comparison of one (case-sensitive).2

My MySQL learning Experience (vii) query

In this "My MySQL Learning experience" series, I have been comparing MySQL with SQL Server, comparing each other is a better way to learn somethingCompare the similarities and differences, so as to deepen the memory.This article "My MySQL Learning

SQL---->MYSQL Database 1------JDBC Quick Start

JDBC (Java Data Base Connectivity,java database connection) is a Java API for executing SQL statements that provides unified access to a variety of relational databases.Objective: To learn the JDBC interface without having to learn the driver of

MySQL Practice----Using Null

Teacher ID Dept name Phone Mobile 101 1 Shrivell 2753 07986 555 1234 102 1 Throd 2754 07122 555 1920 103 1 Splint 2293

MySQL cleanup tips for binary logs

dba

1: Binary logThe binary log records all DDL(data definition Language) statements and DML(Data Manipulation language) statements, but does not record statements that include data queries. Statements are saved as "events," which describe the process

MySQL regularly archives data

# Create an archive table (duplicate table structure and index only) create table orders_2016 like Orders; # Delete all indexes of the archive table (this will increase the insertion speed) # Previous Data import archive table insert into orders_2016

MySQL installation configuration

7 Reference: Http://www.cnblogs.com/Fiona20170420/p/6738185.html1. Download2. Unzip3. Add the PATH environment variable, which points to the MySQL bin directory4. Create the Data folder in the home directory5. Registering Windows System

MySQL Utility instructions

ConnectionMysql-h192.168.1.113-uroot-p3306-phaha-P followed by password-U followed by user nameBuild tableCREATE TABLE ' TableA ' (' id ' int (one) not NULL auto_increment COMMENT ' id ',' Name ' varchar (1024x768) not NULL DEFAULT ' COMMENT '

Install MySQL + nginx

[[email protected] ~]# yum-y install mysql-server MySQL..........................[[email protected] ~]# rpm-q mysql-server (see if installation and version number)[email protected] ~]# Yum list |grep mysql-servermysql-server.x86_64 5.1.73-5.el6_6

"PHP" Apache can not actively jump but show folders and PHP can not connect to the MySQL database solution

vc9

One, Apache can not actively jump but show foldersApache can not actively jump but show folders this is because Apacheserver under conf/httpd.conf not configured well, its default is not to jump, directly display the folderFirst, we need to prohibit

MySQL foreign key creation failure reason

Reference: http://blog.csdn.net/wangpeng047/article/details/19624351First, if the data is already inserted in several tables related to the foreign key, it may cause the foreign key insert to failWhen you create a foreign key in MySQL, you often

MySQL Log management

Mysql Log error log: Log mysql server startup, shutdown, and run errors and other informationBinary log: A binary file that records all operations except select in the database (the most important log)Query LOG: Record query informationSlow query

MySQL database transfer between computers

Application Example: database1 (abbreviated DB1) saved in MySQL in PC1, need to migrate DB1 to MySQL in PC2environment : win7 MySQL5.7.13Reference: http://stackoverflow.com/questions/22447651/copying-mysql-databases-from-one-computer-to-anotherSteps:

Talking about the key_len Calculation Method in mysql explain, explainkey_len

Talking about the key_len Calculation Method in mysql explain, explainkey_len The explain command of mysql can analyze the SQL Performance. One of them is the statistics of key_len (index length. This article analyzes the calculation method of

SQL where, group by, and having usage parsing, sqlhaving

SQL where, group by, and having usage parsing, sqlhaving -- SQL where, group by, and having usage parsing -- if you want to use group by, you generally use "every word". For example, there is a table like this: how many people in each department

Binlog parameter in MySQL: binlog_rows_query_log_events,

Binlog parameter in MySQL: binlog_rows_query_log_events, When using RBR, that is, the row format, to parse the binlog, You need to reverse analyze what the corresponding original SQL is, and the content corresponding to each specific row is changed.

Data desensitization introduction and data Desensitization

Data desensitization introduction and data Desensitization Data Masking, also known as Data bleaching, Data de-privacy or Data deformation. Baidu encyclopedia defines data desensitization as: Deformation of sensitive information through masking

MyRocks DDL principle and myrocksddl Principle

MyRocks DDL principle and myrocksddl Principle In the DDL process of a recent daily instance, the database was directly dumped, and the problem was still serious. So I checked the problem and pulled down the crash stack and alert logs, it was found

Total Pages: 3233 1 .... 1950 1951 1952 1953 1954 .... 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.