New: mysqlAll contenthive-129948hive-196917krhive-185836steemhive-166405hive-183959zzanuncommonlabhive-180932hive-150122photographybitcoinhive-188619hive-144064hive-183397hive-145157lifehive-113376hive-193186hive-101145hive-124908hive-109690krsuccesshive-139150TrendingNewHotLikersfederico-r (37)in database • 2 days agoIt’s never too late to celebrate! Get 20% OFF any purchase!On Devart’s 27th Birthday, they’ve made the prices for any of their products extra affordable to ensure that you can join them! Use the promo code to purchase anything with a 20% discount…federico-r (37)in mysql • 2 days agoHow to Show Views in MySQLManaging and viewing database objects, especially views, is crucial for effective database management. Views provide data abstraction, making complex queries more straightforward and reusable, while…federico-r (37)in mysql • 10 days ago20% OFF for dbForge Studio for MySQL. Limited Time Offer!If you work with MySQL or MariaDB regularly, you know how important it is to optimize query performance and how easily you can get stuck when you need to export or import data, design a database for…aserdd (28)in cn • 13 days agoMYSQL 时间格式 DATE_FORMAT() 函数用法记录MYSQL 时间格式 DATE_FORMAT() 函数用法记录 转换为天 DATE_FORMAT(`date`, '%Y-%m-%d')federico-r (37)in mysql • 20 days agoMySQL String Functions in ActionWhat’s so special about MySQL? Why do most developers choose this relational system for managing databases? MySQL is widely used primarily because it’s based on the Structured Query Language (SQL)…fangwei (59)in study • 25 days ago【MySQL】04. 事务管理（三）：MVCC多版本并发控制（MVCC，Multi-Version Concurrency Control）提供了一种不同于传统锁机制的解决方案，通过维护数据的多个版本，依据特殊的版本比对规则，每个事务仅能看到符合其读视图的数据版本，以此实现 读不加锁、读写不冲突 的效果，在确保事务的隔离性和一致性的同时，更提高了数据库的并发性。 1 快照读与当前读…fangwei (59)in study • last month【MySQL】04. 事务管理（二）：锁机制在之前的章节中，我们详细探讨了事务的ACID属性以及事务隔离级别的概念，理解了事务如何在并发环境中保持数据的一致性和完整性。本章我们将进一步深入事务管理的核心——锁机制，它是事务隔离级别的基石，也是实现数据库并发控制的关键。 1 锁分类 在数据库中，锁是一种用于控制并发访问的机制，它确保了数据的一致性和事务的隔离性。锁主要分为以下几类： 1.1 从性能角度划分 乐观锁…federico-r (37)in mysql • last monthComprehensive review of dbForge Studio for MySQLdbForge Studio for MySQL is a powerful IDE for MySQL and MariaDB from Devart, an industry leader known for its database development tools. This article will discuss some of its features that…fangwei (59)in study • last month【MySQL】04. 事务管理（一）：ACID与隔离级别在多用户数据库环境中，事务的ACID属性与隔离级别是确保数据一致性和操作安全性的关键。本文通过介绍事务的原子性、一致性、隔离性和持久性，以及常见的并发问题如脏读、不可重复读和幻读，结合MySQL四种隔离级别（读未提交、读已提交、可重复读、串行化）的实操演示，旨在帮助读者理解和掌握如何在不同的业务场景下，有效利用事务隔离机制，构建稳定可靠的数据库应用。 1 事务ACID属性…fangwei (59)in study • last month【MySQL】03. 日志体系在MySQL的世界里，日志不仅仅是记录系统活动的简单工具，它们更是确保数据一致性和可靠性、优化性能、以及辅助问题诊断的关键组件。本文将介绍MySQL日志体系的精髓，从核心的日志类型到它们各自的作用、工作原理及相互间的协作机制，为你揭示MySQL背后复杂而精妙的设计。 1 核心日志 1.1 binlog（查询日志） binlog全称为binary log，是MySQL…federico-r (37)in devartacademy • last monthNew Free Course at Devart Academy: “Mastering MySQL and MariaDB With dbForge Studio”!Dive into the world of MySQL and MariaDB with Devart's comprehensive new course! Whether you're a beginner or a seasoned pro, this course covers everything from design and development to management…federico-r (37)in mysql • last monthEnhance Your MySQL Code with Free Online Syntax CheckerMySQL Syntax Checker is designed to help you beautify your code and introduce unified code style standards for developers. Experience the convenience and efficiency of this tool online! For a…fangwei (59)in study • 2 months ago【MySQL】02. 索引机制（四）：索引设计原则1 索引设计原则 1.1 代码先行，索引后上 等到主体业务功能开发完毕，把涉及到该表相关sql都要拿出来分析之后再建立索引。 1.2 联合索引尽量覆盖条件 比如可以设计一个或者两三个联合索引（尽量少建单值索引），让每一个联合索引都尽量去包含sql语句里的where、order by、group by的字段，还要确保这些联合索引的字段顺序尽量满足sql查询的最左前缀原则。…federico-r (37)in mysql • 2 months agoHow to Export and Import a MySQL Database Using the Dump or IDEData import and export tasks, being an integral part of database management and operation, are vital for software and database developers, as well as data analysts, and many other IT…federico-r (37)in mysql • 2 months agoMySQL TutorialWelcome to MySQL Tutorial , tailored for both beginners and seasoned professionals. Dive into the core of MySQL, a leading relational database management system that empowers users with SQL, the…federico-r (37)in mysql • 2 months agoMySQL Select DatabaseChances are that you have multiple databases on the MySQL Server instance you're connected to; and when you need to manage several databases at once, you need to make sure you have selected the…fangwei (59)in study • 3 months ago【MySQL】02. 索引机制（三）：Explain详解在 MySQL 中，explain 命令是一个非常有用的工具，它可以帮助我们分析查询语句的执行计划，从而了解 MySQL 是如何执行查询的。通过 explain 命令，我们可以获取到查询语句的执行顺序、使用的索引、表的连接方式等信息，这些信息对于优化查询性能非常有帮助。…fangwei (59)in study • 3 months ago【MySQL】02. 索引机制（二）：索引匹配在 MySQL 数据库中，索引是一种用于提高查询性能的数据结构。正确地使用索引可以大大加快数据的检索速度，而不合理的索引使用则可能导致性能下降。本文将详细介绍 MySQL 索引机制中的匹配规则，帮助读者更好地理解和优化索引的使用。 在正式介绍前，读者可以先执行下面内容，方便大家更好地理解和验证文中的示例（注意：以下示例皆是以MySQL8.0为基础）： CREATE TABLE…federico-r (37)in mysql • 3 months agoHow to list the users in a MySQL/MariaDB database and Manage PermissionsUser management involves granting database access, setting user permissions, and monitoring activities. This process, traditionally handled via command-line utilities, includes creating, modifying…federico-r (37)in mysql • 3 months agoA Single Killer Feature You Need For Collaborative Database Development: Source Control For MySQLDatabase development is a complex process that requires quality planning, technical skills, experience, and collaboration. Regardless of the project scope and the development team size, efficient…
