# ssh-keygen -t rsa -b 4096 -C "root@localhost" Generating public/private rsa key pair. Enter file in which to save the key (/root/.ssh/id_rsa): Created directory '/root/.ssh'. Enter passphrase (empty for no passphrase): Enter same p…
Simply using this script DO $$DECLARE p_table regclass; BEGIN SET LOCAL search_path='projectman'; FOR p_table IN SELECT oid FROM pg_class WHERE relnamespace = 'projectman'::regnamespace AND relkind = 'r…
The SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs. mysql> SELECT ip, SUBSTRING_INDEX(ip,'.',1) AS part1, SUBSTRING_INDEX(SUBSTRING_INDEX(ip,'.',2),'.',-1) AS part2…
1. Create column with data type 'date' 2. insert into data type date (u can insert using update from timestamp or etc) 3. create partition table using this command ALTER TABLE t_history_trend_test PARTITION BY RANGE (month(to_date)) ( PART…
