Mysql – Not able to access SQL in vs code using -u root -p
I am trying to access SQL using-u root -p but I am not able to and this is what it's showing -u root -p This is what I am getting -u root -p -u : The term '-u' is not…
Mysql – How to use COUNT for multiple conditions?
I have a data table city like below: City Population Area A 2500000 800 B 990000 400 C 1200000 600 I need to count the number of cities for each of below conditions: Small: Population < 1000000 and area <…
Mysql – How to i sum a column on the last roll of a table in PHP?
I would like to sum the column age as shown on the image below on my table but im not sure how to implement this. i know i would need to use select sum(age) from user but where do i…
Mysql – SQL Query Sum Group by
I have a table similar to structure below table ID EmployeeID factor 1. 100 A 2. 100 B 2. 100 C my requirement is for a given EmployeeID I need to replace the factor with numerical values and sum the…
How to Group 0 with NULL in mysql select
I know there are many variants of this question, but none seem to address my issue. I have a page reporting website order stats. One of the variables it considers is which 'website' a customer used. The website ids are…
Mysql – What is wrong with SQL syntax of my query?
I have such query in my program: SELECT customer.Id, customer.FirstName, customer.LastName, SUM(PeriodHours) AS SUMPeriodHours, PeriodDay FROM ( (SELECT CustomerId, (UNIX_TIMESTAMP(taskinterval.EndDateUtc) - UNIX_TIMESTAMP(taskinterval.StartDateUtc)) / 3600 AS PeriodHours, date(taskinterval.StartDateUtc) as PeriodDay FROM taskinterval WHERE StartDateUtc > @STARTDATE and StartDateUtc<@ENDDATE ) AS tmptbl…
mysql: insert sql was committed but data is not visible immediately
I use MWAA to run my SQL jobs, which are executed on RDS MySQL Community. For example, I start with job 'A', and once it's completed, I proceed to run job 'B'. In job 'A', I use insert SQL to…
Mysql – List out the all messages of user whether it is in sender or reciver by item id
I want the solution like each item id all messages between sender and receiver and need all rows belongs to user i.e. if sender id = 3 and receiver id = 25 then it will list out all message of…
Whether error will throw if we use null date in DATEDIFF() in MYSQL
I have a query to be run in one IAM tool where we are comparing last passwordchangedate and now. i just needs to know whether below query will throw error if we pass null value inside DATEDIFF()? SELECT DISTINCT u.username…
how to sanitze client query to whereFullText eloquent method in laravel
I'm encountering an issue with whereFullText in Laravel. Here's my code: $search_key = $args['q'] ?? $args['search_key'] ?? NULL; $builder->when($search_key, function (Builder $builder, $search_key) { $builder->whereFullText(self::fullTextColumns(), $search_key . self::WILDCARD, [ 'mode' => 'boolean', // [ natural, natural language, query expansion, boolean…