MySQL

DBExpress added by Delphi6 is used to deal with Mysql, DB2, Interbase, Oracle and other databases.Copy the file to the current directory or system directory (98: system, NT: system32), and ensure that your port 3306 is consistent with the remote

Nearly half a year after Sun's acquisition, what impact does Sun have on the open-source world? The founder of MySQL stood up to answer questions. When Sun acquired MySQL, an open-source database vendor, for $1 billion at the beginning of this year,

The following articles mainly describe three common types of MySQL numbers. We all know that whether it is a small free MySQL database space or a relatively large e-commerce website, for related databases, it is necessary to reasonably design the

The following articles mainly describe the actual configuration skills of the MySQL database. We all know that the remote service started by the relevant root user is a secret of security, the main reason is that if the related service program has

The following articles mainly introduce the actual operations of MySQL commands frequently used in MySQL databases, including how to correctly connect to the MySQL database on the local machine and how to change the password correctly, the following

The following articles mainly discuss several common methods for MySQL root password cracking. For the purpose of insurance, we copied three copies, if we have not changed the table structure in the MySQL database to be restored, just copy the user.

The following articles mainly introduce the practical operation solutions that allow MySQL to support Chinese characters. MySQL to support Chinese characters is also favored to some extent as MySQL databases are generated, the following is a

The following articles mainly describe the usage of MySQL left join, right join, and inner join) detailed analysis of the following articles is mainly to explain the actual operations in the form of an instance demonstration, the following is the

The following articles mainly introduce the specific operation scheme of MySQL string connection functions. We will take the concat function in MySQL database as an example to describe in detail, the following describes the specific operations of

This article mainly introducesMySQLDatabaseStorage EngineMySQL has multiple storage engines: MyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB), EXAMPLE, FEDERATED, ARCHIVE, CSV, and BLACKHOLE. MySQL supports several storage engines as

Last time we introduced: suitableBeginnersMySQL learning notes table operation example. Here we will introduce someMySQL databaseManagement experience, Next let's take a look at this part of the content. In Windows, MySQL exists as a service. Before

Author: Tie Date: January 1, December 27, 2013 For more information, see install MariaDB using YUM in Centos. Note: First, you must be able to connect to the Internet. If you cannot directly access it, You can also set a proxy. For details, refer to:

Some people asked me how to add a serial number field in the absence of a continuous id in mysql, so that the queried data contains numbers 1, 2, and 3. Let's look at the method below. In the following simple sentence, you can add the serial number

This article introduces the Plugin InnoDB registration as a storage engine failed solution. I hope this article will help some friends who encounter such problems. The Innodb ENGINE was not installed on a database. We added it dynamically today and

Using binary log backup and database restoration in mysql is a relatively advanced database backup operation method. enable the mysql-bin function in ini. I will introduce it later. Basic Concepts Definition: The binary log contains all statements

If you forget the mysql password, there is almost no good way to directly change the password, but we can go to my. in ini, add skip-grant-tables, and restart mysql without the password. Then, modify the root password, and delete and restart

In mysql, user permissions are a deep learning. If you improperly set database permissions, the database on the entire mysql database server may be exploited, let's take a look at the mysql user and permission management settings. 1. Basic

The usage is as follows: Copy codeThe Code is as follows: mysql> load data local infile "D:/AB .txt" into table mytbl (name, age ); Using the preceding command, you can import the content of the D:/AB .txt file to mytbl. the nameand ageare the

Table partitions are only recently known. I used to split tables to achieve hundreds of millions of data records. Let's introduce how to create and use mysql table partitions, I hope this will help you.Test and use of table partitions. The main

1. Preparations Download mysql's latest free installation unzip mysql-noinstall-5.1.53-win32.zip, decompress to the relevant directory, such as: d: \ mysql-noinstall-5.1.53-win32. This is the root directory of mysql. 2. Configuration There are