I wanted to create a query based on the date, I want to sum the credit and debit based on the year of the transaction_line and display it as total_previous (date within 2021) and total_current (date within 2022). Below is…
I have a table for formula grade where the user can create their own formula using the operator, column, dan number, which I have provided on app UI formulaid tipe formula gradecatid 1 operator ( NULL 1 column PAS 5…
I'm using MySQL and upgrading my application to Rails 7. In doing so, I've to refactor some order-related queries in my scope methods. Before of Rails 7 I was using the following scope method (call it the "original scope method"):…
I am trying to connect from this docker container: version: '3.8' services: vidslide-api: image: php:8.1.17-apache ports: - "80:80" volumes: - ./htdocs:/var/www/html command: > sh -c " docker-php-ext-install mysqli && docker-php-ext-enable mysqli && apache2-foreground " to this docker container: version: '3.8'…
This command echo "mysql -u root nextcloud -Bse 'DELETE FROM oc_filecache WHERE path=""${FILE_PATH}"";'" will show that mysql -u root nextcloud -Bse 'DELETE FROM oc_filecache WHERE path="files_encryption/keys/files/xxx/xxxx/xxx L'AME/2xxxx/OC_DEFAULT_MODULE/master_x626.shareKey";' There is a single quote in the path. When i execute command, this…
Good morning, I am on a MySQL database and I have the following query which extracts data from the last 6 months to today's date : select distinct date_format(abc.date,'%d/%m/%Y') as date_bes from table abc where abc.date BETWEEN CURDATE() - INTERVAL…
When I write a php DateTimeInterface to mysql timestamp field, I always do: $datetime = (new DateTime())->format('Y-m-d H:i:s'); $sql = "... when_inserted = '$datetime'"; I know that DateTimeInterface::format supports Full Date/Time formatting (c, r), but both of them produce a…
I am having a problem with figuring out a MySQL query. The pseudo-code would be like this: table 1 is users table table 2 is a posts table, and I need to select only those users, who had minimum 5…
I have two tables, one is for measurements and every 3 seconds or so a value is written in a very simple structure: Measurements: timestamp value 1679474929 516 1679474933 501 1679474936 505 While the second contains all meta information, trigger…
I want to search if a user submitted comment contains comma separated bad words in the database. Table bad_word: id words 1 foo bar, fooBar 2 aaa bbb, ccc ddd I'm using the following code but it only work for…