Do you think this query semantically wrong or not?

|
alirezahaghi2000 2022-03-14 18:03:17
mysql_en-18690.jpg
hello
this is a simple query to solve a problem but my score is always 0
in problem said the query should execute with MySQL
do you think this query semantically wrong or not?
fozilov_jasur 2022-03-14 18:54:21
alirezahaghi2000 2022-03-14 18:03:17
hello
this is a simple query to solve a problem but my score is always 0
in problem said the query should execute with MySQL
do you think this query semantically wrong or not?

type id, not orders.id

alirezahaghi2000 2022-03-14 19:14:17
fozilov_jasur 2022-03-14 18:54:21
type id, not orders.id

i tried this so and same result

getgoon 2022-03-14 20:38:52
alirezahaghi2000 2022-03-14 18:03:17
hello
this is a simple query to solve a problem but my score is always 0
in problem said the query should execute with MySQL
do you think this query semantically wrong or not?

Order is a keyword in mysql u cannot give it to a table name

getgoon 2022-03-14 20:54:16
getgoon 2022-03-14 20:38:52
Order is a keyword in mysql u cannot give it to a table name

I have seen you have orders so everything is fine about query check the table has data or not

ryryry321 2022-03-14 23:40:56
how to convert created_at a date and time field into week which is starting from saturday ?
getgoon 2022-03-15 06:35:58
ryryry321 2022-03-14 23:40:56
how to convert created_at a date and time field into week which is starting from saturday ?

If u want which day it was u can use dayname() function

Sagar Soni 2022-03-15 07:40:34
Bhai aap muje ye bolo ki AMD EPYC™ 7351P 16C/32T – 2.9 GHz Turbo. 256 GB DDR4 RAM. 2 x 8 TB HDD Storage (RAID-1) ye Wala agar hosting lete hai toh MySQL mai kitna simultaneous connection ho sakta hai Means simultaneous connection limit kitna hai. I think 1lac user can use app in same time means ek saath 1lac user app use Kar sakte hai app same time mai
Sagar Soni 2022-03-15 07:58:43
Bolo yaar
M S 2022-03-15 08:35:03
Hi have index for date_created field but when I querying with where date_created between fromdate and todate it will not using the that index can anyone tell me why it’s not using ?? Thanks in advance
snehakshaylata 2022-03-15 08:35:46
Is there any user whose using node with mysql
ryryry321 2022-03-15 09:18:54
IS THERE ANY WAY TO FIND WEEK OVER WEEK PERCENTAGE GROWTH FOR LAST WEEK ONLY ?
Ranjit1024 2022-03-15 09:22:48
Sum, Count functions not working, Not listed. Help me guys
ryryry321 2022-03-15 18:51:25
u have to setup mysql user and create connection just after that you can see the list of
ryryry321 2022-03-15 18:51:34
mysql databases
ryryry321 2022-03-15 18:51:58
make sure your mysql server is running in my computer
Chandan Chowdary 2022-03-15 18:55:13
Can anyone tell me the solution for the database crash and how to recover data? Need steps with commands
ryryry321 2022-03-15 19:03:48
Chandan Chowdary 2022-03-15 18:55:13
Can anyone tell me the solution for the database crash and how to recover data? Need steps with commands

create a new database

ryryry321 2022-03-15 19:04:00
use that db and create table
ryryry321 2022-03-15 19:04:57
replicate data
ryryry321 2022-03-15 19:05:27
BEGIN TRANSACTION
UPDATE CRS
SET ColA = REPLICATE(‘X’,50)
ryryry321 2022-03-15 19:05:35
like this after that
Chandan Chowdary 2022-03-15 20:21:41
ryryry321 2022-03-15 19:05:35
like this after that

No, I am asking like interview point of view
Imagine that user DB is crashed today at 9 how do you troubleshoot it and how can you bring back all the data like step by step with commands

Chandan Chowdary 2022-03-15 20:21:57
Disaster Recovery also
Chandan Chowdary 2022-03-15 20:33:33
Master down or DB crashed
M S 2022-03-16 10:45:45
how can we find the long running queries in mysql??
Grv 2022-03-16 11:32:57
M S 2022-03-16 10:45:45
how can we find the long running queries in mysql??

Slow logs

M S 2022-03-16 11:35:25
Grv 2022-03-16 11:32:57
Slow logs

No I want to capture only querys which are still running taking time morethan 5m

M S 2022-03-16 11:36:17
So I need to get alert when the process is running so I need to kill it r do smthng required action against
M S 2022-03-16 11:36:20
Like that
Grv 2022-03-16 11:36:43
Use this
Grv 2022-03-16 11:37:36
Set Global long_query_time = 300;
Grv 2022-03-16 11:38:09
300 are the seconds, specify according to your requirement
snehakshaylata 2022-03-16 16:52:47
any node boy here?
MeiNa Lin 2022-03-16 17:03:51
this looks great
|