Posts

Showing posts from August, 2025

What is DB Browser

Image
What is DB Browser DB Browser for SQL ite (DB4S) is a free, open-source visual tool that helps users build, browse, and modify SQLite or SQLCipher database files. It offers a user-friendly, spreadsheet-style interface with full support for SQL queries. It is compatible with Windows, macOS, and major Linux and Unix systems. User guides and documentation are available on its wiki page. DB4S provides full access to all the features of the underlying SQL ite, including built-in controls and step-by-step wizards that allow users to: ·          Create new database files and reduce their size through compaction ·          Build, edit, remove, or redefine database tables ·          Set up, modify, or delete indexes ·          View, update, insert, and remove data records ·        ...

Java Course Coding Samples

 Buy coding scripts, worked out and planned for Java Courses, from beginners to advanced. If you are a  Java  trainer, teacher at a school or college,  Java  coding tutor or  Java  student, these codes are designed to illustrate all topics in briefly isolation as well as integrated into small  Java  projects.  It saves time searching for code example.  Everything is worked out and in sequence from beginners to advamced https://payhip.com/JavaCode     

Delete vs Truncate in MySQL and MS SQL Server

Delete vs Truncate in MySQL and MS SQL Server DELETE DELETE is a DML Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. We can specify filters in where clause It deletes specified data if where condition exists. Delete activates a trigger because the operation are logged individually. Slower than truncate because, it keeps logs. Rollback is possible. TRUNCATE TRUNCATE is a DDL command. TRUNCATE TABLE always locks the table and page but not each row. Cannot use Where Condition. It Removes all the data. TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions. Faster in performance wise, because it doesn't keep any logs. Rollback is possible. DELETE and TRUNCATE both can be rolled back when used with TRANSACTION (TRUNCATE can be rolled back in SQL Server, but not in MySQL ). if there is a PK with auto increment, truncate will reset the counter Learn SQL with us a PCWorkshops !