Sql - Byte.Yoga

PHP Script to Sync Between Two Different Database Servers

Mon, 20th of December 2021 7:13 PM

This 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 PM

OK 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 PM

An 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...