The recent use of MySQL database has encountered several types of numbers, mainly int,bigint,smallint and tinyint. One of the more confusing is the difference between int and smallint. Today on the Internet to find out carefully, find the following
InnoDB Storage Engine1. Storage: Data directory. Can be modified by configurationStore file: Frm,ibd end of file. FRM storage table structure, IBD stores indexes and dataStorage log: Ib_logfilen file2.INNODB storage engine turned on or off:Close
There are four database isolation levels, as described in the "high-performance MySQL" Book:Then talk about how to modify the transaction isolation level:1. Global modification, modify the Mysql.ini configuration file, at last add1 #可选参数有:
How to set the MySQL root password:1, first install root initial password is empty, note is no password, directly hit enterD:\wamp\bin\mysql\mysql5.6.17\bin>mysql-uroot-pEnter password: [Direct return]Welcome to the MySQL Monitor. Commands End With;
Mysql:Drop TABLE IF EXISTS temp; Delete if temp is presentCreate TABLE Temp (cmd text not NULL); Create a temp table with a CMD field inside itInsert into temp (cmd) VALUES (); Insert a word trojan into the temp tableSelect cmd from temp to out file
First, yum preparation1.Yum (Yellow dog Updater, Modified) is a shell front-end package manager in Fedora and Redhat as well as in CentOS. Based on RPM package management, the ability to automatically download RPM packages from specified
1. preferred to enter Windows Server, current directory under D:\Mysql server5.0\data\ mysqldump–u root–p ultrax >ultrax.sql //Note Meaning: The current directory is to be located in the data directory, otherwise exported is an empty file;or
MySQL Data folder/data/mysql is located in the upper folder/data not enough disk space to cause MySQL boot failure, so clean up the/data folder in addition to the MySQL subfolder of the other useless folders. Restart discovery or failure. Check the
page level: Engine BDB. Table level: Engine MyISAM, understood to lock the entire table, you can read at the same time, write No Line level: Engine INNODB, a separate row of record lock table level, directly lock the entire table, during your lock,
MySQL Optimization problem locationFirst pull down, a long time did not come to CSDN blog, recently learning Yan 18 MySQL optimization, and the teacher said up to the top of the air, today just have time to summarize this period of learning
The MySQL server works in different SQL modes and can be applied in different ways for different clients. In this way, the application can tailor the server operation to suit its needs. Such patterns define the SQL syntax that MySQL should support,
In the "Create Database and database table with MySQL" article, how do we create a database and database table and how to add records to the database table. How can we retrieve data from database tables?1. Retrieve Information from a database
MySQL foreign Key Usage Details, MySQL Key Usage Details
Recently, I started to create a laboratory management system. Because I have stored several tables, I want to maintain the association between tables. I studied the Foreign keys of MySQL.
(1)
Object Attributes of MySqli extension library and comparison with mysql database process orientation
After learning the mysql database to operate mysql, this is a process-oriented method. However, object-oriented is the trend of the times, and the
Mysql stores UUID to remove the horizontal line, and mysqluuid removes the horizontal line
Refer:
Http://stackoverflow.com/questions/412341/how-should-i-store-guid-in-mysql-tables
UUID is usually used as a unique identifier and needs to be stored in
MySQL row-level locks often cause problems. The following describes the advantages and disadvantages of MySQL row-level locks. We hope you can learn more about MySQL row-level locks.
If you want to perform a large number of INSERT and SELECT
MySQL study note _ Summary of MySQL character type VARCHAR length I. VARCHAR storage and row length restrictions1. in VARCHAR (N), N refers to the length of characters. The VARCHAR type supports a maximum of 65535 characters and 65535 bytes, but
In May last year, I first introduced MariaDB 10.0 on my blog. At that time, we received a lot of feedback. After summing up the comments, we once again explained MariaDB 10.0 in a more in-depth manner. at the beginning of the New Year, with the
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