I am trying to create a query for my website to get the total number of active users for a selected time period and for a specific user account ID to filter for teams. My current query works but without…
I have reinstalled Mysql via homebrew on Mac OS Sonoma 14.6.1 and when I try to run: sudo mysql.server start I get the following error message: 2024-10-09T09:13:17.6NZ mysqld_safe Logging to '/usr/local/var/mysql/.err'. 2024-10-09T09:13:17.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql…
I have 2 tables: book_users and assign_book_users. they look like the image below respectively. id book_id user_id status 1 11 33 open 2 44 54 closed 3 11 98 pending 4 12 33 open 5 23 99 open 6 24…
I have SQL that gets the past 60 days and the sum of view for each of these days and all works fine. I'm trying to take these past 60 days and get the same days view counts from the…
I am using phpMyAdmin that uses MySQL version 5.7. I have a database table called condensed which contains millions of unique emails with multiple "send dates", among other columns. Some of the emails will have a NULL send date. Focusing…
I have the following very simplified situation in a table: datetime id event -------- -- ----- dt01 67 1 dt02 67 2 dt03 106 1 dt04 106 4 dt05 106 2 dt06 654 1 dt07 654 4 dt08 654 3…
I try deleting all the goods, whose type_name starts with D. Let's say I wanna delete goods from the types of dentistry, delicacies, darts_game. So I check whether the type is in the list d_goods_ids (type is a FK of…
I Have a mysql(v8.x) table with 4 Billion records and I need to partition on one of the varchar column. Partition on date column or integer column doesn't work in this case. This is a unique usecase. Partitioning will be…
Anyone knows why this query is returning error? I'm using Laravel Sail with Mysql version: 8.0.32, it should work: Property::select(DB::raw(" properties.id, properties.company_id, properties.title, properties.slug, properties.neighborhood, properties.city, properties.address, properties.number, properties.property_purpose, properties.property_type, properties.total_area, properties.usefull_area, properties.bedrooms, properties.bathrooms, properties.garage, properties.sell, properties.rent, properties.administration_fee, properties.yearly_tax, property_highliteds.hightlight,…
I have a query that gets a count and date from a table. It looks like this: SELECT date(`date`) as 'Date' , sb.`send_id` , count(`id`) as 'SUBS' FROM `table1` WHERE `date` BETWEEN '2024-09-01%' AND '2024-09-30%' GROUP BY date(`date`), `send_id`; This…