Anyone knows answer for this sql question?

|
Swapnil 2022-07-27 16:19:02
Australian keeper ?πŸ˜›
jollikid 2022-07-27 18:03:14
Hello there.
I am struck with this.
Can any one help me out.
I am a second year college student learning programming.
I am able to work with plain language like can say good at python.
Though I am able to write code well, I don’t know, how to jointly work with dB and with the language.
Can any one suggest me a good resource for learning it or any particular approach should I need to be followed for mastering it.
Thanks in advance.
Ishu Gupta 2022-07-27 19:01:54
Ishu Gupta 2022-07-26 08:39:40
Where to find MySQL backup restoration logs whether restoration success or not in MySQL

Please help me here

Ishu Gupta 2022-07-27 19:02:12
Ishu Gupta 2022-07-26 08:40:08
Is there any logs in which we can check MySQL restoration success or failed

Here alsi

Swapnil 2022-07-27 19:35:13
Ishu Gupta 2022-07-27 19:02:12
Here alsi

Check do you have any table know as mysql.backup_progress ?

trilokinathvishnu 2022-07-27 19:55:22
Do anyone have step by step document on logical backup + binary logs restoration?
Janardhan Jan 2022-07-27 20:22:15
Plz help…

I have month column and year columns…want to update from_date and to_date columns based on months and year columns.

For ex: January (month) 2020(year)..update..from_date (2020-01-01) and to_date(2020-01-31)

Ex: February(month)
From_date(2020-02-01)…To_date(2020-02-28)
……and so on

Janardhan Jan 2022-07-27 20:24:45
Janardhan Jan 2022-07-27 20:22:15
Plz help…

I have month column and year columns…want to update from_date and to_date columns based on months and year columns.

For ex: January (month) 2020(year)..update..from_date (2020-01-01) and to_date(2020-01-31)

Ex: February(month)
From_date(2020-02-01)…To_date(2020-02-28)
……and so on

Like calendar

Swapnil 2022-07-27 20:47:42
Janardhan Jan 2022-07-27 20:22:15
Plz help…

I have month column and year columns…want to update from_date and to_date columns based on months and year columns.

For ex: January (month) 2020(year)..update..from_date (2020-01-01) and to_date(2020-01-31)

Ex: February(month)
From_date(2020-02-01)…To_date(2020-02-28)
……and so on

which db ?

Janardhan Jan 2022-07-27 21:05:37
Mysql
Shuham Prasad 2022-07-27 22:00:24
Can anyone send me MySQL dump??
Shahinazizzadeh 2022-07-29 14:06:23
Who can help me about python?
Joseph (Full Stack Developer,Dotnet Core) 2022-07-29 16:05:42
CREATE TABLE Users (
id INT(1) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) NOT NULL,
lastName VARCHAR(30) NOT NULL,
email VARCHAR(50),
)
Joseph (Full Stack Developer,Dotnet Core) 2022-07-29 16:05:56
this is my ttab
how to Convert MySQL query result to JSON
Harun Momin 2022-07-29 19:45:28
I have a table which is having 1 product key to multiple records and there is a model_id which is the same for that particular product_id for multiple records.
Now i want to update that model_id with actual model is for that product.
How I can do that.
AspiringJamesBond 2022-07-29 21:20:41
mysql_en-23261.jpg
why results are not showing
svart 2022-07-29 22:36:00
Joseph (Full Stack Developer,Dotnet Core) 2022-07-29 16:05:56
this is my ttab
how to Convert MySQL query result to JSON

do it on the app side

Swapnil 2022-07-30 09:51:06
AspiringJamesBond 2022-07-29 21:20:41
why results are not showing

What is result of your sub query ?

J_a_i_7 2022-07-30 11:06:12
AspiringJamesBond 2022-07-29 21:20:41
why results are not showing

I think your query not match any of the row in that table..can you show the invoice table data

Vchoudhary12 2022-07-30 19:21:24
sara sara 2022-07-26 17:14:38
Tell me what to type in the terminal instead of this blue line so that I can type exactly what you say in the terminal.

Let me know your username hostname and pswd.. will send exact command

AspiringJamesBond 2022-07-31 05:41:35
Swapnil 2022-07-30 09:51:06
What is result of your sub query ?

mysql_en-23287.jpg
this bro

AspiringJamesBond 2022-07-31 05:44:06
J_a_i_7 2022-07-30 11:06:12
I think your query not match any of the row in that table..can you show the invoice table data

Then it would have showed null values in result bro. Now it’s showing in syntax

AspiringJamesBond 2022-07-31 05:45:02
J_a_i_7 2022-07-30 11:06:12
I think your query not match any of the row in that table..can you show the invoice table data

mysql_en-23289.jpg

Swapnil 2022-07-31 08:47:43
AspiringJamesBond 2022-07-31 05:45:02

Can you just run below query and show result

Select invoice_id, sum(invoice_total)
from sql_invoicing.invoices
Group by invoice_id
Order by 2 desc

sara sara 2022-07-31 12:10:05
Vchoudhary12 2022-07-30 19:21:24
Let me know your username hostname and pswd.. will send exact command

mysql_en-23293.jpg
Is this installed?

Vchoudhary12 2022-07-31 12:17:19
sara sara 2022-07-31 12:10:05
Is this installed?

sudo might not work with cd.. better you change directory first and then run sudo command to install

RobertoSanti9 2022-07-31 14:43:22
Congratulations to me I just received My second profit return without any commission fee or withdrawal fee for those still looking for a legit plantform contact her and thank me later via the link below………..
https://t.me/joinchat/79m_oqJL-Lo2NDM0
AspiringJamesBond 2022-07-31 17:11:08
table A
=====
1
1
1
2
3

table B
=====
1
1
3
4
5

How many records will be there if we apply

1.inner join
2.left join
3.right join
4.cross join
5.left anti join
6.right anti join

suricruise1 2022-07-31 17:20:00
AspiringJamesBond 2022-07-31 17:11:08
table A
=====
1
1
1
2
3

table B
=====
1
1
3
4
5

How many records will be there if we apply

1.inner join
2.left join
3.right join
4.cross join
5.left anti join
6.right anti join

1.7
2.9
3.9
4.25
5.2
6.2

suricruise1 2022-07-31 17:28:56
5.1
AspiringJamesBond 2022-07-31 17:36:17
suricruise1 2022-07-31 17:20:00
1.7
2.9
3.9
4.25
5.2
6.2

how does 2 ans become 9?

suricruise1 2022-07-31 17:38:28
Left means matched records both tables+ unmatched records left table
AspiringJamesBond 2022-07-31 17:47:49
suricruise1 2022-07-31 17:38:28
Left means matched records both tables+ unmatched records left table

is it not 7 matched and one unmatched?

AspiringJamesBond 2022-07-31 18:57:29
mysql_en-23311.jpg
Anyone knows answer for this sql question?
Vchoudhary12 2022-07-31 19:00:15
Can be attained by using concat of first name and Doj (Either use Substr function for getting day and month)
|