Loading
Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Everything on MySQL, not only its articles: the MySQL page →
Learn how to choose between MariaDB vector search and a dedicated vector database based on data volume, filtering, transactions, scaling, and operational complexity.
Learn how to identify and safely remove unused MariaDB indexes using index statistics, index definitions, and EXPLAIN to improve write performance and reduce storage use.
Learn how to use MySQL invisible indexes to test the impact of removing an index, review execution plans, and avoid performance regressions before deletion.
Learn how to shard a MySQL orders table by user ID, route requests with logical shards, generate unique IDs, handle reporting, and rebalance from four to eight shards.
Learn how to diagnose MySQL replication lag, distinguish event retrieval from application delays, find slow queries and transactions, and monitor replica status.
Learn how to use MySQL read replicas with Laravel, handle replication lag and read-your-writes consistency, and plan for queued jobs, replica failures, and primary failover.
Discover how to count repeating character patterns in strings using MySQL. This tutorial provides a step-by-step guide with code examples for text analysis and pattern recognition.
Unlock MySQL performance! Discover why table locking occurs during heavy traffic, impacting speed. Learn to optimize InnoDB, indexing, and transactions for scalability.
Explore the key differences between SQL and MongoDB databases. Understand data storage, schema flexibility, relationships, scalability, and ideal use cases. Perfect for students and interview prep!
Optimize slow MySQL queries with multiple joins! Learn indexing, EXPLAIN, filtering, and join strategies for faster performance. Boost database efficiency now!
Learn simple and effective ways to optimize MySQL queries in Java applications. Understand indexing, query design, JDBC best practices, connection pooling, and real-world performance tips.
Learn how to improve MySQL query performance in Java applications using indexes, prepared statements, connection pooling, batch processing, caching, and EXPLAIN.
Integrate MySQL into your .NET application using Docker! This tutorial covers setup, DbContext creation, connection strings, and EF Core migrations. Build a robust e-commerce backend!
Effortlessly install MySQL 8.0 on Windows Server 2019 with our step-by-step guide. Learn to configure, verify, and manage your database server for optimal performance and security.
Learn about dropped connections, aborted queries, and the potential for MyISAM table corruption. Discover safer alternatives like health checks, off-peak scheduling, and MySQL configuration tuning to avoid frequent restarts and ensure data integrity. Minimize downtime and prevent application errors!
This SQL stored procedure automates local database backups and replicates all tables to a remote server with suffixes, ensuring disaster recovery, reporting, and schema sync—no manual table handling required.
Learn how to connect to a MySQL database over a local area network (LAN) using SQL Workbench. This guide covers finding the IP address of the MySQL server, configuring it for remote access, setting up firewall rules, and establishing a connection from a client machine.
MySQL BLOB datatypes store large binary objects, like images or documents. They offer efficient storage for multimedia files and other binary data in MySQL databases, enabling seamless handling of diverse content types within applications.
In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for both novice and experienced developers.
Explore MySQL's diverse use cases in web applications, e-commerce, CMS, data warehousing, telecommunications, and finance. Dive into its key features, architecture, and crucial queries for efficient database management.
In this article, we are going to describe the MySQL cursor and how to declare, open, fetch, and close it. In MySQL, a cursor is a database object that provides a way to retrieve and manipulate multiple rows of data in a result set. It allows you to process a set of rows returned by a query one at a time, similar to how you might handle data in a programming language loop. Cursors are particularly useful when you need to perform row-by-row processing or when you want to control the retrieval of data explicitly.
In MySQL, the UNION operator is used to combine the results of two or more SELECT queries into a single result set. The UNION operator allows you to stack the rows returned by each query on top of each other, effectively merging the results. It is essential to note that the number and data types of columns in all the queries involved in the UNION operation must match, or at least be compatible.
Learn the differences between MySQL DELETE, TRUNCATE, and DROP statements, including their syntax, effects on table data and structure, and key behaviors.
Here we will learn how to handle null values and null values functions in MySQL.Handling null values in MySQL is an important aspect of database management, as null represents the absence of a value in a particular field. Dealing with null values properly can ensure data integrity and smooth operations. Here are some common methods to handle null values in MySQL:
This article describes general information about the database and provides help for these commands.
In MySQL, index is a data structure .It improves the functionality of the table operations.
In this article we will learn how to import a database table into Excel in a MySQL server.
In this article, we will discuss the working process of DDL, DML, and DCL in MySQL.These are some of the most commonly used SQL commands that allow you to perform various operations on the data stored in a database. Understanding and using these commands effectively is essential for working with relational databases and managing data efficiently.
Write an article and earn +1,000 SHARP when it is approved.
Write an article
