<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar/1922309615168544332?origin\x3dhttp://n-stage.blogspot.com', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script> <iframe src="http://www.blogger.com/navbar.g?targetBlogID=3054107564476057249&blogName=url.blogspot.com&publishMode=PUBLISH_MODE_BLOGSPOT&navbarType=BLACK&layoutType=CLASSIC&homepageUrl=http%3A%2F%2Furl.blogspot.com%2F&searchRoot=http%3A%2F%2Furl.blogspot.com%2Fsearch" height="30px" width="100%" marginwidth="0" marginheight="0" scrolling="no" id="navbar-iframe" frameborder="0"></iframe> <div id="space-for-ie"></div>
n-stage.blogspot.com
WELCOME


:D

Best view in IE Photobucket


Result of using wrong query
Saturday, October 2, 2010

I accidentally use wrong query to update record!!! OMG!

Update [table_name] set [column_name] = '[value]';
commit;

All the records in that column become that value. How? If I can't change back to their original value and I will be dead.

Lucky me. Phew! I have open the table previously and so I can change back their original value BUT it have 230+ record waiting for me. No choice~ I have to change back one by one.

Kai sign off @2:50 PM