Thread: SELECT DISTINCT

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    6
    Rep Power
    0
    Hi! I'm kinda a bit of a newbie with mysql but I've managed to get it working okayish on my pc (win98). I am having problems when trying to get a list of cities from a field in one of my tables. I try the following:
    SELECT DISTINCT city FROM table1
    and mysql just seems to shut itself down after hitting me with a dialog that says something about "test signal", have i missed some vital configuration???
    Thanks in advance
    Mich
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    Are you doing this from the command line? what version of mysql are you using?

    i haven't heard of an error like that before. if no one here can answer you, you might want to send the question to mysql@lists.mysql.com. The developers monitor that list and they might be able to provide some more insight. be sure to tell them you're not subscribed to the list, so they will email you answers directly.

    ---John Holmes...
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    6
    Rep Power
    0
    I tried it from a php I did and when it didn't work I tried it from the command line but with the same results

Similar Threads

  1. Replies: 1
    Last Post: January 13th, 2004, 06:14 PM
  2. select distinct problem
    By mrengc in forum MS SQL Development
    Replies: 1
    Last Post: December 23rd, 2003, 07:50 AM
  3. select distinct problem
    By soupman99 in forum PHP Development
    Replies: 2
    Last Post: December 7th, 2003, 08:40 PM
  4. variation of SELECT DISTINCT
    By area in forum MySQL Help
    Replies: 2
    Last Post: November 22nd, 2003, 06:21 PM
  5. Replies: 6
    Last Post: September 2nd, 2003, 11:08 PM

IMN logo majestic logo threadwatch logo seochat tools logo