I’ve been publishing paywall content over on my Kofi Page for the “MySQL Learning Tier” membership mostly in video format. Here is a free post for anyone interested in the type of content you can expect within the membership…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Image by Steve Buissinne from …
[Read more]Where can you find weekly content on all the things PHP, MySQL, the LAMP stack and related frameworks? If you guessed the OpenLampTech newsletter then you’re correct! Let’s dive into this week’s issue…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
I’m including so much original and curated content in these weekly newsletters, it’s a wonder my email service provider can even deliver them lol.
Let’s see what is in store in this week’s OpenLampTech issue #22:
In this blog post, you will learn how to create a MySQL table using the various tools MySQL Workbench provides without typing any SQL code. Continue reading and learn how…
Image by Larisa Koshkina from Pixabay
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
No MySQL Code? …
[Read more]Hey there. Thanks for being here for another issue of the OpenLampTech, the newsletter for PHP/MySQL developers. Plenty of great content in issue #21. Enjoy!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
I learn so much by curating each OpenLampTech newsletter issue. I hope you get as much value out of it as I do in creating it. Here’s what’s in store in …
[Read more]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…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Recently, I published an article over on the OpenLampTech Substack publication page, MySQL SUBSTRING() Function – With Examples, where I cover syntax and examples of the function.
…
[Read more]This 20th issue of the OpenLampTech newsletter marks 5 continuous months of weekly publishing. Thank you, the readers, for making it possible and continuing to read these newsletters. Once again, this week’s issue has plenty of PHP/MySQL content so enjoy the newsletter!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
This week’s OpenLampTech newsletter issue has plenty to read for everyone as I am loading these newsletters up! We are looking at articles covering:
Saturday, I posted how to use Microsoft ODBC DSN to connect to MySQL. Somebody didn’t like the fact that the PowerShell program failed to write a *.csv file to disk because the program used the Write-Host command to write to the content of the query to the console.
I thought that approach was a better as an example. However, it appears that it wasn’t because not everybody knows simple redirection. The original program can transfer the console output to a file, like:
powershell .\MySQLODBC.ps1 > output.csv
So, the first thing you need to do is add a parameter list, like:
param ( [Parameter(Mandatory)][string]$fileName )
Anyway, it’s trivial to demonstrate how to modify the PowerShell program to write to a disk. You should also create a virtual PowerShell drive before writing the file. That’s because you can change the physical directory anytime you want with minimal changes to rest of …
[Read more]This post explains and demonstrates how to install, configure, and use the MySQL’s ODBC libraries and a DSN (Data Source Name) to connect your Microsoft PowerShell programs to a locally or remotely installed MySQL database. After you’ve installed the MySQL ODBC library, use Windows search field to find the ODBC Data Sources dialog and run it as administrator.
There are four steps to setup, test, and save your ODBC Data Source Name (DSN) for MySQL. You can click on the images on the right to launch them in a more readable format or simply read the instructions.
MySQL ODBC Setup Steps
If you have worked with an RDBMS for some time, you will likely
have come across the statement SELECT 1.
However, rarely is it correctly explained to engineers what the origin of SELECT 1 is, and why it’s useless and wasteful? A google search is not going to give you the response you would hope, these ranked responses are just as useless as the statement itself.
Bloat
Seeing a SELECT 1 confirms two things. First you are
using a generic ORM framework, quote, and second, you have never optimized your
SQL traffic patterns.
“Frameworks generally suck.
They CLAIM to improve the speed of development and abstract the
need to know SQL.
The REALITY is the undocumented cost to sub-optimal performance,
especially with data persistence.”
Connection Pooling
SELECT 1 comes from …
A student wanted a better example of writing a MySQL Persistent Stored Module (PSM) that maintains transactional scope across a couple tables. Here’s the one I wrote about ten years ago to build the MySQL Video Store model. It looks I neglected to put it out there before, so here it is for reference.
-- Conditionally drop procedure if it exists. DROP PROCEDURE IF EXISTS contact_insert; -- Reset the delimiter so that a semicolon can be used as a statement and block terminator. DELIMITER $$ SELECT 'CREATE PROCEDURE contact_insert' AS "Statement"; CREATE PROCEDURE contact_insert ( pv_member_type CHAR(12) , pv_account_number CHAR(19) , pv_credit_card_number CHAR(19) , pv_credit_card_type CHAR(12) , pv_first_name CHAR(20) , pv_middle_name CHAR(20) , pv_last_name CHAR(20) , pv_contact_type CHAR(12) , pv_address_type CHAR(12) , pv_city CHAR(30) , pv_state_province CHAR(30) , …[Read more]
