Arrays are one of the most important PHP data types. An array is composed of 1 or more key/value pairs and can store any type (E.g., strings, integers, decimal numbers, etc…). Array values (or elements) are accessed via a key (index), which is either numerical-based or a string-based. Arrays composed of string-based indexes are known as associative arrays. Keep reading for an introductory-level coverage of PHP arrays, as I understand them…
[Keep reading for more MySQL database and Python/PHP-centric content >>>]Programming
MySQL Shell Python mode for multiple ALTER TABLE statements – easily
There may come a time you need to rename one or more columns in an existing MySQL table for a variety of reasons. Using ALTER TABLE, to rename a column is an easy enough command. But, suppose there are multiple tables in the same database/schema that have the same-named column and all of those columns need to be renamed. That could be a lot of ALTER TABLE statements to type out. Save your energy and time, avoiding all of those ALTER TABLE commands all-together. If you are lucky enough to be working with a MySQL version > 8.0 then the Shell is your salvation. With just a few lines of Python code in \py mode, all of your trouble(s) and headache(s) are no more…
Import CSV file data into MySQL table with phpMyAdmin
In the blog post MySQL CREATE TABLE in PHPMyAdmin – with examples, I covered using phpMyAdmin’s visual interface to complete CREATE TABLE tasks. I also mentioned uploading CSV data files to a table using phpMyAdmin in an upcoming post. In this follow-up post, we accomplish uploading CSV files that both do and do not have the column names present in the first row. Continue reading to see the examples…
MySQL DATE Calculations using INTERVAL – with examples
Recently in my day job, while developing the back-end of a reporting dashboard with PHP and MySQL, I noticed some interesting differences in DATE math calculations. The examples used in this post are purely arbitrary but stem from lessons learned, therefore, I feel they are definitely worth sharing…
MySQL Shell CRUD with Python: Read – with examples
In MySQL Shell CRUD with Python: Create – with examples, I visited the
insert() method, demonstrating how simple it is to add new rows of data to a table using Python in the MySQL Shell. Now that the data is stored, if we want to retrieve any of it – for reading – we need to SELECT it, right? Luckily, there is a select() method available we can use in Python mode in the shell, making this operation relatively simple. But, as simple as it is, the power lies in the combinations of other similar class methods used for filtering. Interested? Keep reading…
[Keep reading for more SQL database and Python-centric content >>>]