Tagged: MySQL

Nov 06, 2025 MySQL Basics: Don’t Lose It—Backing Up and Restoring Your Database
Nov 04, 2025 MySQL Basics: Safe and Sound—User Management and Database Security
Oct 30, 2025 MySQL Basics: Trust the Process—Mastering Transactions Step by Step
Oct 28, 2025 MySQL Basics: The Inside Track—Speeding Up Searches with Indexes
Oct 23, 2025 MySQL Basics: Count Me In—Aggregating and Grouping Your Data
Oct 21, 2025 MySQL Basics: Join the Party—Bringing Tables Together with JOINs
Oct 16, 2025 MySQL Basics: The Keys to the Kingdom—Primary and Foreign Keys Explained
Oct 14, 2025 MySQL Basics: Turning the Page—Using LIMIT and OFFSET for Pagination
Oct 09, 2025 MySQL Basics: WHERE’s the Data? Filtering Results with WHERE Clauses
Oct 07, 2025 MySQL Basics: Seek and You Shall SELECT—Retrieving Data from Your Tables
Oct 02, 2025 MySQL Basics: Change Is Good—Updating and Deleting Table Data
Sep 30, 2025 MySQL Basics: Filling the Gaps—Inserting Data into Your Tables
Sep 25, 2025 MySQL Basics: Table Manners – Setting up Your First Schema and Table
Sep 23, 2025 MySQL Basics: Getting TYPE-cast – Choosing the Right Data Type for the Job
Sep 18, 2025 MySQL Basics: Into the Shell—Cracking Open Your Database Journey
Sep 16, 2025 MySQL Basics: Understanding the Building Blocks of Databases
May 12, 2025 Without Good Data, AI is Useless
May 08, 2025 AI Features Available in HeatWave Always Free Tier
Apr 09, 2025 Connecting a MySQL Database to an AI Client Using MCP
Mar 27, 2025 Doing a 'Incremental' Dump With MySQL Shell
Dec 13, 2024 Running Drupal using Always Free Resources in Oracle Cloud
Dec 10, 2024 Running WordPress using Always Free Resources in Oracle Cloud
Sep 13, 2024 Creating and Connecting to A HeatWave MySQL Always Free Instance
Aug 29, 2024 Extending MySQL Shell with Plugins
Aug 23, 2024 Extending MySQL Shell with Startup Scripts
Aug 15, 2024 Customizing The MySQL Shell Prompt
Aug 09, 2024 Using MySQL Shell to Get MySQL Diagnostic Information
Aug 06, 2024 Create an InnoDB Replica Set With MySQL Shell
Aug 01, 2024 Copy Data Directly To A MySQL Instance With MySQL Shell
Jul 30, 2024 Using Lookahead & Lookbehind in MySQL Regular Expressions
Jul 25, 2024 MySQL Shell Table Export Utility
Jul 23, 2024 RegEx Backreferences in MySQL
Jul 18, 2024 Using RegEx Subexpressions in MySQL
Jul 16, 2024 A Different RegEx Solution
Jul 11, 2024 More Regular Expressions in MySQL
Jul 09, 2024 MySQL Shell CLI Integration
Jul 04, 2024 Advanced Data Load with MySQL Shell
Jul 02, 2024 Advanced Data Dump with MySQL Shell
Jun 27, 2024 Regular Expressions in MySQL
Jun 13, 2024 Managing MySQL Shell Configuration Options
Jun 11, 2024 MySQL Connection Status with MySQL Shell
Jun 06, 2024 Server Upgrade Checks with MySQL Shell
Jun 04, 2024 Sandboxes in MySQL Shell
May 30, 2024 Getting Help in MySQL Shell
May 28, 2024 Executing System Commands in MySQL Shell
May 23, 2024 Running External Scripts in MySQL Shell
May 21, 2024 Debugging JavaScript Stored Functions in MySQL
May 16, 2024 Sorting JSON Arrays in MySQL with JavaScript
May 14, 2024 More JavaScript in MySQL
May 09, 2024 Using the Global `Intl` JavaScript Object in MySQL
May 02, 2024 Using JavaScript to Search JSON Arrays in MySQL
May 02, 2024 Filtering JSON Arrays with JavaScript in MySQL
Apr 30, 2024 Viewing MySQL Document Store Queries in HeatWave Using Database Management
Apr 26, 2024 Creating a MySQL HeatWave Replication Channel with the OCI CLI
Apr 18, 2024 Creating a MySQL HeatWave Configuration with the OCI CLI
Apr 16, 2024 Creating a MySQL HeatWave Read Replica with the OCI CLI
Apr 12, 2024 Backing up and Restoring a MySQL HeatWave Instance with the OCI CLI
Apr 10, 2024 Listing and Updating MySQL HeatWave Instances with the OCI CLI
Apr 08, 2024 Creating a MySQL HeatWave Instance With the OCI CLI
Apr 04, 2024 Retrieving Reference Lists - Using the Oracle Cloud TypeScript SDK Part 7
Apr 02, 2024 Updating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 6
Mar 13, 2024 Creating a MySQL HeatWave Backup - Using the Oracle Cloud TypeScript SDK Part 5
Feb 26, 2024 Listing MySQL HeatWave Backups - Using the Oracle Cloud TypeScript SDK Part 4
Feb 19, 2024 Waiters - Using the Oracle Cloud TypeScript SDK Part 3
Feb 16, 2024 Managing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 2
Feb 14, 2024 Listing MySQL HeatWave Instances - Using the Oracle Cloud TypeScript SDK Part 1
Dec 17, 2023 Testing MySQL Applications With Java and Testcontainers
Dec 12, 2023 Parameterizing MySQL Queries in Node
Dec 07, 2023 Installing MySQL Innovation Release on a Raspberry Pi
Dec 03, 2023 Applying Database Migrations in MySQL HeatWave With GitHub Actions
Oct 04, 2023 Running MySQL Tests With GitHub Actions
Sep 21, 2023 Integrating DB Migrations Into Your MySQL Tests
Aug 31, 2023 Managing MySQL Database Changes with Knex
Aug 23, 2023 Writing Tests For MySQL Document Store Apps with Node
Aug 11, 2023 Testing MySQL Applications With Node.js and Testcontainers
Jun 30, 2023 Moving MySQL Databases from Azure to OCI Using MySQL Shell
Jun 21, 2023 Moving MySQL Databases from AWS to OCI Using MySQL Shell
Jun 08, 2023 Using MySQL Shell to Dump Data To And Read Data From OCI Storage Buckets
May 22, 2023 Multithreaded Data Dumps With MySQL Shell
Apr 26, 2023 Connecting to a MySQL HeatWave Database Instance Using OpenVPN
Apr 12, 2023 Using Aggregate Functions With MySQL Document Store
Mar 30, 2023 Viewing MySQL Document Store Queries in MySQL Database Services
Mar 15, 2023 Using OCI Alarms to Detect When a MySQL Instance Is Unavailable
Feb 06, 2023 Connecting to a MySQL HeatWave Database Instance Using an OCI Network Load Balancer
Feb 02, 2023 MySQL Document Store - Peeking Under the Covers
Jan 12, 2023 Functional Indexes in MySQL
Jan 10, 2023 Indexing JSON Data in MySQL
Oct 17, 2022 Creating Aliases In MySQL Shell
Oct 07, 2022 Indexing Data in MySQL Document Store
Sep 22, 2022 Importing a MongoDB Into MySQL Document Store with MySQL Shell
Sep 12, 2022 Connecting MySQL Shell Over SSH
Sep 09, 2022 MySQL Shell Alias For PowerShell
Sep 08, 2022 MySQL Window Functions Part 2
Sep 06, 2022 Heading to Raleigh in November
Sep 02, 2022 Speaking in NYC This Month
Sep 01, 2022 MySQL Window Functions Part 1
Aug 29, 2022 Where Have I Been?