April 17, 2021April 17, 2021mysql mysql: capitalize first word of all words credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/ create a function: CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i […]
April 15, 2021uncategorized python imaplib: search emails with specific subject result, numbers = mail.uid('search', None, '(SINCE "' + date_start + '" BEFORE "' + date_end + '") (SUBJECT "Failure")')
April 15, 2021April 15, 2021uncategorized postgresql: incorrect table sizes do a VACUUM FULL if you want to run this on python you need to set autocommit = True otherwise it […]
April 15, 2021uncategorized pgsql: clone database pg_dump -Fc -f olddb.pgdump -d db_name createdb cloned_db_name pg_restore -d cloned_db_name olddb.pgdump