I would like to ask for help as I'm struggling to understand this issue. I have two databases main and backup. Both have same data and views. Main is inside VM on QNAP NAS (v10.5.5) and backup is on same…
In one table I have such column with data Is there possible way to make a query that return this data in this format: _IDS_ 71554 99188 69337 70534 73575 as separate ids that then I can use it for…
I have a model TestDirectory in laravel and test-directory table in mysql. After i manually importing a CSV file in to the mysql table via phpmyadmin, calling TestDirectory::all() is not fetching any data. But previously it was working fine. Any…
I am trying to upload a CSV file to my database in laravel. But my CSV file is pretty big, I almost have 500 million rows that I want to import. (I am using Maatwebsite to do this) And when…
I have 2 tables tableA: id dateA colA ... 1 2022-11-11 12:00:00 A 2 2022-11-12 12:00:00 B 3 2022-11-14 12:00:00 C tableB: id dateB colB ... 3 2022-11-05 12:00:00 D 4 2022-11-06 12:00:00 E 5 2022-11-13 12:00:00 F and I…
TL;DR (i.e. asking the question first): Is there any way to write an INSERT INTO...SELECT FROM...GROUP BY...ON DUPLICATE KEY UPDATE statement using row alias(es) in the ON DUPLICATE KEY UPDATE clause instead of the col1 = VALUES(col1) syntax that has…
I have a Users table (id, name, created_at) and a Transaction table(id, user_id, created_at, amount). For each month, I would like to know the number of users who did not have any transaction in the 3 months interval before that…
I am trying to set an alias name for column challenge_name especially when I encounter 'challenge' based on timestamp/date as challenge 1, challenge 2, etc. If it's not 'challenge' I would like to set the column name the same as…
I have table with 3 columns: ID, Cancellation_Policy_Type Cancellation_Policy_Hours. The query I would like to get to will allow me to select: the min Cancellation_Policy_Hours which correspond to the Free Cancellation (if exists) if the above doesn't exist for the…
Implementing a simple fulltext search I encountered a problem with the combination of boolean mode and phrases. Also worth noting is that the column has a binary collation (utf8_bin) whilst the table does not have this. Given the following setup:…