WHERE CSV_File = 'ICS'
-> AND CHAR_LENGTH(PRACT_NUMBER) > 4
-> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1
-> AND Booking_ID = 6030
-> GROUP BY PRACT_NUMBER;
ERROR (HY000): Invalid use of group function
mysql>
Can anyone tell me why this is happening?
B
mysql> SELECT PRACT_NUMBER,
> -> COUNT(SUBSTRING(PRACT_NUMBER, 1, 4))
> -> FROM CSV_Upload_Data
> -> WHERE CSV_File = 'ICS'
> -> AND CHAR_LENGTH(PRACT_NUMBER) > 4
> -> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1
> -> AND Book
'ICS'
-> AND CHAR_LENGTH(PRACT_NUMBER) > 4
-> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1
-> AND Booking_ID = 6030
-> GROUP BY PRACT_NUMBER;
ERROR (HY000): Invalid use of group function
mysql>
Can anyone tell me why this is happening?
Because you ca
_NUMBER) > 4
-> AND COUNT(SUBSTRING(PRACT_NUMBER, 1, 4)) > 1
-> AND Booking_ID = 6030
-> GROUP BY PRACT_NUMBER;
ERROR (HY000): Invalid use of group function
mysql>
Can anyone tell me why this is happening?
Thanks for your advice
--
MySQL General Mailing List
For