This article turns from https://m.imooc.com/article/details?article_id=17290 thanks to the author
The previous article recorded my understanding of the MySQL transaction isolation level READ UNCOMMITTED.This article records my understanding of
the use of MySQL data files is only extended and not recycled. After you perform a delete on a table, the data files on the disk do not shrink. the usual practice is to logically export and then truncate the original table (or delete the Rebuild)
MySQL table name ignores caseProblem Description:A development colleague in the Linux downgrade a program always error said can not find the table, but landed mysql,show tables view is already created this table!! As follows:
12345678910
Original: 49863787I. Query and index optimization analysis1.show command:Show engines;Displays status information for the storage engine. This statement is useful for checking whether a storage engine is supported, or for viewing what the default
1. Create a databaseCreate DATABASE nameegCreate Database To view the data you have created:show databases;Results:2. The database name corresponding to the database does not exist in the case of the creation. If it already exists, it is not
PHP Configuration
Referencing mysqli extensions
Extension = Php_mysqli.dll
No absolute path required
If not enabled, then the reference mysqli extension must use an absolute path referenceExtension_dir = "ext"Creating and
MySQL database Advanced (vii)--Transaction and lock, Transaction introduction 1, Transaction introductionA transaction (Transaction) is a series of operations performed as a single logical unit of work.2, the characteristics of the transactionA,
This error occurs because the encryption rule is mysql_native_password in the previous version of Mysql8, and the encryption rule after Mysql8 is caching_sha2_password.There are two ways to fix this problem, one is to update the NAVICAT driver to
VirtualBox Install CENTOS7 and configure the nginx PHP MySQL runtime environment one: VirtualBox install CENTOS7 and make Basic settings1. Download the Dvd.iso installation file: https://www.centos.org/download/I chose the Dvd.iso version, we have
INDEXBecauseperformance, Smart resultsFor many reasons, when searching for text, Full-Text search one is better than the wildcard wildcards regular expression, which indexes the specified column to quickly locate the corresponding row, andSmart
Foreword: DataFactory is a rapid production of test data visualization tool, is a powerful data generator, the tool supports DB2, Oracle, Sybase, SQL Server database, support ODBC connection mode, and use the MySQL database through ODBC
A partitioned table is available for the following scenarios1: The table is so big that it can't be put all in memory, or only the last part of the tag has hot data, the others are historical data2: Partitioned table data is easier to maintain. For
OverviewThe metadata information of Hive is usually stored in the relational database, and the common MySQL database is managed as a meta-database. The previous installation of Hive also stores metadata information in the MySQL database.Hive
Today, I used cmd to install MySQL server side encountered the Msvcr120.dll problem, so I went to download the DLL online, but there is no access to find, or anything. I thought, to download the runtime library (because MSVCR is a Microsoft Visual C
1. Set the Servie-id value of main Library master and turn on Bin-log function parameterVi/etc/my.cnfTo modify the parameters of the MY.CNF:[Mysqld]Server-id=1 //Each library must have a different Server-idLog-bin=mysql-bin2. Check that the
When the user login module, enter the user name (large/lowercase) and password, MySQL can find out. --MySQL queries are case-insensitive.Transfer from http://blog.csdn.net/qishuo_java/article/details/40118937Find data for users with user name ID '
Change the root password of the MySQL database to modify the root password command to/usr/local/mysql/bin/mysql -urootDefining environment variables temporarily defining environment variablesexport PATH=$PATH:/usr/local/mysql/bin/
management of MySQL usersFirst, view the current Connection account information1.1, view the current database to connect the account informationUse command: Show ProcesslistMySQL [(None)]> show processlist;+--------+-------------+--------------------
I. Introduction of IDE ToolsThe production environment is also recommended for MySQL command line, but for our testing purposes, you can use the IDE tools NavicatSecond, MySQL data backup#1. Physical backup: Direct copy of database files for large
Table 1 foreign Key Table 2 Table 1 is a number of records corresponding to table 2 a record, that is, a multi-to-one use of foreign key principle we can make two tables of many-to-many, one-to-many relationship: table 1 of the multiple records
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