Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql empty table

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

PREVIOUS NEXT
Code Example
Sql :: date 3 months from today sql 
Sql :: how to define a composite primary key in sql 
Sql :: how to add foreign key constraint in sql 
Sql :: Uncaught Error: Cannot use object of type mysqli_result as array 
Sql :: HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN 
Sql :: SQLite order random 
Sql :: mysql remove user privileges 
Sql :: turn off safe mode mysql 
Sql :: mysql data types 
Sql :: sql select divide column by number 
Sql :: possgress drop if exists view 
Sql :: mysql previous year 
Sql :: XOR in SQL Server 
Sql :: minus vs intersect in sql 
Sql :: mysql add fields 
Sql :: mysql alter table modify column 
Sql :: mysql does sentence contain word 
Sql :: dynamic sql invalid table name 
Sql :: t sql to rebuild all indexes in a database 
Sql :: postgres alter table owner 
Sql :: allsource oracle 
Sql :: null column to 0 in mysql 
Sql :: sql add column after another column 
Sql :: select top 10 rows in sql 
Sql :: tsql insert 
Sql :: mysql set id auto increment 
Sql :: sql date get month 
Sql :: count columns psql(PostreSQL) 
Sql :: When mysql server would not work in xampp 
Sql :: sql date diff 
ADD CONTENT
Topic
Content
Source link
Name
5+6 =