MySQL Tutorials

Here are 5 steps to migrate MySQL database to MariaDB database on Debian Linux server. After completing the following 5 steps, no other changes are required, and production continues as usual.

This article describes how to install MySQL 8.0.11 on the command line of Ubuntu 18.04, Ubuntu 16.04 Server. If you want to install 8.0.14, you can also use the method mentioned in this article.

The following describes the installation of MariaDB 10.4 on Ubuntu 18.04 system, and also applies to Ubuntu 16.04 system. We can install MariaDB 10.4 on Ubuntu from the APT repository.

Solution: 1. Table change method. It may be your account does not allow remote login, only localhost. This time as long as the localhost that computer, log in mysql, change the "mysql" database "user" table in the "host" entry from the "localhost" renamed "%" mysql-u root-pvm ...

Use MySQL, security issues can not fail to pay attention. The following are 23 tips for MySQL tips: 1. If the client-server connection needs to cross and pass an untrusted network, then you need to use an SSH tunnel to encrypt the connection's traffic. 2. Set password statement to modify the user's password, three steps, first "mysql-u root" landing database system, and then "mysql> update mysql.user set password = passwor ...

The following is the command line import sql data, you need friends can refer to the next. My personal practice is: phpmyadmin export utf-8 insert mode abc.sql ftp abc.sql to the server ssh to the server mysql-u abc-p use KKK (database name, if not create database KKK) set names' utf8 'source abc.sql ...

History of the most complete MySQL backup method, you need friends can refer to the next. I have used the backup methods are: mysqldump, mysqlhotcopy, BACKUP TABLE, SELECT INTO OUTFILE, or backup binary log (binlog), can also be directly copied data files and related configuration files. MyISAM table is saved as a file, it is relatively easy to back up, several methods mentioned above can be used. Innodb all the tables are ...

In fact, previously wrote a solution phpmyadmin unable to import large files, however, some things, if not thoroughly, or there will be a large number of users do not understand how to operate. So I only tell the steps below, no longer speak any principle, it turns out that any principle, understand people do not need to see, do not understand people they will not see, even if the principle is very simple. Consider using the king of empire backup can ignore this article, but the method is still worth learning about. First of all in the original phpmyadmin mysql database in two steps derived in two steps to export the first step: export data ...

Can not remotely log in to the MySQL database Solution 1: Try to use the MySQL Adminstrator GUI Tool Login MySQL Server, Server but reply error message: Host '60 -248-32-13.HINET-IP.hinet.net 'is not allowed to connect to this MySQL server This is because of competence problems, the treatment is as follows: shell ...

The following article is mainly about the specific method of implementing a simple and practical optimization of the MySQL database, as well as what specific steps in the actual operation are worthy of our attention. The following article describes the MySQL database is a simple practical optimization of the specific methods to achieve, including how to conduct regular table analysis and inspection, and how to properly optimize the table on a regular basis, the following is a description of the specific program, I hope in your future Learning will be helpful. 1, regular analysis table and checklist analysis table syntax is as follows: ANAL ...

MySQL Chinese wrong order solution / * The method has been changed to the character set of the field gbk, and then the order by order can be used directly. For example, change "name char (10)" to "name char (10) binary" by adding the "binary" attribute to the field containing Chinese and setting it as binary. ". If you make ...

Simple mysql tutorial grouping statistics statement instance code / id name code_id code_name is_true score 1 Zhang San 1 handsome is 5 2 Zhang San 2 lavish is 4 3 Zhang San 1 handsome is 4 4 Zhang San 2 lavish no 3 5 Li Si 1 handsome Is 5 6 Li Si 2 lavish is 3 to see an instance mysql grouped by name statistics: [handsome] how many ...

CREURN DEFINER = `root` @` localhost` FUNCTION `UF_Get_tMaxCode` (V_iType INT) RETURNS varchar (10) CHARSET utf8 BEGIN / * Description of business: Generate encoding based on encoding category Input Parameters: V_iType :coding...

Now we take a look at mysql_fetch_field () function, this function is to read mysql table name, field name. Here we take a look at the syntax of it mysql_fetch_field (data, field_offset) mysql_fetch_field () function is The recordset returns the .mysql_query () function and returns either success on an object, or FALSE or fails when he has two parameters ... Data ...

How to List All Databases for a mysql Server mysql_db_name Definition and Usage The mysql_db_name () function assumes that the mysql_list_dbs () function is called from the database name. This function returns the success of the database name, or FALSE failed. Syntax mysql_db_name (list, row, field) list Required. Result pointer specified mysql_list_dbs () function row required ...

sql query special does not include the date of the data sql = "select * from test where dates not in (# 2010-05-03 #, # 2010-05-12 #)" date format before and after plus plus # Can be found not include # 2010-05-03 #, # 2010-05-12 # all the data, look at a more stupid way 'sql = "select * fro ...

In the mysql tutorial on Chinese sort is a more interesting question, especially for the field is uft-8 or not gbk, gb2312 field type is Chinese sort out there is a problem, let's look at an example. create table `test111cnnet` (& nbsp; ...

Either in the pitiful free database space or large e-commerce sites, reasonable design table structure, make full use of space is very necessary. This requires that we have a full understanding of the commonly used MySQL data types for database systems. Now I will write down my little experience to share with you. The numeric type of the MySQL data type The numeric type is divided into three categories according to my classification: integer classes, decimal classes, and numeric classes. My so-called "digital class" refers to DECIMAL and NUMERIC, which are the same type. It is strictly speaking not ...

This article mainly introduces the practical steps of character (string) in MySQL database. We all know that the character (string) of MySQL database is often used in practice, so you know more about it is still good Hopefully this will bring you some help in this regard. MySQL database character (string) class Do not think that the character type is CHAR CHAR and VARCHAR difference is that CHAR is a fixed length, as long as you define a field is CHAR (10), no matter whether your stored data reached 10 bytes , ...

I now need to remove the latest content from each category as follows: select * from test group by category_id order by `date` The result is as follows. This is not the data I want, because msyql has the order of execution is the order of reference write: select ... from ... where .... group by ... having ... order by .. Execution order: ...