One, mariadb and MySQL
1,MARIADB Introduction
MARIADB, led by MySQL founder Michael Widenius (English: Michael Widenius), had previously sold his company, MySQL AB, to Sun at a price of 1 billion dollars, and since then, as Sun was acquired by
Specific methods
When the SQL where condition equals a string of special symbols, it is easy to make an error, cut off, not even execute, or cause the database to be dangerous.Let's simply test the followingCreating test data
The code
The goal of the index is to improve query efficiency, you can analogy dictionary, if you want to check the word "MySQL", we definitely need to locate the M letter, and then down from the bottom to find the Y letter, and then find the remaining SQL.
The difference between char and varchar
char (13) length fixed, such as ' www.jb51.net ' storage requires space 12 characters
varchar (13) variable length as ' www.jb51.net ' requires storage space of 13 characters,
From the above you can see
Do you remember the last piece of learning? Don't remember to take a look at MySQL learning the fifth day MySQL database basic operation, temperature so you can know new!
Data types are data characteristics of columns, stored procedure parameters,
In MySQL limit can achieve fast paging, but if the data to millions of when our limit must be optimized to effectively achieve a reasonable paging, otherwise may be stuck to your server oh.
When a table data has millions of of the data is a problem!
MySQL download address for all platforms: MySQL download. Select the MySQL Community Server version you need and the corresponding platform.
First, install MySQL on Linux/unixThe Linux platform recommends the use of the RPM package to install Mysql,
High-availability architectures are basically standard for Internet services, both application services and database services need to be highly available. Although the Internet service is called 7 * 24-hour uninterrupted service, but there are some
2.1 Login to MySQL console [username is root, password defaults to NULL]
Switch to MySQL's Bin directory cd D:/wamp/mysql/bin
Login to MySQL Console
Syntax: mysql-h hostname-u username-p
Connecting to another host
Code: Mysql-h 192.168.1.1-u
One:
Php-mysql is PHP operation MySQL Database The most original Extension, php-mysqli I representative of improvement, to mention the relative advanced function, in the case of Extension, itself also increased security. and PDO (PHP data Object) is
stored Procedures , you can think of the SQL statement that we need special processing into a function, when needed we just call this function can achieve the operation we want, this process we can call the stored procedure. Of course, the
MySQL Replace instance description:
UPDATE tb1 SET f1=replace (F1, ' abc ', ' Def ');
REPLACE (STR,FROM_STR,TO_STR)
All occurrences of the string from_str in string str are replaced by TO_STR, which then returns the string
This function is useful
The thread pool is a core function of Mysql5.6, and high concurrent requests are a constant topic for server applications, whether it be Web application services or DB services. When a large number of requests concurrent access, must accompany the
For a long time, PostgreSQL was considered a replacement for MySQL. During that time, however, there was no way to get him to the level that MySQL could achieve. These problems have not been solved in recent years and have produced many interesting
After the MySQL is installed, the MySQL server can start successfully after using the new configuration file, but the error 2002 (HY000) appears when landing: Can ' t connect to the local MySQL server through socket, That is, unable to connect to
When you first build a database with MySQL administrator, the table defaults to the InnoDB type, and you don't care. Later, when using Access2mysql to guide the data found can only lead to myisam type of table, do not know what the difference
Cross-database server, cross-instance access is a more common way of access, in Oracle can be achieved through the way of DB link. For MySQL, there is a federated storage engine that corresponds to it. It is also a way to access data on a remote
In actual development, you will always encounter this situation
or in this situation.
If you're still using the Select fields from table where you like '/% ' is definitely a thankless practice, then it's definitely a priority to study MySQL's
Today research a framework, database using MySQL, start the MySQL service when the 1058 error, the following figure.
Looking for a long time on the internet is the same solution, tried it all not good (only for my local service startup problem is
Due to exporting SQL files
In your original website to use phpMyAdmin to export the database as a SQL file, this step everyone will, do not repeat.
Uploading SQL files
Said earlier, we did not install FTP on the cloud host, how to upload it?
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