OpenLampTech issue #18
MySQL events; PHP WordPress errors; Free MySQL Ebook; PHP login and authentication; MySQL query optimization; Ordering NULL values
Hey glad to have you here! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
10 MySQL Tips For Everyone - Ebook Promotion
This week I published my very 1st ebook, "10 MySQL Tips For Everyone". In this short guide, I'm sharing some basic tips for working with the MySQL database. Receive a free copy when you subscribe to the OpenLampTech newsletter.
If you're already a subscriber, you should have received an email from me with the information to download your copy.
If not, reach out to me directly for the necessary information.
Recently from the Digital Owl’s Prose blog and OpenLampTech publication
I published, MySQL String Concatenation with CONCAT(), over on the Digital Owl's Prose blog. Read this post for more information on one of the handiest string functions.
Discover 5 Developer/Programming-related newsletters I'm reading that I think you should also be…
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ Create or Schedule Event Job in MySQL or MariaDB
By: Smart Wave of Technology
#mysql #mariadb
I've not had to ever use a EVENT
for anything (yet). I tend to focus more on developer-related tasks vs those of a DBA.
This post provides a solid foundation on EVENT
syntax, specific example queries to verify EVENT
information, and global EVENT
settings.
Sample EVENT
s are demonstrated to solidify EVENT
use and structure.
✔️ How to Order NULL Values First or Last in MySQL?
By: Daniyal Hamid
#mysql
There is plenty to learn about the NULL
value of MySQL. In this post, we see the nuances of sorting columns with NULL
values and how their default sort order is in comparison to non-NULL
values.
There are specific operators we can use in the sorting column order to impose an ordering to our liking with the ORDER BY
clause.
Learn all about them and how to use these operators in the MySQL ORDER BY
clause.
✔️ PHP LOGIN AND AUTHENTICATION: The Complete Tutorial (2019)
By: Alex Web Develop
#php #mysql
Don't let the date in the title fool you any because this blog is as relevant as ever. This is a complete and thorough guide covering best practices and file structuring for PHP login and authentication.
Some topics covered in this fantastic blog post are:
PHP sessions
MySQL Database structure and connection
Exception handling
Updating existing accounts
Much more
This is another bookmarkable article for anyone working with PHP. 🔖
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don't know where to start. Learn more about my premium MySQL blog posts and content as I develop and release them, in addition to an actionable MySQL tip each week.
✔️ How to use PHP with MySQL: the complete tutorial (with examples)
By: Alex Web Develop
#php #mysql
It seems like most blogs and articles covering PHP and MySQL connectivity are based on only 1 of the 2 available PHP drivers for MySQL (normally the one being used).
However, this blog post includes a working example for both MySQLi and PDO (with procedural and OOP style for MySQLi).
Need a detailed guide on,
MySQL connectivity and use with PHP?
Prepared statements and query execution?
Query results retrieval and processing?
Look no further...
✔️ How to Fix “Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress”
By: Kinsta
#php #mysql #wordpress
Kinsta always has good blogs and articles to help you troubleshoot errors and issues on your WordPress site. They cover 2 reasons you could be receiving this error and a few remedies for each one of them.
One hidden lesson I take away from all of the content I read similar to this one, keep your PHP version updated.
✔️ Steps to create schema in MySQL
By: Vignesh
#mysql
Simple and easy-to-follow instructions on creating a MySQL database using MySQL Workbench. Laid out in a numbered set of steps, once the SCHEMA
is created, we then follow the same pattern for creating a table.
No thinking is involved when following along with articles like this.
My favorite kind...
✔️ Fill in missing Date ranges using MySQL
By: Joshua Otwell
#mysql
I'm realizing the more I use them, the more I like Common Table Expressions (CTEs). They are powerful and simplify the queries by moving a lot of the results set - often used in Derived Tables and subqueries - to a space that can be accessed multiple times in the same query.
I learned so much about CTEs and many of the MySQL Date functions in writing this post. Not to mention, I had a gang ton of fun too. 🙂
✔️ From Hours to Seconds: A Tale of SQL Query Optimization
By: Karen Trubovitz
#mysql
Hours-long query execution.
Indexes being used. Two range-based filter conditionals in the WHERE
clause. Diagnosing long-running queries.
There is a ton of great information in this post.
I really need to buckle down and learn all of this query optimization stuff.
⭐⭐⭐ Many of the posts I curate and share in this newsletter, I read and enjoyed on Medium. If you are not yet and member and wish to join the platform, I would be more than grateful if you would use my sign-up link. At no extra cost to you, I will receive a small portion of your membership fee when you sign up. Thank you! 🙏
Support OpenLampTech, my blog, and my work with a coffee if you would like.☕
Newsletter Shout-out 📣
Extra stuff…
Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!
“Reply” or comment and let me know what you think of this issue of OpenLampTech.
What do you want to see more of?!?
What do you want to see less of?!?
I’d love to know!
Also, share with me links to your published blogs and articles so that I can read them and possibly include them here in the newsletter!
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and products links in this email are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.
Cover photo creds: Image by Mudassar Iqbal from Pixabay