Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Group By problem

forums forums SQLyog SQLyog: Bugs / Feature Requests Group By problem

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #13959
      Medozas
      Member

      Actually maybe just giving a hint: But did you already try

      Quote:
      SELECT count(lcase(email)) as cnt,lcase(email) FROM `np_bieter`where email not null GROUP BY email

      WITHOUT HAVING!!

      give me create-table script so i can experiment, and ill help… or if it works… great! 😕

    • #13960
      nero
      Member

      Hi,

      Wel I tried you sugestion but it was not working.

      Got error 'You have an error in your SQL syntax near 'null GROUP BY email'

      The required result should be when some email was more than 1 time entered.

      But your 'email not null' give me a hint to look a bit closer.

      Also your request for script was not so bad, but its a mail list and some data inside should then also helpfull.

      Some data? 🙁

      Well that was the solution. I am working on a server in germany and at home a mirror in the netherlands.

      Well synchronizing the tables so my local MySQLyog and MySQL CC have the same data as in germany is a

      very good behaviour I think and that was the solution why phpAdmin(in germany after all) worked and the other 2 not.

      Stupid me.

      But many thanks for your reaction, it did help 🙂

      Nero

Viewing 1 reply thread
  • You must be logged in to reply to this topic.