JIYIK CN >

In this article, we will explore how to perform CRUD (Create, Read, Update, and Delete) operations using a MySQL database with PHP. If you want to get hands-on experience with database connections in PHP, this article is a good starting poi...

This is a very naive post, and the only reason for writing it is so that I won't forget the syntax and have to Google MySQL REPLACE the order of the arguments to the _ function again. And then when I try to look it up, I almost always end u...

Skeema Is an open source CLI tool that allows us to synchronize MySQL database schemas across multiple hosts. It works on plain SQL files containing CREATE TABLE statements. Database migration is one of the most common challenges during sof...

Full-text search is a database technology that retrieves records even if they do not exactly match our search criteria. This enables rich, natural language searches that feel more familiar. Using full text search to search for "database eng...

请注意 , which is not very secure and should only be used on local development boxes where we don't want to set up personal permissions but still need to connect from other machines. To configure this feature, we need to % update the mys...

Unusually slow queries are one of the most common MySQL performance issues. Queries that perform acceptably in development may falter under the pressure of a production workload. Large applications may run hundreds of unique database querie...

For each database, we should set root the or sa password to something other than the default unless we want to get hacked. For mysql, the system administrator user is called root. We will use the mysql mysqladmin utility from the command li...

One of the best ways to speed up your Web application is to enable query caching in your database, which caches frequently used SQL queries in memory so that the next page that makes the same request is almost instantaneous. What makes this...

By default, MySQL only allows localhost connections from addresses. The configuration file is usually in /etc/mysql/my.cnf We need to bind-address comment out the line so it looks like this: - #bind-address = 127.0.0.1 + bind-address = 127....

Are you using MySQL's utf8 character set in your database ? In this article, I'll explain why you should switch to utf8mb4 , and how to do it. UTF-8 The UTF-8 encoding can represent every symbol in the Unicode character set, ranging from U+...

Comma-separated value files ( CSV ) are a way to transfer data between applications. Databases such as MySQL and spreadsheet software such as Excel both support importing and exporting via CSV , so we can use CSV files to exchange data betw...

A stored procedure can be thought of as encapsulating a SQL statement that we need to process specially into a function. When needed, we only need to call this function to achieve the desired operation. This process can be called a stored p...

This article mainly discusses the implementation mechanism of master-slave replication, which may not be directly helpful for our actual application, but understanding its principle can achieve twice the result with half the effort for futu...

I'm learning about MySQL master-slave replication recently and want to apply it to a project at work. Since I'm new to it, I don't understand it very well, so I can only share how to make a simple configuration. At the beginning, we configu...

We know that there are generally two ways to install software on the Linux system. One is to use rpm or yum to install, which is convenient and fast; the other is to use the compiled source package. Although this method is more troublesome...