4 Articles in the category: Databases

PHP Script to Sync Between Two Different Database Servers - Spysafe.com.au

PHP Script to Sync Between Two Different Database Servers

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 - Spysafe.com.au

Insert Multiple Rows in Acceess in One SQL Statement

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 - Spysafe.com.au

Using a Junction Table for a Many to Many Relation in SQL

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 - Spysafe.com.au

How to Use Microsoft Access from Python

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