Pivot query in MySQL – Learning by example.

While reading in a fantastic SQL book I frequent quite a bit, I discovered a type of query in one of the examples that I really should know. For a better learning experience, in order to solidly the concepts presented, I applied them to some data that I am familiar with. The topic: pivoting rows of data. Although I am aware of this data presentation, I have never studied a pivot query. ‘So why not learn it then’ I thought to myself. Are you interested in learning about a pivot query also? Continue reading and see an easy-to-comprehend example…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]
Advertisements

Column meta-data in MySQL Shell with Python mode

Meta-data is important to SQL DBA’s and Developers, likely for different reasons. There are all sorts of ways to access meta-data. The powerful MySQL Shell in Python mode is no exception. What if you need the column meta-data on a result set? You can use the get_columns() method and obtain useful meta-data information about it (the result set). All in Python mode. Continue reading to see examples…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]

Export MySQL data to CSV with phpMyAdmin

Comma-separated values files – also known as CSV’s – are one of the most recognized and used data storage/exchange formats. Whether a CSV is the best choice or not remains to be seen. For some data, a CSV is fine. For others, not so much. At some point, chances are someone will need data from a MySQL database in CSV format. That’s not at all difficult and there are several ways to do that. What if you are working in the phpMyAdmin interface? Can you export CSV’s from the phpMyAdmin environment? You sure can. Continue reading to see simple examples of exporting MySQL table data to a CSV file using phpMyAdmin…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]

Use Regular Expressions to gain insight on Content Grouping

Today’s post is a special one and a first-timer here on Digital Owl’s Prose. I am featuring a guest post by Edoardo Frasca.

Let’s meet Edoardo in his own words…

“Hey, I’m Edoardo!
I’m an Italian digital marketing enthusiast living in London.
My professional focus is on marketing, web analytics and data analysis.

After graduating at the School of Management and Economics in Turin (IT), I had to face what a lot of other graduates face: INEXPERIENCE when transitioning from university to work 🙂
That’s why I decided to share a few tips and tricks around highly requested tools like, in this case, Google Analytics.

  • What is working well or not working at all on your website?
  • Which category of products is gaining traction?
  • Are the blog posts just published gaining interest?

I hope you’ll be able to answer some of those questions after reading this blog post, unlock the power of content grouping in Google Analytics!”

Now without any further delay, let’s enjoy Edoardo’s post, Advanced Content Grouping with Regular Expressions .

Thank you, Edoardo for guest-posting on my blog!

Dynamic HTML drop-down with PHP and MySQL

After spending a great deal of time in my day job developing a web reporting dashboard/interface with PHP and MySQL, I feel that I have found my stride in back-end web development with PHP. Learning to develop web applications using the LAMP stack – or one of its derivatives (E.g., WordPress, CodeIgniter, Laravel, etc..) – is a huge focus for me right now. It’s no secret I am a MySQL fanatic – hence this blog – and have written about Python code along with the MySQL Shell a great deal here. However, as it normally goes for developers, the PHP/MySQL back-end web development has inspired me to, of course, start a side project. Go figure right! What developer doesn’t have a side project, or two? Be on notice that you will see more and more PHP/MySQL and LAMP-stack related posts in the future, in addition to the MySQL posts I regularly publish. In the meantime, I’ll share something super neat o (to me at least) I learned while working on my side project. I’m sure it is simple and standard for seasoned web developers, but sparks that exciting, exploratory learning feel for me. Continue reading to see more…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]