Re: Re: Very complex query
| From: | Martin Marques | Date: | Thu, 11 Dec 2003 18:50:57 +0000 |
| Subject: | Re: Re: Very complex query | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32000@lists.php.net to get a copy of this message | ||
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió:
> You can also DISTINCT command instead.
> UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
> using)
UNIQUE is for table creation or index creation. It is relevent for insertion,
not selects.
DISTINCT and DISTINCT ON() are used in SELECT statements.
--
15:49:01 up 15 days, 22:05, 3 users, load average: 1.12, 0.79, 0.61
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------