you could dump the data in an .sql file (mysqldump) edit the .sql file to make the necessary changes import the .sql file
----- Original Message ----- From: "McGrotty, Charles" <[EMAIL PROTECTED]> To: "'Tore Van Grembergen'" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 8:38 PM Subject: RE: Making Foreign Keys within MySQL? > my tables are currently MyISAM, > > is it possible to do a dump (inc data) and recreate the tables with the > following? > > DROP TABLE IF EXISTS <table name>; > > CREATE TABLE <table name> ( > <field names> > ) TYPE=innodb; > > INSERT INTO <table name> VALUES ( > <values> > ); > > regards, > Charlie > > > -----Original Message----- > From: Tore Van Grembergen [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 26, 2001 2:03 PM > To: McGrotty, Charles; [EMAIL PROTECTED] > Subject: Re: Making Foreign Keys within MySQL? > > > The only table type at this moment that supports foreign keys is > innodb. > it is distributed with mysql 4.0. > However you need to take the source files or the tar file to instal, the > rpm's have an older version of innodb. > > On creation of the table you have to define your constraints (cf manual at > www.innodb.com) > For the moment it is nog possible to do it with an alter table after the > table is created. > > > ----- Original Message ----- > From: "McGrotty, Charles" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 26, 2001 3:10 PM > Subject: Making Foreign Keys within MySQL? > > > > I realized I made my previous post look like it was a reply and not the > > original question, so here I go again... =o) > > > > Original message below > > ========================================================================= > > > > Hello, > > > > I have tables in a user administration database and need to link different > > tables with FK's for integrity. > > > > How do I do this? > > > > for example: > > > > I have two tables, one called applications, the other called > > forum_moderators. > > > > Applications Catches all form submissions. > > Forum_Moderators hold the details of active/current moderators > > > > I want to link these two tables by rsm_id in applications, and fk_rsm_id > in > > forum_mod's. > > > > How would i do this in MySQL and or PHP? > > > > > > Table Structure: > > for those that need a clearer picture of my layout, I have supplied the > SQL > > statement to create the tables > > > > #-------------------------------------------------------- > > # > > # Table structure for table 'applications' > > # > > > > DROP TABLE IF EXISTS applications; > > > > CREATE TABLE `applications` ( > > `rsm_id` tinyint(4) NOT NULL auto_increment, > > `first_name` varchar(20) NOT NULL default '', > > `last_name` varchar(20) NOT NULL default '', > > `city` varchar(10) NOT NULL default '', > > `state` char(2) NOT NULL default '', > > `dob` varchar(10) NOT NULL default '', > > `forum_nick` varchar(20) NOT NULL default '', > > `forum_select1` varchar(30) NOT NULL default '', > > `forum_select2` varchar(30) NOT NULL default '', > > `forum_select3` varchar(30) NOT NULL default '', > > `bio` blob NOT NULL, > > `email_addr` varchar(100) NOT NULL default '', > > `processed` set('0','1') NOT NULL default '', > > `add_date` date NOT NULL default '0000-00-00', > > `accept_denied` set('A','D') NOT NULL default '', > > `acc_dec_date` date NOT NULL default '0000-00-00', > > PRIMARY KEY (`rsm_id`), > > UNIQUE KEY `email_addr` (`email_addr`), > > UNIQUE KEY `forum_nick` (`forum_nick`), > > UNIQUE KEY `rsm_id` (`rsm_id`), > > KEY `rsm_id_2` (`rsm_id`), > > KEY `forum_nick_2` (`forum_nick`), > > KEY `email_addr_2` (`email_addr`) > > #-------------------------------------------------------- > > > > # > > # Table structure for table 'forum_moderators' > > # > > > > DROP TABLE IF EXISTS forum_moderators; > > CREATE TABLE `forum_moderators` ( > > `formod_id` tinyint(4) NOT NULL auto_increment, > > `name` varchar(40) NOT NULL default '', > > `city` varchar(10) NOT NULL default '', > > `state` char(2) NOT NULL default '', > > `forum_nick` varchar(20) NOT NULL default '', > > `mod_forum_1` varchar(30) NOT NULL default '', > > `mod_forum_2` varchar(30) NOT NULL default '', > > `mod_forum_3` varchar(30) NOT NULL default '', > > `email_addr` varchar(100) NOT NULL default '', > > `tremination_date` date default NULL, > > `fk_rsm_id` tinyint(4) NOT NULL default '0', > > PRIMARY KEY (`formod_id`), > > UNIQUE KEY `formod_id` (`formod_id`,`forum_nick`), > > KEY `formod_id_2` (`formod_id`) > > ) TYPE=MyISAM; > > #-------------------------------------------------------- > > #-------------------------------------------------------- > > > > Regards, > > Charlie > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
