Prevent accident running of truncate and delete query

You can control who can have access to the database admin console, and who can only have access as Designers on Appian applications (i.e. you can remove database access from Appian Designers by making them Basic Users with Designer rights only, and not Database rights). You could therefore restrict access to the database admin console to System Administrators only...this doesn't prevent the scenario you're describing but it does reduce the likelihood.

You can control who can have access to the database admin console, and who can only have access as Designers on Appian applications (i.e. you can remove database access from Appian Designers by making them Basic Users with Designer rights only, and not Database rights). You could therefore restrict access to the database admin console to System Administrators only...this doesn't prevent the scenario you're describing but it does reduce the likelihood.

Another way to avoid accidental delete is to run the queries in Transaction and only commit if you are sure you have run it on correct database/table and ran correctly.

But does the phpMyAdmin supports Start Transaction , Commit and Rollback. I tried it it did not work. Has anyone used these commands in phpMyAdmin, if yes can you please share how did you run it?