DBIx::...:mysql(3pm)

🌸 NAME 🌸

DBIx::SearchBuilder::Handle::mysql — a mysql specific Handle object 💅

---

✨ SYNOPSIS ✨

okay so bestie... there is genuinely nothing here. no code block, no usage line, nada. the SYNOPSIS section is just vibes and empty space 🫶 we move.

---

🦋 DESCRIPTION 🦋

So this module is a subclass of DBIx::SearchBuilder::Handle, and its whole entire job is to compensate for some of the idiosyncrasies of MySQL. Like, MySQL is doing its own thing and being a little quirky, and this module is the bestie who shows up and smooths everything over so you don't have to deal with it. no cap 💖

---

👑 METHODS 👑

💫 Insert

Takes a table name as the first argument, and then just assumes the rest of the arguments are an array of key-value pairs to be inserted. periodt ✨

If the insert succeeds, it returns the id of the insert. If it doesn't? You get a Class::ReturnValue object with the error reported, so you can see exactly what went wrong 😭 no silent failures here, we don't do that.

---

💫 SimpleUpdateFromSelect

This is a customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. The tea ☕: Mysql doesn't support update with subqueries when those fetch data from the table that is updated. Like, it literally refuses. so this handles that for you 🫶

---

💫 DatabaseVersion

Returns the mysql version, trimming off any -foo identifier. clean. minimal. iconic 💅

---

💫 CaseSensitive

Returns undef, since mysql's searches are not case sensitive by default. so yeah, it just hands you undef and keeps it moving 🌈

---

💫 SimpleDateTimeFunctions

Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle. cute little hash ref, all the datetime functions you need 🎀

---

💫 ConvertTimezoneFunction

Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

Wanna get the list of timezones? run this query right here, copy it exactly bestie:

SELECT Name FROM mysql.time_zone_name;

And if you wanna read docs about keeping timezone data up to date, here's the link, literally copy-paste it:

http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html

---

💫 QuoteName

Quote table or column name to avoid reserved word errors. bc MySQL WILL fight you over a column named order. ask me how I know 💀

---

💫 HasSupportForCombineSearchAndCount

MariaDB 10.2+ and MySQL 8+ support this. so if you're on one of those, you're slay. if you're not... welp 🙈

---

and that's the whole page bestie, you ate it, you read it, you're literally the main character of this documentation now 💜

---

this page came from perl v5.40.1 and it's dated 2026-05-07 — user contributed perl documentation, so go off 🎀✨