Foreign Key

[Christopher Chamber]

Hi all,  I whould like to know if there is a
way to create Foreign Key╢s between Parent and Child table, I realy dont
know if is it possible to do it and if OK, how will be a simple SQL code
of it.

---
Christopher Chamber
http://gem-hs.org/c.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Outputting Data

[Christopher Chamber]

I have a query:

$QRY = "SELECT * FROM MembersData";

--> Executes fine, no problems.

I have another though:

$DataSet3 = "SELECT * INTO OUTFILE '/www/Export/DataSet3.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY
'\n'
FROM MembersData";

--> This returns an error saying the query is empty.

Any suggestions people...?

 

 
---
Christopher Chamber
http://gem-hs.org/cc.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Two Instances

[Christopher Chamber]

Hi Everyone. My problem is that i want to create 2 instances of a
sub-query. For Example:

SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name
= 'reviews' AND v2.sal = v1.sal ) v3 , v4

This query will gives an error as V4 is not allowed, i.e. not more than 1
instance of a sub-query can be created. Is there a way around this
problem. I would not like to make this sub-query again to get another
instance of it. I need it very much, and if anyone can give me a way to do
it, i would be highly grateful.

Thanks in advance.

---
Christopher Chamber
http://gem-hs.org/cc.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]