Recently followed a Web site to learn a small project, because there are classes during the day, so it is written in the evening, today to finish it.
The main project is to implement a file upload, through the client landing, the local files
1. Preface :
MySQL database is a completely networked Cross-platform relational database system, and a distributed database management system with client/server architecture. The utility model has the advantages of strong function, simple use,
MAC Local Environment Buildin the Mac system, we can use the Mamp Pro (official website: https://www.mamp.info/en/) software to build the local server. Install this software, the site directory in the/applications/mamp/htdocs folder, just put the
This configuration is used on the old boy production line in the configuration, in the training time he gave, I'm here, add a Chinese description to each parameterThis configuration has been optimized, if your MySQL is not a special case, you can
And since InnoDB is a robust transactional storage engine that has a history of more than more than 10 years, some heavyweight internet companies (Yahoo,google NetEase, Taobao) often use
My daily work also often contacts InnoDB, now InnoDB part of
MySQL usually completes the distinct operation using groupby (essentially a sort action), and if the distinct operation is combined with the by-order operation, a temporary table is usually used. This can affect performance. In some cases, MySQL can
In a MySQL query, duplicate values may be included. This is not a problem, but sometimes you may want to list only the different values (distinct).
Keyword DISTINCT is used to return only a different value, that is, to go heavy. The usage is also
Basic concepts
Defined:
The binary log contains all the statements that have updated the data or have potentially updated the data (for example, a delete that does not match any of the rows).
Role:
1. The primary purpose of the binary log is to
MySQL needs to support emoji emoticons version requires greater than 5.5.3, and the character set needs to be set to the UTF8MB4 character set.
What's the difference between utf8mb4 and UTF8? The original MySQL UTF8 a character up to 3 bytes, while
From child querysubqueries in the FROM clauseThe MySQL from subquery refers to the FROM clause as a subquery statement, and the main query to the subquery results to obtain the required data. The FROM subquery syntax is as follows:
SELECT ...
In order to install the MySQL environment test, installed after the discovery of MySQL after the launch of a large amount of virtual memory, up to more than 800 trillion. Online search for a while, get expert advice My.ini. Never see the details
Create a table
The Simple Way
Copy Code code as follows:
CREATE TABLE Person (
Number INT (11),
Name VARCHAR (255),
Birthday DATE
);
Or is
Copy Code code as follows:
CREATE TABLE IF not EXISTS
Method 1: Using the Set password command
First login to MySQL.
Format:mysql> set password for user name @localhost = password (' new password ');
Example:mysql> Set password for root@localhost = password (' 123 ');
Method 2: With Mysqladmin
1. The fields that will be used frequently (such as frequently using these fields for sorting, or for searching), are best indexed.
2. The type of field can be as int or tinyint as possible. The other field uses not NULL as much as possible.
3. Of
One of the problems that you encounter when you deploy your program, the MySQL definition is as follows:
Copy Code code as follows:
CREATE TABLE ' Example ' (
' ID ' INTEGER UNSIGNED not NULL auto_increment,
' Created ' TIMESTAMP
Databases are IO-intensive applications whose primary responsibility is data management and storage. And we know that the time to read a database from memory is a microsecond level, while reading an IO from a common hard disk is at a millisecond
In this chapter, we will learn how to do user authorization and master-slave replication in MysqlHere's a look at the benefits of Mysql master-slave replication:1. If there is a problem with the primary server, you can quickly switch to the service
After you configure virtualenv and virtualenvwrapper, use Pycharm to create a new project. Then the problem to be faced with, has been using SQLite as a development database to learn, according to the principles of the previous tutorial, as if the
Start from here
My blog, what is the background database? Yes, it is MySQL, server-side use of the script is PHP, the entire framework using WordPress. PHP and MySQL are like couples, always working together. Now here, on the collection of PHP,
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