Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
Citizen99
- Forum Commoner
- Posts: 32
- Joined: Wed Dec 24, 2003 6:52 am
- Location: Where noone understand me...
Post
by Citizen99 »
I have column with 30.000 records and i want to get of repeated records..
SELECT DISTINC column FROM table
doesnt work ? 1054 - Unknown column 'DISTINC' in 'field list'...
Last edited by
Citizen99 on Sat Feb 21, 2004 11:57 am, edited 2 times in total.
-
evilMind
- Forum Contributor
- Posts: 145
- Joined: Fri Sep 19, 2003 10:09 am
- Location: Earth
Post
by evilMind »
You are spelling it like: DISTINCT right?
[mysql_man]DISTINCT[/mysql_man]
-
Citizen99
- Forum Commoner
- Posts: 32
- Joined: Wed Dec 24, 2003 6:52 am
- Location: Where noone understand me...
Post
by Citizen99 »
Now I know what is wrong... everything works fine. THX