Life of a software developer

Server

Truncating MySQL tables with foreign key constraints

2016-07-04 ·1 min read

Truncate MySQL tables with foreign key constraints by dropping and recreating constraints or temporarily disabling FOREIGN_KEY_CHECKS.

constraints databases delete development foreign foreign-keys foreign_key_checks mysql server set sql truncate

CRLF in SQL Server

2012-05-06 ·1 min read

Insert CRLF line breaks into SQL Server strings using CHAR(13) + CHAR(10), with an example UPDATE statement.

crlf databases microsoft new-line server sql sql-server