Showing entries 1 to 2
Displaying posts with tag: relation (reset)
Apr
23
2012
MySQL – Alter table-change datatype of column with foreign key
Posted by Kedar Vaijanapurkar on Mon 23 Apr 2012 12:08 UTC
Tags:

Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved. Below is a short example for altering tables having foreign key constraints. SQL for tables used in example: create database temp;use temp; drop table if exists city; drop table if exists country; […]

Jan
18
2011
A many to many relationship table – solving the exclude relation problem
Posted by Ilan Hazan on Tue 18 Jan 2011 12:36 UTC
Tags:

A MySQL many to many relationship is a relationship that is multi-valued in both directions. Given that, how can you select rows that don’t have a specific relationship (the exclude relation problem)? I will start by defining the MySQL Many to Many relationship (Experts can skip to the next paragraph) What is A MySQL many […]

Showing entries 1 to 2