Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE functions and the WITH clause…
Latest Blog Posts
MySQL COUNT() aggregate function – Medium cross post
I recently published a blog post over on Medium about the differences in 2 versions of the MySQL COUNT() aggregate function: COUNT(*) and COUNT(column_name or expression). I wanted to share the post here with any readers who may be interested so continue reading for more on this post…
MySQL Aggregate Query using CodeIgniter’s Query Builder
CodeIgniter’s Query Builder ORM has class methods for nearly any kind of database access/operation you can think of. In this post, I’ll cover some of the available methods for retrieving aggregate-level query results. The examples in this post map out Query Builder method chaining to produce results you would get from a raw MySQL query. Continue reading to see more…
(more…)WordPress Contact Form 7: Blog post compilation
Anyone with a website surely needs a reliable contact form to allow visitors and guests to reach out to them. If you are using WordPress, there are more options for contact form plugins than I could fill up in words here in this post. However, one of the more popular and easy-to-configure plugins is Contact Form 7. I recently wrote a couple of blog posts over on Medium detailing how to create a simple contact form using the Contact Form 7 plugin and want to share those posts here on my blog for readers who may be interested…
(more…)MySQL TABLE statement – Example queries
Recently, I learned through some online reading that the TABLE statement is supported in MySQL. I was aware that PostgreSQL supported the TABLE command and used it from time to time. As time went on and I used MySQL more (nothing at all against PostgreSQL) I forgot about the TABLE statement. In this blog post, I’ll cover some rudimentary uses of the MySQL TABLE statement for any other developers who may not be aware that it too exists in MySQL…