To duplicate table structure of existing table, we can use this command:
CREATE TABLE student_contact_deleted LIKE student_contact;
CREATE TABLE LIKE
Posted by narumi
on January 13, 2012
No comments
jQuery change image code snippet
Posted by narumi
on November 1, 2011
No comments
$("#link").click(function() {
$("#image").fadeOut(1000, function() {
$("#image").attr("src",$("#link").attr("href"));
}).fadeIn(1000);
return false;
});
Useful code snippet for image change using jQuery. In this code image will change on click. Can be change to other event trigger like mouseover, mouseout.
Used car financing
Posted by narumi
on October 25, 2011
1 comment
For a few days, my colleague and I talks and speak each others opinion as one of my colleague decides to buy a used car and asking us for car financing.
Some people believe that you need to dump a lot of cash for down payment. Well, my colleague did think that way. So he planned to pay up at least 10k for the car’s downpayment. From his plan, he will apply for personal loans to finance car down payment then use hire purchase loans for the rest of car financial.
Personally, I didn’t agree with the idea since he will end up with loans with more interest. Personal loans charge minimum 10% interest rate. Some banks charged more than that. Then hire purchase loans itself charge higher interest for used car maximum 4% interest rate.
So it’s not worth to have loans with 14% interest rate. I advised him pay only minimum on downpayment and only take hire purchase since it only serve 4% interest rate. That will save a lot of his money from paying more for banks.
Constant value in insert select
Posted by narumi
on October 25, 2011
No comments
INSERT INTO linking_book_category (book_id, category_id) SELECT book.id, 1 FROM books AS book;
More advance usage involving substring, trimming leading zeros as I try to migrate college’s intake from migration table.
INSERT INTO intakes (no,month,year,active,`status`,createdby,datecreated)
SELECT DISTINCT academicperiod, TRIM(LEADING '0' FROM SUBSTR(academicperiod,6,2)), SUBSTR(academicperiod,1,4), 1, 1, 1, NOW()
FROM _prestige_intake
WHERE academicperiod IN ('2006/01','2006/07','2007/01','2007/07','2008/01','2008/07','2009/01','2009/07','2010/01','2010/07')
ORDER BY academicperiod ASC
Merge rows as one field
Posted by narumi
on October 12, 2011
2 comments
GROUP_CONCAT(fieldname ORDER BY fieldname ASC SEPARATOR ',')
Full code usage example:
SELECT email, studentname, GROUP_CONCAT(matrixno ORDER BY matrixno ASC SEPARATOR ',') AS matno, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )
Code above used to find duplicates for email.
Android Apps for shopping
Posted by narumi
on July 30, 2011
1 comment
Most cases, I always forgot what to buy when I was in the right place for shopping. So shopping list apps would help me a lot. There is a lot shopping list apps out there. Doesn’t matter which apps you like because the function is almost the same except some comes with nice appearance for attraction.
I used to like Out of Milk for shopping apps but now i’m using another apps that provide ‘what it does for’. What I mean here is that the apps just provides a simple shopping list and optional for appearance (which is not necessary)
OI Shopping List is what I mean. A simple and easy to use right after apps execution. Simply add item by typing text box at bottom. You might be shocked to see item added appear in super huge font size, but dont worry to much because the font size can be change in application setting. You will also found optional skin features inside setting.
The best thing about any shopping apps is that you can estimate how much you will spend before you pay. By clicking any item that you have listed, you can set the quantity and price per unit. For me its really helpful.