MySQL

This article mainly describes how to install the MySQL database correctly in the Ubuntu operating system. We are the best combination of MySQL and PHP) -5.0.40 install the tool correctly in the compiling environment. The following describes the main

Today we will share with you the practical experience on MySQL coding. I have seen some practical solutions on some websites for MySQL coding, however, the feasibility is extremely small, so today we hope you can gain some benefits from your own

In our previous articles, we have explained the first method for the problem of Tomcat and MySQL connection pools, today, we will mainly talk about the problem of Tomcat and MySQL connection pools. Another method is in $ tomcat/conf/server. Add

We all know that forgetting the MySQLROOT password is a very common problem in the use of MySQL databases. Many of our friends are not very familiar with the actual operation of forgetting the ROOT password for MySQL, close up this article to share

This article describes how to create a remote login user for MySQL and install MySQL (red hat 3) in an authorized way, create a remote login user and authorize> grant all PRIVILEGES on discuz. * to ted @ '2017. 123.123.123 'identified by '123

When using MySQL, you must pay attention to security issues.The following are 23 notes for MySQL: 1. If the connection between the client and the server needs to span and pass through an untrusted network, you need to use an SSH tunnel to encrypt

The UPDATE statement is widely used in databases and one of the most common SQL statements. The following describes how to use the mysql UPDATE statement for your reference. Mysql UPDATE statement for a single table: UPDATE [LOW_PRIORITY] [IGNORE]

The MySql stored procedure is a parameter-based stored procedure that dynamically executes SQL statements. The MySql Stored Procedure queries user information based on user input conditions and sorting methods, there is no call Method for sorting

There are different ways to modify the MySQL character set in different environments. The following describes how to modify the MySQL character set in the Liunx environment. If you are interested in this, take a look. Modify the MySQL character set

The MySQL transaction should be defined by every MySQL database user. The following describes how to define MySQL transactions, which is helpful to you. By default, MySQL runs a COMMIT statement after each SQL statement is executed to effectively

How does MySQL user permission be granted to users? Next let's take a look at the process of granting MySQL user permissions together with an instance. Instance granted MySQL user permissions:Mysql> grant select, insert, update, delete on test. user

MySQL uses the alter table statement to modify the TABLE structure. The following describes how to modify the TABLE structure Statement of MySQL. Modify Table Execute the alter table statement for MySQL to modify the TABLE structure. It mainly

Mysql bin log files are common log files. The following describes an instance for clearing the sh of mysql bin log files. It is helpful for you to learn about mysql bin log files. DELLOG=”/usr/local/logs/del-sqlbin.log.`date +%d`”  

MySQL Databases may sometimes encounter data faults. This requires us to back up the MySQL database and restore the database. The following describes how to back up the MySQL database for your reference. 1. ib_logfile0 and ib_logfile1 are the log

MySQL stored procedures are frequently used. The following describes the connection between MySQL stored procedures and databases in detail. If you are interested in MySQL stored procedures, take a look. 1. to convert a TABLE from one type to

The MySQL authorization system is implemented by five tables in the database. The following describes the tables related to the MySQL authorization system in detail. If you are interested, take a look. One of the features of the MySQL server is that

The importance of the MySQL field to the MySQL database does not need to be repeated. The SET in the MySQL field is described in detail below. If you are interested, take a look. SET) Mysql> create table jihe (f1 set ('F', 'M '));Query OK, 0 rows

The MySQL string addition function is a commonly used function. The following describes the actual operation scheme of the MySQL string addition function. If you are interested in the MySQL string addition function, take a look. We all know that in

I believe that MySQL strings are familiar to everyone. MySQL string sorting often encounters some problems, such as the following: Today, we have solved a strange problem about MySQL string sorting. The varchar type is defined in the data, and the

MySQL StorageIt is a very important task in MySQL database operations and is also applied to everyone's daily work. Parameters cannot be defined during stored procedures.Character SetTherefore, when a stored procedure is called, the global variable