Sql

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

DELETE FROM table1 #delete all record

PREVIOUS	NEXT

Code Example
Sql :: oracle revoke grant
Sql :: joomla execute raw sql
Sql :: drop temp table if exists
Sql :: mysql union
Sql :: update with select postgresql
Sql :: sql find duplicate records in two tables
Sql :: update and replace mysql
Sql :: sql check duplicate value in column
Sql :: add bool column in sql
Sql :: how to change the auto increment in existing table mysql
Sql :: use float in sql server string
Sql :: select 2 rows in sql
Sql :: null sql
Sql :: sql counter column
Sql :: delete database mysql command
Sql :: show column names in sql table
Sql :: drop sequence
Sql :: create delete procedure mysql
Sql :: mysql regexp match word
Sql :: delete a temporary table mysql
Sql :: oracle table free space
Sql :: r rmysql connect local database Plugin caching_sha2_password could not be loaded
Sql :: how to set a column as unique in sql server
Sql :: change password postgres pgserver
Sql :: oracle duration between timestamps
Sql :: postgresql float 2 decimal places
Sql :: pgsql is not permitted to log in
Sql :: select random sample sql
Sql :: make date with time sql
Sql :: lower case in sql