Example of MySQL SUBSTRING_INDEX()
Example of MySQL SUBSTRING_INDEX() 특정 구분자로 문자열을 분리해 내야할때 필요하다. mysql> SELECT ip, SUBSTRING_INDEX(ip,'.',1) AS part1, SUBSTRING_INDEX(SUBSTRING_INDEX(ip,'.',2),'.',-1) AS part2, SUBSTRING_INDEX(SUBSTRING_INDEX(ip,'.',-2),'.',1) AS part3, SUBSTRING_INDEX(ip,'.',-1) AS part4 FROM log_file; +-----------------+-------+-------+-------+-------+ | ip | part1 | part2 | part3 | part4 | +-----------------+..
더보기
jquery chart
jQuery Visualize Plugin jQuery Visualize Plugin is the perfect plugin if you have a table and want to generate a chart out of it. It offers different types of charts such as Bar, Area, Pie & Line charts. Examples Type of Charts: Bar, Area, Pie & Line. Requirements: jQuery, excanvas (included) Browser Support: IE6*, IE7*, IE8*, Firefox 2, Firefox 3.5, Safari 3 and 4, Opera 9. * HTML 5 canvas elem..
더보기