Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 25, 2012, 11:34:14 AM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Please Help: Managing MySQL using phpMyAdmin  (Read 1928 times)
morkla
Newbie
*
Offline Offline

Posts: 1
« on: April 12, 2008, 06:47:07 PM »
Dear All,
           I am completely new to MySQL as a Database system. I have an MS Access Desktop Application which I would like to move on-line.

I have so far managed to migrate all the tables to MySQL using the Lunarpages phpMyAdmin Interface.

My next task is to establish relationship among the tables as it was in MS Access. In MS  Access, it's simple and easy to do using the in built gridlines.
I  see no such thing in phpMyAdmin.

I have no idea how to do the same within Lunarpages php Admin functionality. Please help if you have any ideas to help me.

Best regards,
Daniel Morkla
Stockport, United Kingdom
Logged
MrPhil
Senior Moderator
Berserker Poster
*****
Online Online

Posts: 5219
« Reply #1 on: April 12, 2008, 07:05:47 PM »
What kind of "relationship" are you trying to build between tables, with these "gridlines"? Are you trying to define "keys", "foreign keys", "indices", or something else? I don't believe that MySQL table types available on a shared server support foreign keys (InnoDB required?). You would have to add processing code to check the validity of a field used as a key against another table's field values (otherwise handled by a foreign key). Is that what you're looking for?
Logged
Visit My Site

E-mail Me
 
-= From the ashes shall rise a sooty tern =-
bluesektor
Space Explorer
***
Offline Offline

Posts: 8
« Reply #2 on: June 19, 2008, 09:16:22 AM »
Kinda late on this  Smile
Maybe check out sqlyog. They have a free edition that may help you.
http://www.webyog.com/en/
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: