Victor Subervi wrote:
On Wed, May 19, 2010 at 10:59 AM, Shawn Green wrote:
Shawn Green wrote:
AH! that's your mistake. You think that creating the FK will also create
the column. That does not happen. You have to define the table completely
before you can associate the columns on this table (t
On Wed, May 19, 2010 at 10:59 AM, Shawn Green wrote:
> Shawn Green wrote:
>
> AH! that's your mistake. You think that creating the FK will also create
> the column. That does not happen. You have to define the table completely
> before you can associate the columns on this table (the child table)
Victor Subervi wrote:
On Tue, May 18, 2010 at 2:23 PM, Shawn Green wrote:
Shawn Green wrote:
I may be confused but how can the ID of the Passengers table be both the ID
of the Flight they are taking and their Customer ID at the same time?
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-k
On Tue, May 18, 2010 at 2:23 PM, Shawn Green wrote:
> Shawn Green wrote:
> I may be confused but how can the ID of the Passengers table be both the ID
> of the Flight they are taking and their Customer ID at the same time?
>
> http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.h
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 10.5,
a Windows GUI solution for MySQL administration and database
development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
New features:
---
1
i said: ignore!
But did it work?
;-)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelo