Question : Using MySQL (either InnoDB or MyISAM tables–I have both), if I TRUNCATE a table and then LOAD DATA […]
Tag: truncate
truncate table in mysql 8.0 is slower than older version
Question : I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed […]
Releasing disk space by using DELETE or TRUNCATE?
Question : More than a week ago, I deleted all the rows in a postgresql table (not via truncate, instead […]
Create table using select statement Truncated incorrect datetime value:
Question : I have looked up different answers on similar question before posting it here. So i have a table […]
Truncate parent table but not children
Question : I have a table in PostgreSQL 9.4 that I partitioned so that all inserts to the parent actually […]
How to get last truncated time for each tables in SQL Server database
Question : I have a SQL Server 2012 database. Is it possible to get last truncated time for all tables […]
Is there a way to “SELECT and TRUNCATE” without losing new data?
Question : I have an application that writes raw log files to a table called new in a PostgreSQL database […]
Truncate tables with dependent foreign key constraints
Question : Hi I’m trying to truncate some tables from my db, but they are related with foreign key constraints […]
Having performance issue for an extract date without time to compare with sysdate,
Question : I need to get all the rows where its ‘time’ field is equal to sysdate. The thing is […]
Sql Script takes much longer than estimated
Question : In order to clean up a very large table holding binary Files in IMAGE Cols, I created the […]