phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <cheyenne.osanu.for...@gmail.com>
Subject Why does this work in MySQL but not Phoenix
Date Wed, 12 Apr 2017 13:49:18 GMT
I was using this (http://rextester.com/VXZONO82847) in MySQL but I am not
able to use it in Phoenix. Basically what the query does is "select only
one row where a column combination (type and item_id) is common and count
how many more of the combination exists". It allows me to add the following
feature to my notifications system "John Brown and 5 others like your post"

Can anyone answer any of these?

   1. Why doesn't it work in Phoenix?
   2. How can I get that query to work?

Regards,

Cheyenne

Mime
View raw message