Please Help: Managing MySQL using phpMyAdmin

morkla

Newbie

Offline

Posts: 1

Please Help: Managing MySQL using phpMyAdmin

« 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

Quantum Encyclopedia Writer

Offline

Posts: 3106

Re: Please Help: Managing MySQL using phpMyAdmin

« 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

bluesektor

Space Explorer

Offline

Posts: 8

Re: Please Help: Managing MySQL using phpMyAdmin

« 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

« previous next »

	Welcome, Guest. Please login or register. Did you miss your activation email?	July 25, 2008, 02:11:07 PM
		Login with username, password and session length