This post is referring from my previous post regarding Sort MySQL Varchar Column The issue is the IC prefix is … More MySQL order by case
I got two machine that will act as web and name server. Both servers running with same services and will … More nginx+php-fpm+varnish+mysqld+php+drupal+unison+bind-roundrobin on fbsd 9.1
The issue is /usr/local/apache/logs/modsec_audit.log cannot view in CMC on WHM. To fix it just paste this into your modsec2.user.conf SecRequestBodyAccess On … More Atomicorp mod_security with CMC at Cpanel Server
Salam. I need to sort a varchar column that contains letter and number. For example IC G1000 G9090 G1200 G8900 … More Sort MYSQL varchar column
1. Sometime your cpanel backup was not complete or got some error during the backup process. 2. After restore the … More Addons domain prob after restore on CPANEL/WHM
This is not a HA and it’s not using any ldap replication engine and mysql replication engine. The methodology is … More IREDMAIL replication server with 1 hour delay or what ever delay you want.
This is how I imported posts from my old blog to this blog. insert into wp_posts(post_date, post_content, post_title ) select … More MySQL copy content from columns to another columns in other table
sebagai contoh – sempena worldcup 2010 Table – gol negara kekerapan_gol brazil 10 portugal 11 japan 8 so now kita … More Update multiple rows at once with different conditions.
The Substring function in SQL is used to grab a portion of the stored data. This function is called differently … More SQL Substring Function
feel free to surf my new photoshoot gallery at [url=http://matnet.my]http://matnet.my[/url] B)