Top "Truncate" questions

Truncate Table Within Transaction

Can the SQL "truncate table" command be used within a transaction? I am creating an app and my table has …

sql sql-server sql-server-2005 transactions truncate

MySQL: Truncate Table within Transaction?

I have an InnoDB table that needs to be re-populated every ten minutes within anywhere from 60k to 200k records. …

mysql transactions truncate

copy character from string to another string in C

I have a string AAbbCC what I need is to copy the first two and add them to an array …

c string char truncate strncpy

ORA delete / truncate

I'm using SQL loader to load my data into database. Before I insert the data I need to remove existing …

sql oracle truncate sql-loader

Truncating Strings by Bytes

I create the following for truncating a string in java to a new string with a given number of bytes. …

java string truncate

Truncate a decimal value in Python

I am trying to truncate a decimal value in Python. I don't want to round it, but instead just display …

python formatting decimal truncate

Extract characters at a set position

I am trying to find a function that will extract characters at a certain position within a string. For example, …

string r truncate

mysql: how to truncate the length of a field

Alter table merry_parents change mobile mobile char(10). When I do the above I'm getting error: #1265 - Data truncated for …

mysql field truncate alter

trunc and round function in sql

Is trunc and round the same with negative arguments? SQL> select round(123456.76,-4) from dual; ROUND(123456.76,-4) ------------------- 120000 SQL&…

sql oracle truncate rounding negative-number

Truncating the first 100MB of a file in linux

I am referring to How can you concatenate two huge files with very little spare disk space? I'm in the …

linux file merge truncate