Tag Archives: SQL

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

WordPress Blog Posting Generic Misspelling Fix Tutorial

Let’s start out as “devil’s advocate” for today’s WordPress Generic Misspelling Fix project, that has a large amount of synergy with the “content” emphasis of WordPress Blog Posting Thread Content Summary Tutorial. What are some things to beware of when … Continue reading

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

NetBeans Java RESTful Message Board Update Tutorial

Yesterday’s NetBeans Java RESTful Message Board Primer Tutorial had us set up a Message Board web service application in Java and built via the NetBeans IDE. Did the look of its functionality remind you of the basics of SQL DML … Continue reading

Posted in Ajax, eLearning, Event-Driven Programming, Tutorials | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Python MySql Circle and Point DataTable Primer Tutorial

When we’ve talked about the MySql database in the past, apart from going on and on and on and on and on and on about the wonders of the phpMyAdmin MySql management tool frontend, we’ve normally talked about it regarding … Continue reading

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

SQL for Flat Files Supervisory Tutorial

Though we could add many more web applications that use our Flat Files SQL Engine (in a child HTML iframe element scenario) we’re feeling a bit “onions of the 4th dimension” about all this, and we think we can encase … Continue reading

Posted in Database, eLearning, Event-Driven Programming, Projects, Tutorials | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

SQL for Flat Files Data Type Tutorial

Do you recall a statement in this blog posting thread’s “primer” tutorial as per … data type “smarts” … we’re keeping it really “everything ends up as a string” … doh … simple, for now, with our flat file data … Continue reading

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