Mysql – In SQL Selecting Specific Dates(Recurring)
If I have dates Column and i want to select dates of monday and sunday only from past 1 year, how can i do it with effective code in SQL I tried to select manually the dates but its very…
Find text in JavaScript similar Like MySQL
I have the following code in JavaScript: const words = ['Bruno Nobre', 'José Bruno', 'Bruno Ricardo', 'Antônio Bruno'] const searchValue = (data) => data.filter(i => i.startsWith('Bruno')); const values = searchValue(words) console.log(values) Its return will be: ['Bruno Nobre', 'Bruno Ricardo'] Similar…
how do I get value of a column from join table when search item is sent laravel
I have two tables users and categories. users table has a foreign key linked to categories table. categories table has 2 columns id and name I want to get the value of name when a search_item is sent if(!empty($request->get("search_item"))) {…
Mysql – Select MAX () and GROUP BY … Missing link between columns
I am still at beginner level on SQL programming so please bear in mind ... My database is similar to the below: +---------------------+------------+--------+------+--+ | Date | FileName | Type | File | | +---------------------+------------+--------+------+--+ | 2023-06-15 08:03:04 | InputParam |…
Mysql query for employee assignments when peer(s) are absent
I have a mysql table with the following structure: Assign Pri Sec Ter Qua 21 Tom Mark Sally Tammy 60 Sally Ace Tom Mark 170 Mark Sally Ace Tammy 220 Ace Tammy Tom Sally 17 Tammy Sally Mark Ace 439…
how to perform arithmetic operation on string in MySQL?
I have values like below in dealer_price(type string) field: | dealer_price | | -------- | | 1000.00| | 5000.00| | Contact for pricing| | 10000.00| I have queries something like below to perform arithmetic operation: select (dealer_price + 10) AS…
mysql query string get 2 counts from selects
i'm trying to create a query that allows me to get 2 counts from selects. I have a table (name "warehouses") with the following design and data: nation city italy roma germany berlin italy roma france paris italy torino italy…
MySQL UPDATE with JOIN failing
update loan l inner join ( select LoanId, sum(Amount) as Amount from loanpayment where LoanId = pLoanId ) as lp on l.Id = lp.LoanId set l.CurBalance = OriginalAmount + TermMonths *(OriginalAmount * MonthlyRate/100) - coalesce(lp.Amount,0) where l.Id = pLoanId ;…
Mysql – Spring Boot – Timestamp's datetime string is shown in local timezone instead of UTC on select
My entity has a java.sql.Timestamp field: @Column(name = "expires_at") private Timestamp expiresAt; The table also has a default column updated_at, which is dynamically set on insertions/updates (i.e it is not set through JPA): updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,…
I can't install mysqlclient with pipenv
I'm trying to install "mysqlclient" package for my Django project. I'm on a virtual envrioment. When I enter this command pipenv install mysqlclient I get this error: Traceback (most recent call last): File "/home/reza/.local/share/virtualenvs/store-api-wAMLFNlP/bin/pipenv", line 8, in <module> sys.exit(cli()) File…