Do you have any previous backup?

|
Swapnil 2022-09-12 19:32:19
From where does this 3000*0.15 came from ?
SaketSaurav 2022-09-12 19:43:30
Swapnil 2022-09-12 19:32:19
From where does this 3000*0.15 came from ?

Bro, total usage is 33000, so, from that slab only 3000 will get utilised.

Swapnil 2022-09-12 19:45:25
Okay got it
Swapnil 2022-09-12 19:46:00
So for Plan D is it like below
33000*0.25 ?
SaketSaurav 2022-09-12 19:46:41
Swapnil 2022-09-12 19:46:00
So for Plan D is it like below
33000*0.25 ?

Yupp, right.

mrMahesh_19 2022-09-13 13:12:37
Sir please gave a link of mysql for window 11
Murali 2022-09-13 13:46:02
Every day 3000 users want to connect and need to work on multiple data. Kindly suggest how many connections required to configure
Varadamadhusudhan 2022-09-13 19:32:29
Hi guys….

Plz help me..

If I update wrong data….how can I get previous data…..with SQL query

Swapnil 2022-09-13 19:37:46
Varadamadhusudhan 2022-09-13 19:32:29
Hi guys….

Plz help me..

If I update wrong data….how can I get previous data…..with SQL query

Are the changes committed ?

Varadamadhusudhan 2022-09-13 19:45:20
Swapnil 2022-09-13 19:37:46
Are the changes committed ?

Yes

Varadamadhusudhan 2022-09-13 19:45:41
Executed querry without where condition
Varadamadhusudhan 2022-09-13 19:46:13
So all updates done by mistake …how can I get/recover previous data
Swapnil 2022-09-13 19:48:10
Varadamadhusudhan 2022-09-13 19:46:13
So all updates done by mistake …how can I get/recover previous data

Do you have any previous backup ?

Varadamadhusudhan 2022-09-13 19:48:18
No
Swapnil 2022-09-13 19:48:50
Then in that case there is no such direct method of getting old data back
Varadamadhusudhan 2022-09-13 19:49:17
We don’t do backup every time before doing update querry is it possible in real time scenario
Varadamadhusudhan 2022-09-13 19:49:57
Swapnil 2022-09-13 19:48:50
Then in that case there is no such direct method of getting old data back

Something is there…it’s my interview question

Swapnil 2022-09-13 19:49:58
Varadamadhusudhan 2022-09-13 19:49:17
We don’t do backup every time before doing update querry is it possible in real time scenario

Next tike you should backup a table and then do updates or deleted

Varadamadhusudhan 2022-09-13 19:50:01
Tell me ans
Varadamadhusudhan 2022-09-13 19:50:16
Swapnil 2022-09-13 19:49:58
Next tike you should backup a table and then do updates or deleted

Impossible

Varadamadhusudhan 2022-09-13 19:50:32
Time waste and data waste
Swapnil 2022-09-13 19:50:38
Varadamadhusudhan 2022-09-13 19:50:16
Impossible

What is impossible here ?

Varadamadhusudhan 2022-09-13 19:50:57
Swapnil 2022-09-13 19:49:58
Next tike you should backup a table and then do updates or deleted

I don’t know ..but it’s impossible

Swapnil 2022-09-13 19:51:03
Varadamadhusudhan 2022-09-13 19:50:32
Time waste and data waste

Less time waste than to figure out how to get back the original data🤣🤣

Varadamadhusudhan 2022-09-13 19:51:22
Swapnil 2022-09-13 19:51:03
Less time waste than to figure out how to get back the original data🤣🤣

U have real time experience

Swapnil 2022-09-13 19:53:06
There is something called as point in time log backup
Swapnil 2022-09-13 19:53:18
explore that and ans accordingly in interview
Varadamadhusudhan 2022-09-13 19:53:52
He asked me like this
Varadamadhusudhan 2022-09-13 19:54:55
With 1 small mistake we have loss entire data….?
Varadamadhusudhan 2022-09-13 19:55:23
No there is some solution but I don’t know exactly
SaketSaurav 2022-09-13 19:55:55
Just asking, won’t Rollback and Commit command work it out?
Nitin Rao 2022-09-13 19:56:13
Usually we use edge not to perform. Any operation on DB

Rather to direct query on main DB

Varadamadhusudhan 2022-09-13 19:56:17
I want to update 10000 values in 1 table…. How can u do
Nitin Rao 2022-09-13 19:56:37
Nitin Rao 2022-09-13 19:56:13
Usually we use edge not to perform. Any operation on DB

Rather to direct query on main DB

Node*

Varadamadhusudhan 2022-09-13 19:57:50
If any one do wantedly ….then entire project will goes in trouble😂😂😂
|