Hi Folks, Here are some easy questions I hope you can answer. I have been creating innoDB tables in mysql, creating contraints and foreign keys and it runs swimmingly.
The server I am now doing mySQL on won't allow me to create other than myISAM tables. Is it true that only innoDB tables support Foreign keys constraints? Is there an alternative to FK contraints for myISAM tables? Is there something I can configure (locally) to allow the creation of innoDB tables? If what i suspect is true, that myISAM tables don't cater for FK contraints, then there usefulness is lost on me. Why have a database if you can't keep the information linked / accurate?! (I'm sure myISAM does have an upside, don't flame me ;) ) Cheers Paul.
