Re: need help with foreign keys, new to mysql

2005-10-18 Thread Enrique Sanchez Vela
ps, I meant to delete the note from my draft folder... sorry Enrique Sanchez. Enrique Sanchez Vela email: [EMAIL PROTECTED] - It's often easier to fight for one's ||We live in the outer space pr

Re: need help with foreign keys, new to mysql

2005-10-18 Thread Enrique Sanchez Vela
--- Kishore Jalleda <[EMAIL PROTECTED]> wrote: > check the permissions on the mysql data dir, may be > the user mysql or > who ever runs mysql does not have sufficient > privileges > Kishore Jalleda > I agree with Kishore, to elaborate his answer a little longer I would ask the following.

RE: need help with foreign keys, new to mysql

2005-08-24 Thread John Gonzales
Wow, thanks both of you. It worked... =) -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: August 24, 2005 9:17 AM To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: Re: need help with foreign keys, new to mysql Pat Adams wrote: > On Wed, 2005-08-24 at 06

Re: need help with foreign keys, new to mysql

2005-08-24 Thread Roger Baklund
Pat Adams wrote: On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, [snip] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), Here you are defining an index name

RE: need help with foreign keys, new to mysql

2005-08-24 Thread Pat Adams
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: > CREATE TABLE `journal` ( > `journal_id` int(10) unsigned NOT NULL auto_increment, > `journal_category` int(10) unsigned NOT NULL default '1', > `journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP, > `journal_datet

RE: need help with foreign keys, new to mysql

2005-08-24 Thread John Gonzales
: need help with foreign keys, new to mysql Sorry to reply to my own message, but I meant to add that you can read about defining foreign key constrints in the manual <http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html>. [jg.] thanks, this is what I originally based my c

Re: need help with foreign keys, new to mysql

2005-08-20 Thread Michael Stassen
Sorry to reply to my own message, but I meant to add that you can read about defining foreign key constrints in the manual . Michael Michael Stassen wrote: There are a few possibilities here: 1. Both tables must be InnoDb

Re: need help with foreign keys, new to mysql

2005-08-20 Thread Michael Stassen
John Gonzales wrote: i am creating my own little blog and i am trying to create a comments table that uses the primary key of my blog table as a foreign key. i've tried the only two ways that i know how and both ways yielded the same error: #1005 - Can't create table '.\mydatabase\comments.frm'

RE: need help with foreign keys, new to mysql

2005-08-20 Thread John Gonzales
? -jg. -Original Message- From: Thurgood Alex [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 3:22 AM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit : Hi John, > #1005 - Can't

Re: need help with foreign keys, new to mysql

2005-08-20 Thread Thurgood Alex
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit : Hi John, > #1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150) > I've seen this error before. > now before i go and do something stupid, i thought i might ask for some help > on this issue :D both my blog and comm

RE: need help with foreign keys, new to mysql

2005-08-20 Thread John Gonzales
honestly... i don't even know. =( i'm new to mysql... how would i check? -jg -Original Message- From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED] Sent: August 20, 2005 2:18 AM To: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql Yes but is

Re: need help with foreign keys, new to mysql

2005-08-20 Thread Jasper Bryant-Greene
need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales <[EMAIL PROTECTED]> wrote: i am creating my own little blog and i am trying

RE: need help with foreign keys, new to mysql

2005-08-20 Thread John Gonzales
i am logged in as root -JG. -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: August 19, 2005 10:35 PM To: John Gonzales Cc: mysql@lists.mysql.com Subject: Re: need help with foreign keys, new to mysql check the permissions on the mysql data dir, may be the user

Re: need help with foreign keys, new to mysql

2005-08-19 Thread Kishore Jalleda
check the permissions on the mysql data dir, may be the user mysql or who ever runs mysql does not have sufficient privileges Kishore Jalleda On 8/19/05, John Gonzales <[EMAIL PROTECTED]> wrote: > i am creating my own little blog and i am trying to create a comments table > that uses the primary