I'm looking for information or resources on setting up table relationships in MySQL? I'm familiar with setting up table relationships in Access, but new to MySQL. I apologize for the novice question here?
Thanks for replying my post. I'm completely new to MySQL. Will ASP work okay with MySQL? I always see PHP as the server side language for MySQL. I'm currently just testing out MySQL and want to build a very simple database with two tables, create a relationship between the two tables, make a connection and use ASP write some information to the tables. Easy in Access to do, but I'm struggling with MySQL.
mysql doesn't have an equivalent for microsoft access relationships, which are merely a convenience for generating the query syntax for joining tables (oh, and sometimes for enforcing relational integrity)
in mysql you have to write the joins yourself, and handle the integrity in your app
The above successfully loaded all the files into my mysql db however, all fields inthe mysql db record "Null" except he first field, surid. What shoud I look for to made this worK. I was careful to make the the fields were in idenical order, that the field names were exactly the same, but still no go. Your help would be appreciated. Andy