I can reconstruct the original database ...
My question is: Does any one have any recommendations of a process I
could use to do this effectively ?
Many Thanks in advance
Traiano Welcome
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
use distinct() instead.
- Original Message -
From: "AVDHUT SHEDGE" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 3:00 PM
Subject: Regarding SQL query with Unique
> We want to get the Unique value from a table.
> can we use the following query:
>
> select uniq
it means it allow multiple records have same value in a table. i.e. It allow
index to contain duplicates.
it really is not a key. it is a kind of index instead.
if you have a table using a primary key say table_a, try to use "SHOW INDEX
FROM table_a", then "SHOW INDEX FROM ACCOUNTING". you can s
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
here says that mysql does not support sub-selects thus you see errors.
also here shows you that how to rewrite sub-selects.
- Original Message -
From: "Nicolas Villatte" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
S