It’s no secret that text or string data are one of the most common datatypes you will process. At times, only a specific portion of a string may be needed and this is the perfect use case for the SUBSTRING() character function…
(more…)Database Programming
MySQL ALTER TABLE – Add Multiple Columns
I recently needed to add multiple columns to an existing table to store summary data calculations and wondered if I could do it in one MySQL ALTER TABLE statement. Turns out you can. And, it’s super simple. Convenient too. Continue reading and learn what I learned…
(more…)Substack Repost – OpenLampTech issue #19
I’ve once again published a massive issue of the OpenLampTech newsletter, the newsletter for PHP/MySQL developers. If you’re looking to learn more about PHP and MySQL, you’ve come to the right place…
(more…)Limit Rows with the WHERE clause – MySQL Beginner Series
This blog post is an excerpt from premium MySQL Beginner content I am creating to help anyone learn how to use MySQL. Thank you for reading and please do provide feedback.
(more…)10 MySQL Tips For Everyone eBook
I am so pleased to announce that I have published my very first mini eBook, “10 MySQL Tips For Everyone”. Continue reading to find out what it’s about, and how to get your copy.
(more…)