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 :: mysqldump database
Sql :: sql select row with max date
Sql :: rollback in sql
Sql :: null column as zero in mysql
Sql :: sql 2nd highest salary
Sql :: command to give readonly access to a postgres sql user
Sql :: sql server 2019 installation
Sql :: postgres data location
Sql :: sql use not in
Sql :: how to create a table structure from another table in mysql
Sql :: add column table pl sql
Sql :: oracle last modification in table
Sql :: postgressum when
Sql :: SQL select example
Sql :: drop database using terminal postgres
Sql :: sql data types
Sql :: android sqlite database example
Sql :: oracle select json_table example
Sql :: how to export/import a mysql database via ssh
Sql :: create a PostgreSQL user django on mac
Sql :: sql create table
Sql :: sql statement to change a field value
Sql :: connect to mysql c# connection string C#
Sql :: how-to-remove-mysql-root-password
Sql :: relation does not exist postgresql
Sql :: what is non relational database
Sql :: SQL order by string split length
Sql :: mysql search replace
Sql :: sql server set default value equal to auto increment
Sql :: sql count(*)