Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pymysql ifnull
#5
(Sep-06-2018, 01:01 AM)aland Wrote: I should have group by categories.desc - this fixed the problem
That is strange as you said original one works with mysql ad workbench...
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
pymysql ifnull - by aland - Sep-05-2018, 08:33 AM
RE: pymysql ifnull - by buran - Sep-05-2018, 08:47 AM
RE: pymysql ifnull - by aland - Sep-05-2018, 09:48 AM
RE: pymysql ifnull - by aland - Sep-06-2018, 01:01 AM
RE: pymysql ifnull - by buran - Sep-06-2018, 05:58 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Mysql Syntax error in pymysql ilknurg 4 2,397 May-18-2022, 06:50 AM
Last Post: ibreeden
  pymysql can't do SELECT * Pedroski55 3 2,996 Sep-11-2021, 10:18 PM
Last Post: Pedroski55
  pymysql won't handle some diacritic characters awarren2001AD 0 1,278 Apr-16-2020, 08:58 AM
Last Post: awarren2001AD
  pyMySQL - ROW_NUMBER in SQL statement JayCee 1 2,398 Apr-12-2020, 08:40 PM
Last Post: JayCee
  pyMySQL How do I get the row id JayCee 3 2,734 Apr-12-2020, 08:38 PM
Last Post: JayCee
  PyMySQL return a single dictionary Valon1981 2 1,798 Feb-20-2020, 04:07 PM
Last Post: Valon1981
  pymysql: formating ouput of query wardancer84 18 8,425 Oct-04-2018, 01:54 PM
Last Post: wardancer84
  get last row id in pymysql tony1812 1 11,198 Sep-26-2017, 11:25 PM
Last Post: Larz60+
  pymysql question tony1812 1 2,905 Sep-26-2017, 12:41 AM
Last Post: Larz60+
  pymysql on macos seirra tony1812 5 4,591 Sep-17-2017, 03:24 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020