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 output inserted id
Sql :: output to file mysql
Sql :: mysqldump csv
Sql :: how to check mysql version in xampp
Sql :: mysql select from outside
Sql :: mysql breakline on string
Sql :: oracle view source
Sql :: list index mysql cli
Sql :: create column mysql terminal
Sql :: convert uniqueidentifier to varchar in sql
Sql :: create table mysql example auto_increment
Sql :: add column to table sql
Sql :: postgresql if null then 0
Sql :: start mysql server using docker
Sql :: différence entre deux dates sql oracle
Sql :: sql query length of string the longest
Sql :: Oracle Column Names of a table
Sql :: adding a check statement in sql
Sql :: sql query to find duplicate email address
Sql :: MySql get primary keys of table
Sql :: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sql :: how to get table current identity value in sql server
Sql :: sql delete multiple conditions
Sql :: cmd to rename a collumn name in sql
Sql :: sql show tables
Sql :: oracle exceeded simultaneous sessions_per_user limit
Sql :: sql display number without decimals
Sql :: grant access on table in oracle
Sql :: t sql to rebuild all indexes in a database
Sql :: sql limit decimal places