Reputation
33,452
Next tag badge:
427/1000 score
119/200 answers
Badges
7 57 109
Newest
 Enlightened
Impact
~1.6m people reached

11h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
That's already in the answer. In versions 5.5 or later, if there is a foreign key that references a table, you cannot TRUNCATE that table.
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
@geeksal a_horse has a point. I removed the Postgres part from my answer (until I'm sure what it is there)
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
@geeksal frankly, I don't know. I assume they wouldn't run but I'm not sure. But it should be fairly easy to test (if other triggers, not the CASCADE, are triggered)! I don't have a 5.1 installed in my machine, I'll try later.
12h
revised “TRUNCATE doesn't run ON DELETE trigger” true or false
deleted 16 characters in body
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
@geeksal do you use InnoDB or other engine?
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
@a_horse_with_no_name For SQL Server: TRUNCATE I made no remarks about being possible to roll it back in other DBMS (only for MySQL).
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
@a_horse_with_no_name The documentation states otherwise (for Postgres postgresql.org/docs/current/static/mvcc-caveats.html)
12h
answered “TRUNCATE doesn't run ON DELETE trigger” true or false
12h
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
Which version of MySQL are you interested in? And which version of the documentation are you reading from and referring to?
12h
revised Correct the code?
rolled back to a previous revision
12h
revised Search between dates where all dates appear
escape quotes
12h
revised Search between dates where all dates appear
deleted 1 character in body
13h
comment Correct the code?
You have 2 FROM.
13h
revised Correct the code?
added 16 characters in body
14h
reviewed Reject How do you kick users out of a SQL Server 2008 database?
14h
reviewed No Action Needed Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column
15h
comment Full text indexes on big tables
A full-text index crashing the "database", sounds weird by the way. What kind of crashes did happen?
15h
comment Full text indexes on big tables
What version of MySQL? What engine does the table use? It would be better if you added the SHOW CREATE TABLE tablename; output in the question.
15h
reviewed Approve Full text indexes on big tables
15h
reviewed Close about SSRS 2014 subscriptions?