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 :: psql get table data types
Sql :: Assign value to var in SQL
Sql :: mysql add column after another
Sql :: identify number of rows in sql
Sql :: cheatsheet for sql
Sql :: create table postgresql foreign key
Sql :: how to find lowest in sql
Sql :: cannot drop database because it is currently in use
Sql :: trim sql oracle
Sql :: mysql on update current_timestamp
Sql :: how to change a column name in postgresql
Sql :: oracle list columns in schema
Sql :: begin transaction sql
Sql :: nested if in mysql
Sql :: if else in postgresql
Sql :: check duplicate values plsql
Sql :: pl/sql procedure example
Sql :: mysql store ip address
Sql :: zsh-syntax-highlighting zsh-autosuggestions
Sql :: date sql get the last week count
Sql :: oracle running queries
Sql :: oracle apex message quit website
Sql :: myswql show full processlist
Sql :: sql list dates between two dates
Sql :: how to install sql in anaconda
Sql :: get time component of datetime sql
Sql :: rename table column name in mysql
Sql :: mysqldump with where clause
Sql :: mysql remove first and last character from string
Sql :: remove foreign key constraints in postgres