RE: Confused about syntax for specific join with 3 tables

> Date: Sat, 16 May 2009 15:39:56 -0700 > From: davidmichaelk...@gmail.com > To: mysql@lists.mysql.com > Subject: Confused about syntax for specific join with 3 tables > > I've been doing some experimenting with the data model from the "MySQL" > book (Addison Wesley). I have no trouble under

RE: how to add foreign key in alter command

> Date: Sun, 17 May 2009 14:25:55 +0800 > From: nathan.vorbei.t...@gmail.com > To: mysql@lists.mysql.com > Subject: how to add foreign key in alter command > > Hi guys > Please tell me the command syntax, how to add a colmmen foreign key in > alter syntax > thanks > Hello Nathan, Try

RE: select data from two table and will sort by price in second table

> From: haidarpes...@gmail.com > To: mysql@lists.mysql.com > Subject: select data from two table and will sort by price in second table > Date: Wed, 29 Apr 2009 10:46:48 +0700 > > dear all, > please help us mien for select data from two table with details as follows: > > primery tabel : bookcat

RE: SOLVED! (was: RE: Error : Incorrect key file for table 'X')

> From: ad...@asarian-host.net > Subject: SOLVED! (was: RE: Error : Incorrect key file for table 'X') > Date: Sun, 26 Apr 2009 21:15:15 + > To: mysql@lists.mysql.com > > Okay, I finally got it fixed. I was on the right track going the mysqldump > route, but turns out I had to physically do a

RE: Need help with mysql prob

> Date: Mon, 20 Apr 2009 13:03:14 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi Alugo, > > abdulazeez alugo wrote: > > > > Hi Andy, > > Thank you ver

RE: Need help with mysql prob

> Date: Mon, 20 Apr 2009 08:06:05 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi, > > abdulazeez alugo wrote: > > > >> Date: Sun, 19 Apr 2009 23:19:56

RE: Need help with mysql prob

> Date: Sun, 19 Apr 2009 23:19:56 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi Alugo, > > Hi Andy, > > > > Thanks for your prompt response. However, since tbl1_id has an > > auto_increment valu

RE: Need help with mysql prob

> Date: Sun, 19 Apr 2009 22:50:20 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi, > > Now I have successfully created a relationship between the two tables but > > how do I make sure the value of

Need help with mysql prob

Hi guys, I'm having a really terrible problem with my mysql coding and I'ld appreciate any help I can get on this cause it's really driving me crazy. I have two tables and I've succeeded in creating a one to many relationship between both table but the problem I'm having is that I dont know ho

RE: auto_increment Issue

> Date: Fri, 10 Apr 2009 15:55:33 +0530 > From: jnaneshwar.banta...@kavach.net > To: orasn...@gmail.com > CC: defati...@hotmail.com; mysql@lists.mysql.com > Subject: Re: auto_increment Issue > > Hi > > While trying for the same,I am getting the following error > > Incorrect table definition

RE: auto_increment Issue

> Date: Fri, 10 Apr 2009 15:15:28 +0530 > From: jnaneshwar.banta...@kavach.net > To: mysql@lists.mysql.com > Subject: auto_increment Issue > > > Hi All > > I have created a table.Now I need to make a field Auto_increment...Help > me with this issue..An example will do.. > > Regards > Jnani

RE: PHP-MYSQL Question

Alright guys, I just solved the problem. I read from somewhere that if you're using a foreign key, it should be the either the primary key in the table or the index so since I already used auto increment on table2_id and I've already made it my Primary key, I just made table1_id the index and

RE: PHP-MYSQL Question

I've done that but it still gives the same error message. Date: Tue, 7 Apr 2009 16:25:15 +0200 Subject: Re: PHP-MYSQL Question From: spa...@googlemail.com To: defati...@hotmail.com CC: mysql@lists.mysql.com it is not the ENGINE as Eugene mentioned above, is that you need to use UNSIGNED

RE: PHP-MYSQL Question

l@lists.mysql.com > Subject: Re: PHP-MYSQL Question > > I suppose the problem is that table1.table1_id and table2.table1_id are > of different types. The first one is INT UNSIGNED and the second is just > INT. > > > abdulazeez alugo wrote: > > Table1 is as below: >

PHP-MYSQL Question

Hi guys, Please can anyone tell me what I'm doing wrong with the code below? It keep returning unsuccessful. $result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, table1_id INT NOT NULL, name VARCHAR(100) NOT NULL, school VARCHAR(100) NOT NULL, comment T

RE: PHP-MYSQL Question

t; > What does table1 look like? > > abdulazeez alugo wrote: > > > > Yeah I used the mysql_error and it returned Can't create table > > '.\website\table2.frm' (errno: 150). So what does that say? > > > > > > > > > > > >

RE: PHP-MYSQL Question

ubject: Re: PHP-MYSQL Question > > Perhaps you don't have permissions to create tables? > > It would have been much clearer if your script was like this: > > $result=mysql_query($your_create_table_statement); > if($result){ print"Successful";} > else {print "

RE: One to many relationship

> Date: Mon, 6 Apr 2009 10:07:01 -0500 > From: peter.braw...@earthlink.net > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: One to many relationship > > Abdul, > > Is this what you mean? > > CREATE TABLE Table1 ( > table1_id INT UNSIGNED PRIMARY KEY AUTO INCREMENT, > en

One to many relationship

Hello all, I'm trying to design a relational database where two tables link to each other through unique id sa below Table 1 table1_id INT UNSIGNED NOT NULL AUTO INCREMENT, entrydate TIMESTAMP Table2 table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT, table1_id INT UNSIGNED NOT NULL, entryda