02-07-07, 06:08 #1Registered User
- Join Date
- Apr 2006
Unanswered: Rookie Questions Using Tool MySQL WorkBench
background info : i've installed the WAMP package for MySQL, Apache , PHP
while i'm able to create tables with PhpMyAdmin I'm unable to create the relationships (that I normally just drag in MSAccess)
I've found that MySQL WorkBench has this, but I can't get it to work on the databases I've created in PhpMyAdmin
bottomline: can anyone help me out on how to create relationships in MySQL
I know it's the 'constraint' thing, but cannot get it to work...
many thanks in advanceOnly quitters quit!
02-07-07, 07:25 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
try using MySQL Admin
Workbench is very much a tool in development.. its hgas a shed load of errors, features not yet implmented.. in short its for test not live development..having said that its looking preety good form what Ive seen so far. But it doens't cut it in a production environment. depending on the version you are usign soem features may work, next release they may not, its very hardware dependant (some video cards work well, some seem to bollux the code).
BTW are you using INNODB tables.. native MySQL doens't support RI.I'd rather be riding on the Tiger 800 or the Norton