You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
642 B
19 lines
642 B
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; |