4 ms·
A decent database has transactions, so you can rollback your fat-fingered queries.
by syslog 3y ago
A decent database has transactions, so you can rollback your fat-fingered queries.
- cafard 3y agoPostgres and SQL Server have always had transactions; but unless you frame your DML in BEGIN TRANSACTION/[COMMIT|ROLLBACK], each statement is committed as executed. If you broke in on Oracle, where you must explicitly commit statements (unless your client sets up auto-commit), this can take some getting used to.