MySQL

MySQL Statement Specification:　　1. keyword and function name all uppercase2. Database name, table name, field name all lowercase3. The SQL statement must end with a semicolon4. Comment Statement with "#"First, the operation of the database* SHOW

Knowledge Background:MySQL the default value of the maximum number of connections is 100, for a large number of concurrent connections of the database, when the connection request is greater than the default number of connections, there will be no

I. Creating a database (default character set and collation) (1) Create a database[SQL]View PlainCopy mysql> CREATE DATABASE my_db1; Query OK, 1 row Affected (0.00 sec) (2) Because MY_DB1 already exists, create an error

What's the only thing?1. All values of the indexed column (field) can only occur once, i.e. must be unique--------------------------------------------------------------------------------The difference between a primary key index and a unique index1.

Backing Up the database#mysqldump database name > database backup name #mysqldump -a-u user name-p password database name > database backup name #mysqldump1. Export structure does not export data2. Export data does not export structure3. Export Data

1. Open terminal, enter: CD ~Will enter the ~ folder2. Then enter: Touch. Bash_profileAfter the carriage return is executed,2. Re-enter: Open-e. bash_profileThis file is opened in TextEdit (this should be a blank document if the environment variable

The tests that were previously done on the latency correlation and index coverage were not recorded at the time, resulting in the recollection of forgetting some of the minutiae behind them. Today, take advantage of the impulse to revisit the test

These two days to take over, other people left the crawler found a very fun SQL script stitching.As long as your scrapy field name is the same as the name of the database field. Well, congratulations, you can copy this SQL stitching script. for

Project Address: HTTPS://GITHUB.COM/EVA911128/EXPRESS4-MICROBLOG/TREE/V1The effect is as follows: Home: Login page: Registration interface: Post-Login Interface: After sending the content interface:

Bo Master Original, reproduced annotated Source:In the MySQL application, the scope of the query is a lot of time range as a condition for the scope of query, time range query hasMany kinds of writing, first summed up the Between....and ... How to

Bo Master Original, reproduced please indicate the source:The use of the IF () function in MySQL is similar to the three-mesh expression in Java, and is more useful, with the following syntax:if (EXPR1,EXPR2,EXPR3), if the value of EXPR1 is true,

(1) Cleanup log:PURGE, delete the binary files, can not be directly physically deleted, or restart the MySQL service may cause a variety of exceptions, need to use the command PURGE to delete, because after MySQL restart, will not find the

Create a new table:CREATE TABLE ' tree ' ( ' id ' int (one) not NULL auto_increment COMMENT ' primary key ', ' parent_id ' int (one) ' NOT null, ' name ' varchar (ten) not NULL, PRIMARY KEY (' id ')) engine=innodb DEFAULT Charset=utf8;　　Create

querying the entire contents of a data tableMysql> Show tables, #查看当前数据库下的全部表 +--------------------+| Tables_in_ceshi_ku |+--------------------+| Biao | | Ceshi_biao |+--------------------+2 rows in Set (0.00 sec) mysql> select

1.Packets larger than Max_allowed_packet is not allowedA system parameter for MySQL:max_allowed_packet, whose default value is 1048576(1M),Enquiry:show VARIABLES like '%max_allowed_packet% ';Modify the value of this variable: "max_allowed_packet =

1. Create automatic backup directories and scripts# mkdir/data/mysqlbackup/# VI backdb.shAdd the following script content#!/bin/bash/usr/local/mysql/bin/mysqldump-uacm-pacm123 acmdb >/data/mysqlbackup/acmdb_$ (Date +%y%m%d_%h%m%s). sqlTar

Different versions of MySQL optimizer have a certain difference+ View Database versionSELECT @ @version;+ View the database being usedSelect Database ();+ See if MySQL turns on slow query logShow variables like ' Slow_query_log ';+ turn on MySQL

The second day of Mysql learning, the second day of mysql DDL database Definition Language (Database Operations) (read and understand, rarely used at work)1. Create a databaseCreate database name [character set table name collate character

Mysql storage engine and mysql StorageStorage engine Definition The database storage engine is the underlying software organization of the database. The database management system (DBMS) creates, deletes, modifies, and queries data through the

MySQL-index details, mysql-Index IndexIs used to quickly retrieve records with specific values. If no index exists, the database must scan the entire table from the first record until relevant rows are identified. The more data you need, the higher