JIYIK CN >

Current Location:Home > Learning >

All

PHP performs CRUD operations on MySQL database

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

PHP performs CRUD operations on MySQL database

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...

Full

How to replace a string using MySQL query

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

How to use full-text search in MySQL

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

MySql: Grant root user permission to log in from any host

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

请注意 , 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...

Full

How to See Which MySQL Tables Take Up the Most Space

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

How to See Which MySQL Tables Take Up the Most Space

Database backups are one of those things that just keep getting bigger and bigger until they consume all the physical material in the world. Unlike reality TV, we can easily delete things from our databases to make the backups smaller. But...

Full

How to enable MySQL slow query log

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

How to Change or Set MySQL Root Password

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

Speeding up our website using MySQL query cache

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

Switch MySQL to listen on TCP

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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....

Full

How to backup/export a single table from a MySQL database

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

The other day I was testing a feature on my development box when I realized that my local data was indeed out of date and I needed some fresh data from production if I wanted to make any progress with my testing. The problem is that our mai...

Full

How to support full Unicode in MySQL database

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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+...

Full

MySQL switch from utf8 to utf8mb4

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

utf8mb4 Fortunately, MySQL 5.5.3 (released in early 2010) introduced a utf8mb4 new encoding called which maps to proper UTF-8 and thus fully supports Unicode, including astral symbols. Step 1: Create a backup Create a backup of all database...

Full

How to back up a Kubernetes MySQL Operator cluster

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

Oracle's MySQL Operator for Kubernetes is a convenient way to automatically configure a MySQL database within a cluster. One of the key features of the Operator is the integrated automatic backup support for increased resiliency. The backup...

Full

Two ways to install mysql-5.5.47 on Linux system and manage mysql

Publish Date:2025/04/26 Author:JIYIK Category:MySQL

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...

Full

Scan to Read All Tech Tutorials

Social Media
  • https://www.github.com/onmpw
  • qq:1244347461

Hottest

Tags

Scan the Code
Easier Access Tutorial