SELECT NOW();

TRUNCATE TABLE `default`.`TRANSACTION`;

UPDATE `TRANSACTION` SET MEMO = TRIM(MEMO)

ALTER TABLE `default`.SUBCATEGORY MODIFY COLUMN UPDATED datetime ON UPDATE CURRENT_TIMESTAMP NULL;

SELECT * FROM `default`.`TRANSACTION` t WHERE INSTALLMENT_TT IS NOT NULL;

SELECT * FROM `default`.`TRANSACTION` t WHERE t.ID NOT IN default.CATEGORIZED_TRANSACTIONS.ID; 

SELECT *
FROM TRANSACTION t
LEFT JOIN CATEGORIZED_TRANSACTIONS ct
ON t.ID = ct.TRANSACTION_ID
WHERE ct.TRANSACTION_ID IS NULL;

SELECT * FROM default.TRANSACTION t LEFT JOIN default.CATEGORIZED_TRANSACTIONS ct ON t.ID = ct.TRANSACTION_ID WHERE ct.TRANSACTION_ID IS NULL;