4 Articles in the category: Databases

PHP Script to Sync Between Two Different Database Servers - 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 - Byte.Yoga

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 - Byte.Yoga

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

How to Use Microsoft Access from Python - Byte.Yoga

How to Use Microsoft Access from Python

Thu, 18th of November 2021 9:34 PM

If anyone who has done 404 (or already knows some Python) is interested, this is what I did to get my Access database readable in Python. This was the first page I looked at about how...