Category Archives: Database

A database is an organized collection of data ( Wikipedia )

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

MySql Down Thinking Followup Tutorial

When we discussed Linux Watchdog Primer Tutorial in that very generic fashion below, we were being that … generic. Today we turn to specifics in that regard. On the rjmprogramming.com.au domain we use a … (software) watchdog which checks for … Continue reading

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

LibreOffice Spreadsheet via dBase Primer Tutorial

When we presented the blog posting thread ending with Dams in the United States Timeline Tutorial its data basis had the same origin as today’s, that being the wonderful United States data resource website data.gov website. From there we got … 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