Menampilkan postingan dari Agustus, 2022
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…
