Category "truncate"

Is OPTIMIZE / ANALYZE required after mysql table TRUNCATE?

In mysql database, I have about 20 tables (data size is very small - most of the tables have about 1,000 to 20,000 records, only one table has 200,000 records).

Audit truncate and drop

I want to capture truncate and drop statements on one table. In some google searches i got that it's impossible to execute: audit truncate, drop on schema.tab

Truncate long strings inside json in python

Given some json [ { "default_value": "True", "feature_name": "feature_1", "active_on": "remote_1,remote_2,remote_3,remote_4,remote_5

SQL Server TRUNCATE

I have a question to the TRUNCATE command. How does TRUNCATE work in background ? I read a text that says TRUNCATE creates a copy from the table and then star

How do I truncate a decimal in PHP?

I know of the PHP function floor() but that doesn't work how I want it to in negative numbers. This is how floor works floor( 1234.567); // 1234 floor(-1234.