Hi experts, do anyone have any code to extract sql from binlog?

|
MasterZiv 2021-12-20 14:29:46
I_am_3ngineeR 2021-12-20 14:28:49
The example also contains the subqueries, so I also want to use subqueries too. But thanks for your suggestion, I will check the JOIN again.

doesn’t matter, add subquery if needed.
But correct JOIN

I_am_3ngineeR 2021-12-20 14:30:05
thanks, I will check it πŸ‘
I_am_3ngineeR 2021-12-20 14:41:01
MasterZiv 2021-12-20 14:29:46
doesn’t matter, add subquery if needed.
But correct JOIN

mysql_en-14989.jpg
Thank you so much, I saw that I made easy mistake πŸ˜‚

MasterZiv 2021-12-20 14:41:59
I_am_3ngineeR 2021-12-20 14:41:01
Thank you so much, I saw that I made easy mistake πŸ˜‚

this is correct.

I_am_3ngineeR 2021-12-20 14:42:25
yes, it worked. Thanks again
Dondeti97 2021-12-20 20:09:16
Hii, Every One. I have a Request For Freshers jobs in IT plz Inform Mee.
Ram12333 2021-12-20 21:19:50
hi experts, do anyone have any code to extract sql from binlog?
snehakshaylata 2021-12-20 21:52:49
Any one can solve my problem
snehakshaylata 2021-12-20 21:53:03
With nodejs express with mysql
snehakshaylata 2021-12-20 22:07:42
mysql_en-15008.jpg

svart 2021-12-21 00:14:59
Ram12333 2021-12-20 21:19:50
hi experts, do anyone have any code to extract sql from binlog?

You can use mysqlbinlog

Ram12333 2021-12-21 04:55:48
svart 2021-12-21 00:14:59
You can use mysqlbinlog

Yes

tiiii_9 2021-12-21 20:41:00
Anyone withe the steps to make setup on the pc on MySQL
Naga Satya Srinivas Annabathula 2021-12-22 11:16:49
I am getting dead locks in MySQL, so that my application stopped working, any log can i setup whenever any dead lock happens
MasterZiv 2021-12-22 11:20:16
Naga Satya Srinivas Annabathula 2021-12-22 11:16:49
I am getting dead locks in MySQL, so that my application stopped working, any log can i setup whenever any dead lock happens

It should be written Rio the usual mySQL log, check it!

I_am_3ngineeR 2021-12-22 11:23:06
mysql_en-15040.jpg
Can any body explain me that what does that “1” do in this code line. The outputs makes no sense to me since, I don’t know what does that 1 do.

That’s not an homework, example from mysqltuto website.

svart 2021-12-22 12:55:34
I_am_3ngineeR 2021-12-22 11:23:06
Can any body explain me that what does that “1” do in this code line. The outputs makes no sense to me since, I don’t know what does that 1 do.

That’s not an homework, example from mysqltuto website.

You need to return anything “not null” to show that specific row exists. Selecting column does not make sense because it will require additional lookup. That is why usually 1 is being return. You replace 1 with any number, string, anything except null

I_am_3ngineeR 2021-12-22 12:56:54
Well then is it okey to just switch that one with * ?
I_am_3ngineeR 2021-12-22 12:57:14
oh, sorry it’s not right? since it will select everything for both null and not null ?
MasterZiv 2021-12-22 15:17:34
I_am_3ngineeR 2021-12-22 11:23:06
Can any body explain me that what does that “1” do in this code line. The outputs makes no sense to me since, I don’t know what does that 1 do.

That’s not an homework, example from mysqltuto website.

You can change this 1 to * of you are afraid of UFO

MasterZiv 2021-12-22 15:18:16
svart 2021-12-22 12:55:34
You need to return anything “not null” to show that specific row exists. Selecting column does not make sense because it will require additional lookup. That is why usually 1 is being return. You replace 1 with any number, string, anything except null

No you don’t need it

MasterZiv 2021-12-22 15:19:23
I_am_3ngineeR 2021-12-22 12:56:54
Well then is it okey to just switch that one with * ?

Yes, as the sub query is under EXISTS predicate

I_am_3ngineeR 2021-12-22 15:21:37
Well, all I understand is “Just accept, don’t hursh yourself the get it. Just consume it”
MasterZiv 2021-12-22 17:15:48
I_am_3ngineeR 2021-12-22 15:21:37
Well, all I understand is “Just accept, don’t hursh yourself the get it. Just consume it”

doesn’t matter what expression is in such a subselect. 1, 42, *, ‘ABBA’, null β€” anything will do.

I_am_3ngineeR 2021-12-22 17:21:08
MasterZiv 2021-12-22 17:15:48
doesn’t matter what expression is in such a subselect. 1, 42, *, ‘ABBA’, null β€” anything will do.

Thats more clear, thanks πŸ™πŸ»

Usman_Khalid 2021-12-22 22:10:35
How do Δ± send the same message to a group of Δ±d
Chitti Devara 2021-12-23 06:24:25
How to create hr dashboard with database
piterden 2021-12-23 06:37:32
Chitti Devara 2021-12-23 06:24:25
How to create hr dashboard with database

First you need to define what does HR dashboard mean

Chitti Devara 2021-12-23 06:41:54
Like hr login portal
piterden 2021-12-23 06:44:08
Chitti Devara 2021-12-23 06:41:54
Like hr login portal

Why do you think anyone should know it? Honestly it tells me nothing at all

Liran 2021-12-23 10:41:49
How is Migration from one mySQL to another is done? just do dump and restore?
svart 2021-12-23 13:37:35
Liran 2021-12-23 10:41:49
How is Migration from one mySQL to another is done? just do dump and restore?

Yes. What you can do is to setup replication via dump/restore and then switch to replica once it will be needed

tiiii_9 2021-12-23 22:21:57
What are the benefits of studying database systemπŸ₯ΊπŸ₯Ίi have studied it since 2014 till now no job
Geek 2021-12-24 05:06:15
Hi All .. Replication got issue due to the *Waiting for table flush*. Can you please tell me how to know the PID to kill.
Krishna Krish 2021-12-24 11:05:00
Geek 2021-12-24 05:06:15
Hi All .. Replication got issue due to the *Waiting for table flush*. Can you please tell me how to know the PID to kill.

Show processlist;
Show engine innodb status;

|