Tag Archives: SQL

Python MySql Connector Blob Tutorial

No, Nala, we can’t see The Blob for the 743rd time today. But we can discuss “blob” in terms of MySql database file storage. It’s that, or a bath?! Okay, that’s settled, so make yourself comfortable with your favourite bone … Continue reading

Posted in eLearning, Not Categorised, Operating System, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Polygon Spatial Relations via Image Map Tutorial

It’s “tomorrow” as per … Continuing the theme of PHP using MySql databases and dealing with Spatial functionality of MySql Stored Procedures Geometry Tutorial, today we establish some PHP to add into a MySql database table as POLYGON data type … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Polygon Insert via Image Map Tutorial

Continuing the theme of PHP using MySql databases and dealing with Spatial functionality of MySql Stored Procedures Geometry Tutorial, today we establish some PHP to add into a MySql database table as POLYGON data type data, the HTML area coords … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures Geometry Tutorial

We’re back from rjmprogramming.com.au domain thoughts at MySql Stored Procedures User Grant Tutorial back to thinking more about where MySql is at these days regarding General Geometry Property Functions. This series of functions applicable with MySql SQL DML or “Stored … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures User Grant Tutorial

Yesterday’s MySql Stored Procedures Spatial Tutorial was fully functional for what we wanted to cover on our local MAMP Apache/PHP/MySql web server featuring … PHP 7 … and … mysqli_connect() via 5.7.23 – MySQL … but to offer any version … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

MySql Stored Procedures Spatial Tutorial

Back when we wrote MySql Stored Procedures Primer Tutorial we wrote it more or less to use … PHP 5 and its … mysql_connect() … MySql database connection logic, but today we have a dual (even trial) purpose in mind … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , | Leave a comment

Python MySql Connector Primer Tutorial

In the past we’ve teamed Python (server side language) up with the MySql (database) via a python module called MySQLdb when we presented Python MySql Circle and Point DataTable Primer Tutorial below. Then, we shared the Mac OS X MAMP … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , | Leave a comment

MySql Database on Database Join Tutorial

Why might you want to join two tables from different databases of the same type, that being MySql, today? We can think of … synchronizing two data sources represented by those two database tables, perhaps one updated, one yet to … Continue reading

Posted in Database, eLearning, Tutorials | Tagged , , , , , , , , , , , , , , , , | Leave a comment