Char fixed length, so the processing speed is much faster than varchar, but to the cost of storage space, so the storage is not small, but the speed of the requirements can use the char type, conversely, can be used to instantiate the varchar
During an interview, the interviewer asked me, "What does the length of int type represent whenMySQL is building a table ?" is this column allowed to store the maximum width of the value? ? Why I set it up as Int (1), as well as being able to save 1
Lnmp is a very popular site configuration, I in the configuration Cicada master server in passing experience to share, Cicada Master's website is: http://www.ddashi.com/1, the first step, with the new Apt-getInput:sudo apt-get update2, the second
Cross-server MySQL access, iptables configuration1> setting MySQL permissions on the machine being accessedGrant all privileges on * * to [e-mail protected] "[IP]" identified by "[Pass]" with GRANT option; Authorization, you can set different
Today began to learn MySQL database, is also the first time to write technical notes here, I believe that good memory is not as bad as written, so as to witness their own growth it!First install the MySQL server process here is not wordy, I believe
Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/44085635[[email
select TABLE_NAME, TABLE_SCHEMA, Data_free from information_schema.TABLES where TABLE_SCHEMA NOT IN (‘information_schema‘, ‘mysql‘) and Data_Free >0;+-----------------+--------------+-----------+|table_name|Table_schema|Data_free|+-----------------+-
Transferred from: http://793404905.blog.51cto.com/6179428/1615550This article shows the four isolation levels of MySQL transactions through an example.1 Conceptual description1) Read UNCOMMITTED (read not submitted)Other transactions are aware of
MySQL cmake compilation and installationLab Preparation Environment:My operating system is centos6.6.Before compiling and installing mariadb, we need to prepare some required environments1. Development Package Group Kit[[email protected] ~]# yum-y
1, transaction processingInnoDB supports transactional features, MyISAM not supported. Myisam executes faster and performs better. 2,select, UPDATE, INSERT, delete operation MyISAM:if executing a lot of select,myisam is a better choiceInnoDB:If
Error: 1130-host allowed to connect to this MYSQL server1. Change the table method.It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the
Background:using LIGHTTPD as a Web server, PHP acts as a server script, MySQL as a database. When the browser client accesses, the server PHP script attempts to connect to MySQL, querying the data and returning it to the client. However, in the
1.usage PermissionsThis permission can only be logged into the database, cannot perform any operations, and usage permissions cannot be recycled2.select PermissionsThis permission is a field-level permission to query the data in the table3.insert
1, transaction processingInnoDB supports transactional features, MyISAM not supported. Myisam executes faster and performs better. 2,select, UPDATE, INSERT, delete operationMyISAM:if executing a lot of select,myisam is a better choiceInnoDB:If your
Select the database for which you want to export the table structure.Right-click, in the menu that appears, selectData Transfer"This item , in the pop-up window "Data Transfer"Click to select the" Advanced "item in the"Advanced"in the Hand"Logging
Notes for compiling and upgrading mysql, such as php connection to mysqlnd phpmyadmin and mysqlndphpmyadmin
For the InnoDB engine, copy the ib_logfile0, ib_logfile1, ibdata1, and database folders under the data Directory (only frm files are in it)
[Switch] MySql modifies the table type and mysql modifies the table
Recently, I encountered a problem about modifying the mysql table type. Previously, when phpmyadmin managed the mysql database, the created table is of the MyISAM type by default,
MYSQL import, export, and restore backup
The import and export mainly involve two Commands: source and MySQLdump:
1: Import: Enter the MySQL command line, enter any database to be imported, and then import. The specific command is as follows:
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