Sql

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

TRUNCATE TABLE tablename

select * from toys;

truncate table toys;

select * from toys;

rollback;

select * from toys;

PREVIOUS	NEXT

Code Example
Sql :: SQL MIN() Function
Sql :: Power BI merge tables same columns
Sql :: insert to first table if field A equals field B from a second table using sql
Sql :: les jointures sql server
Sql :: mysqlimport
Sql :: how to exit mysql terminal
Sql :: timestamp type in sql
Sql :: new rails app with mysql
Sql :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Sql :: how to generate er diagram in mysql workbench
Sql :: Create table if not exist with exceptions
Sql :: postgresql cast string to int
Sql :: sqllite format
Sql :: install mysql ubuntu 20.10
Sql :: System.Diagnostics.Process is not supported on this platform
Sql :: how to check rollback status in oracle
Sql :: t-sql cheat sheet
Sql :: {"error":{"root_cause":[{"type":"index_not_found_exception","reason":"no such index
Sql :: sql developer sql worksheet not showing
Sql :: how to update date in oracle
Sql :: postgresql between month
Sql :: sql database column values restrict
Sql :: code to move ietms from one table to another myswl
Sql :: SQLALCHEMY track is set to true or false
Sql :: sql varchar(255)
Sql :: xampp increame mysql speed
Sql :: merge query using linked server
Sql :: cast as double sql
Sql :: phpmyadmin mysql conflict
Sql :: oracle c# multiple update sql