Posts by Gabriel Lima • 21 points
3 posts
-
0
votes0
answers42
viewsQ: Error installing mysqlclient on macOS with python 3
Error installing on macOS with python 3 pip3 install mysqlclient on macOS iMac-de-Qcx:~ gabrielveigalima$ pip3 install mysqlclient Collecting mysqlclient Using cached…
-
1
votes1
answer199
viewsA: How to group data per week in mysql
I decided by giving the GROUP BY YEARWEEK(DATA,1) - 1 is the first day of the week. SELECT DISTINCT DATE_FORMAT(created_at, '%Y-%m-%d') AS 'Primeiro dia da semana', COUNT(id) AS 'Total' FROM…
-
1
votes1
answer199
viewsQ: How to group data per week in mysql
I am extracting some data and want to know some way to group the data per week. I am giving the SELECT and he’s bringing in last month’s data and I’m already grouping by day, but I need it by week.…