3 Articles in the category: SQL
PHP Script to Sync Between Two Different Database Servers
Mon, 20th of December 2021 7:13 PMThis page gives an example of source code in PHP and MySQL which can sync individual data fields between two different MySQL database servers. I use it to update from my LOCALHOST MySQL development server to...
Insert Multiple Rows in Acceess in One SQL Statement
Tue, 7th of December 2021 9:56 PMOK I was soooo close to giving up on this. This works in Access. (Many say its impossible, but we are learning hacking skills here right?) XD. This is the...
Using a Junction Table for a Many to Many Relation in SQL
Tue, 23rd of November 2021 12:09 PMAn associative entity is a term used in relational and entity-relationship theory. A relational database requires the implementation of a base relation (or base table) to resolve many-to-many relationships. A base relation representing this kind...