Popup message when i delete or change data

[expired user #6842]'s profile image [expired user #6842] posted 11 years ago in General Permalink
I want to alert message when i delete data or sql commend (ex:insert, delete, update)

Let me know , if that option existed.
ansgar's profile image ansgar posted 11 years ago Permalink
You want a message dialog when you manually fire some command? Why would you want that? The fact that you manually fire some DELETE commnand should make you aware of the consequences.
[expired user #6842]'s profile image [expired user #6842] posted 11 years ago Permalink
Thanks your reply but I mistake explanation

I want to YES/NO confirm message before change data in DATA TAB because I change or delete data in spite of myself not SQL commend using data tab

I'm not american so If you don't understand my word, read below compare MYSQL workbench to HeidiSQL program



MYSQL WROKBENCH
1. I change text data 'banana' to 'apple' using GUI(field in data tab) not SQL command
2. click apply button (I want to like function for prevention mistake)
3. data changed

HeidiSQL
1. I change text data 'banana' to 'apple' using GUI(field in data tab) not SQL command
2. Changed data already without warning message!



ansgar's profile image ansgar posted 11 years ago Permalink
Question: What happens in Workbench when you just leave the edited row, without clicking the "Apply" button?
[expired user #6842]'s profile image [expired user #6842] posted 11 years ago Permalink
Not chaged data.
Only changed when click apply buttonn
ansgar's profile image ansgar posted 11 years ago Permalink
So, when you move your cursor to a row below or above, no UPDATE is sent to the server? Is it still visible in that case that there are unsaved changes, or how is that done?

Well, I guess so. That's just a difference to the approach in HeidiSQL.

Please login to leave a reply, or register at first.