MySQL

I. Mode 　　   Ii. stored procedures and functions Syntax: Create procedure sp_name ([proc_parameter [,...]) [Characteristic...] routine_body Create function sp_name ([func_parameter [,...]) RETURNS type [Characteristic...]

Here, we will introduce the exclusive threads used in MySQL memory. The exclusive thread memory is mainly used for various client connection threads to store exclusive data for various operations, such as thread stack information and grouping and

A few days ago, I encountered a strange problem in the management system. Today I have the opportunity to install the MySQL environment to reproduce this problem. Because it is not the most primitive environment, it may not be completely reproduced,

The MySql stored procedure described below is a stored procedure with parameters (dynamic execution of SQL statements). This MySql Stored Procedure queries user information based on user input conditions and sorting methods, there is no call Method

I. Importance of Indexes The index is used to quickly find rows with a specific value in a column. If no index is used, MySQL must start with 1st records and read the entire table until related rows are found. The larger the table, the more time it

In practical work, regular database backup is extremely important. When using MySQL, we have a lot of options for database backup. This article will introduce you to how to use MySQL mysqldump to back up the database. 　　I. Importance of Data

The fix command I used is myisamchk-r bbsthreads.Among them, bbsthreads is the name of the table with a problem. Of course, you have to use this command to enter the storage path of the table in the database with a problem in mysql. For more

1. the MySQL view operation is only supported by the new version of the database. The advantage of the view operation is that it can simplify the query of the database. In particular, we can create a view for some frequently queried data tables

The backup of MySQL database is one of the most important tasks. The data backup of MySQL database can achieve absolute security of data in MySQL database, and the data in MySQL database will not be lost due to any minor faults, automatic backup is

1. Connect to the mysql server of the other party Mysql-u root-h 192.168.0.1 Mysql.exe this program is in the bin directory where you have installed mysql 2. Let's take a look at some databases on the server. Mysql> show databases; By default, mysql

I set the root password for mysql I just installed yesterday. Today I cannot get in.I used a common solution. As follows:1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). The files that store the process ID are

Mysql Master/Slave always has an error in the function process. Analysis of MySQL function creation problems:According to the system prompt, the cause of this error may be a security configuration. The log_bin_trust_function_creators parameter in

In short, the table id cleared with truncate will be from the new record, while the table cleared with delete will not continue with the original data record from the new record. Of course, the id here is self-increasing==============================

  Mysql5.5 uses the new configuration tool cmake. Therefore, during compilation and installation, make sure that cmake has been installed in your system, the redhat system can be viewed using rpm-qa | grep cmake. Another simple method is to directly

The Health section of MySQL Administrator displays the real-time status of the MySQL server in graphically monitor mode. Some status diagrams are shown here. Of course, you can easily create your own status diagrams and combine them into custom

Perform Two-layer development and use mysql for database.Based on your experience and the methods provided by colleagues on the network, you can remove unnecessary files and create a mysql mini version. It is very convenient to use, with a size of 5

Recently, mysql managed by myself experienced slow query. In order to be able to query slow query SQL statements, mysql's slow query log is started, you can use either of the following methods to start a slow query:1. log on to mysql directly and

If you want to know the space occupied by each table in the MySQL database and the number of rows recorded in the table, you can open the information_schema database of MySQL. There is a TABLES Table in this database. The main fields of this table

Mysql in the production environment is upgraded from 5.0 to 5.1 today. An error is returned in the result log, as shown below:Event schedaliz: An error occurred when initializing system tables. Disabling the Event Scheduler.Mysql. user has no 'event

I found that an SQL statement such as order by rand () is convenient, but the efficiency is too low. So I used the following methods to optimize it, the JOIN table method is used to obtain random data rows. You can use the explain SQL statement to