New: mysqlAll contenthive-129948hive-196917krhive-150122hive-180932zzanhive-188619hive-166405hive-185836steemhive-144064hive-101145hive-183959hive-183397uncommonlabhive-103599photographyhive-139150hive-170554hive-180301hive-145157bitcoinhive-109690steemithive-184714TrendingNewHotLikersfederico-r (37)in sql • 9 days agoWhat’s New in dbForge 2025.1: 5 Key Updates for Smarter Database ManagementdbForge 2025.1 is here — and it’s designed to optimize, accelerate, and future-proof your daily work with SQL. 🔹 1. dbForge AI Assistant — Your smart, integrated SQL copilot Meet your SQL…federico-r (37)in aggregatefunctionsmysql • 14 days agoAggregate Functions in MySQL: What They Are, Examples, and Best PracticesFor developers, analysts, and database professionals working with MySQL, mastering aggregate functions is non-negotiable. A comprehensive guide published by Devart provides a thorough breakdown of…federico-r (37)in mysql • last monthHow to Drop Tables in MySQL Using dbForge Studio: A Simple Guide for Safer Table ManagementLearn how to drop a table in MySQL quickly and safely using dbForge Studio for MySQL — a professional-grade IDE designed for MySQL and MariaDB development. Whether you’re looking to delete a table…federico-r (37)in mysql • 2 months agoMySQL Subqueries GuideSubqueries in MySQL are very useful when data manipulation gets complicated. MySQL is among the most powerful and widely used relational databases. Still, retrieving the exact data you need can…ramkrishna (28)in mysql • 4 months agosteemCreated with Sketch.Extracting a table create and insert statements with data from .SQL file#Introduction Recently, we embarked on a migration project for an application built with CakePHP, which supported PHP 7.4. While the initial stages were smooth, we faced a challenge when we…kr-dev.cu3 (49)in hive-137029 • 4 months ago[by @talkit] 포스팅큐레이션, 자바이야기 014. 전자정부 프레임워크용 MySQL DDL 생성하기원본 글 보러가기 : 포스팅큐레이션, 자바이야기 014. 전자정부 프레임워크용 MySQL DDL 생성하기 작성자 : @talkit 미리보기 (5 sentences) 안녕하세요. 가야태자 @talkit 입니다. 공통 컴포넌트까지 잘 추가 하셨죠? 자 그럼 여러가지 설정 파일을 수정 해보겠습니다.…justyy (83)in witness-category • 4 months agoSteem Transfer Snapshot Updated for Download (MySQL Zipped): 93377828 Blocks (27-Feb-2025), File Size: 8.6 GBI usually provide a snapshot of the transfer records (SBD and STEEM) at the April every year. However, recently, as I was migrating the server to colocrossing dedicated server , I needed to take…maxweb (34)in php • 6 months agoПро очищення бази даних від "зайвого"При створенні будь-якого вебсайту іноді виникає необхідність виконання деяких команд для підтримання "чистоти" бази даних. Зазвичай йдеться про завершені сесії користувачів, прострочені запити або…federico-r (37)in mysql • 7 months agoHow to Rename a MySQL DatabaseWhen working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in earlier…federico-r (37)in mysql • 7 months agoExplore the Power of dbForge Tools for MySQL and MariaDBIf you're working with MySQL or MariaDB, having the right tools for development and administration can make all the difference. Designed for database developers, architects, DBA, analysts, DevOps…federico-r (37)in mysql • 7 months agoHow to Migrate MySQL Database to Amazon RDS or AuroraAmazon cloud storage offers a scalable and secure way to keep and access data across multiple devices. As to Amazon RDS (Relational Database Service), it provides automated backups, software…federico-r (37)in mysql • 7 months agoHow to Check MySQL VersionWhy do you need to know your MySQL version? In some situations, it is critical to know what the current MySQL version is as particular features might not be compatible with your system. Also, the…federico-r (37)in mysql • 8 months agoHow to Restore a MySQL Database with Command Line or Restore ToolsThere may be situations when data gets lost or corrupted, for example, when users accidentally deleted or overwrote data. For these reasons, it is recommended to make a backup on a regular basis.…federico-r (37)in mysql • 8 months agoCheck History of Executed Queries in MySQL Easily!The MySQL Query History feature in powerful MySQL IDE - dbForge Studio helps developers and DBAs track past queries, troubleshoot issues, and optimize performance. It provides quick access to…federico-r (37)in mysql • 8 months agoMySQL INSERT Statement – Inserting Rows Into a TableThe INSERT statement is used to add data to a table. The INSERT INTO command inserts one or multiple rows into a MySQL table. Depending on the number of rows you want to add, the syntax slightly…federico-r (37)in mysql • 9 months agoHow to Enable, Configure, and Use MySQL Query LoggingWhat is the purpose of query logging in MySQL? Why is it important? How do you enable and configure it? This article addresses these questions and more. You will find a detailed guide on how to use…federico-r (37)in mysql • 9 months agoMySQL INT (INTEGER) Data Types With Different ExamplesIn MySQL, INTEGER (INT) is a numeric value without a decimal. It defines whole numbers that can be stored in a field or column. In addition, MySQL supports the display_width attribute (for example…krishu-g (77)in mssql • 9 months agoUnderstanding the Key Differences Between MySQL and MSSQLIn the database world, MySQL and Microsoft SQL Server (MSSQL) are two of the most widely used database management systems. Both systems serve similar functions: managing and storing data in…federico-r (37)in mysql • 9 months agoEnhance MySQL and MariaDB Workflow With the Latest dbForge EdgeDevart has announced the release of dbForge Edge (v3.1), a comprehensive multidatabase solution that empowers users with a suite of powerful tools designed to streamline database management…federico-r (37)in mysql • 9 months agoBoost Your Database Efficiency: dbForge Studio for MySQL v10.1 and Mini-Tools Deliver New FeaturesDevart has released an updated product line of dbForge Tools for MySQL v10.1, including dbForge Studio for MySQL – an all-in-one solution for MySQL and MariaDB database development, design…