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

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

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

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

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

Backing up MySQL isn't hard—you just run mysqldump and output to a file —but it's also not really designed for a production environment. At first, running mysqldump took only a few seconds so everything being locked wasn't a big deal, b...

Backing up your database is a very important system administration task that should usually cron be run from a job at scheduled intervals. We will use mysqldump the dump utility that comes with mysql to dump the contents of the database to...

This article explains how to use MySQL functions with examples CURRENT_TIMESTAMP() . By using it, we can convert or display the current date and time. The output format is "YYYY-MM-DD HH:MM:SS" or "YYYYMMDDHHMMSS", depending on the context...

Previously we explored the master server in master-slave replication. Now let's look at how the slave server works in the entire system. In the article Master Server Exploration, we mentioned that three threads are needed in a master-slave...

This tutorial is an exhaustive guide on how to optimize tables and databases in MySQL. We will be using two operating systems, Windows and Linux (Ubuntu 20.04). It also introduces the importance of optimization in MySQL. When and Why to Opt...

This article will show you how to retrieve the number of records in a MySQL table. We will also show you how to apply conditions to count the rows that meet a certain criteria. Count all rows in a MySQL table To retrieve the count of record...

This article aims to understand how to delete multiple tables in MySQL. Most businesses and organizations that use MySQL to visualize and analyze data have multiple tables to work with. Sometimes, these tables become redundant. In such case...