MySQL Gui Insert


#1

does anyone know of some software that lets you insert rows by looking up the foreign key id’s. I am using innoDB with foreign key constraints and it would be sweet if i had an application to pull up the foreign key rows like access does or other db applications. The help is appreciated thank you


#2

check MySQL Control Center. It is not bad.

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].


#3

That program works well for inserting new rows but say i have a table that has the foreign key to a primary table and i want the foreign key to come in as a drop down list in the primary table when inserting. I know I can do it through PHP but then i have to program it all with while loops and that can take a while i have about 5 tables linking together with foreign keys


#4

I don’t know any program which can do this.

But I doubt that the program also needs to achieve this with a loop.

Let’s see what other people suggest. :stuck_out_tongue:

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].