Replace Into - MySql Query
by. Dolvin ≈ August 2, 2008 |
I like using this syntax in MySql coz it have a simple syntax and so efficient when I want to insert a record but if it already exist, it'll update the data... 
but it not too recommended, coz from the statement below.. REPLACE INTO will slower the performer...
Mechanism ::
1. Try to insert the new row into the table
2. While the insertion fails because a duplicate-key error occurs for a primary key or unique index:
1. Delete from the table the conflicting row that has the duplicate key value
2. Try again to insert the new row into the table
Syntac ::
REPLACE INTO F SELECT * FROM T;
REPLACE INTO F(a, b, c) SELECT a, b, c FROM T;
Summary:
REPLACE INTO becomes more efficient from DELETE FROM… INSERT INTO… but much slower performer than an UPDATE statement. Better use “INSERT … ON DUPLICATE KEY UPDATE…” as an alternative if you’re looking at a single unique column table (Primary Key).
source : http://blog.sherlock-group.com
|
Category : Programming 
Comment : 0 Comment |
 |
|
|
|
|
Top 10 Excuses For Sleeping At Work
by. Dolvin ≈ August 1, 2008 |
10. "They told me at the blood bank this might happen."
9. "This is just a 15-minute power nap like they raved about in that time management course you sent me to."
8. "Whew! Guess I left the top off the whiteout. You probably got here just in time!"
7. "I wasn't sleeping! I was meditating on the mission statement and envisioning a new paradigm."
6. "I was testing my keyboard for drool resistance."
5. "I was doing a highly specific yoga exercise to relieve work-related stress. Do you discriminate against people who practice yoga?"
4. "Shoot! Why did you interrupt me? I almost figured out a solution to our biggest problem!"
3. "The coffee machine is broken..."
2. "Someone must have put decaf in the wrong pot."
1. "...In Jesus' name, Amen."
|
|
Category : Jokes
Comment : 0 Comment |
|
|
Border Collie
by. Dolvin ≈ July 31, 2008 |
What is the smartest dog breed in the world? Do you know, if we have a a highly intelligent dog, it have a troublesome, coz if a highly intelligent dog is left at home alone all day, they can get bored and become destructive and/or neurotic. On the other hand, a dog with limited intelligence can be left at home all day, and not even realize you’re gone until a few minutes before you arrive home!  and the winner is.. Border CollieCountry Of Origin : Great Britain Like many intelligent breeds, the Border Collie needs a job to do. If they don’t have a purpose in life or some kind of job, they will not be happy. Border Collies should definitely not be left at home alone all day, and if they are, they can become quite destructive. They need constant companionship, praise, and extensive exercise. So if you work and live in the city, a Border Collie probably isn’t the dog for you! Because of their legendary intelligence, Border Collies set the standard in competitions for such skills as agility, obedience, and of course, sheepdog trials. The Border Collie is a truly well proportioned dog with agility and perfect balance. The coat can either be smooth or of medium length with a thick water resistant undercoat. When working, this breed will usually be seen in the crouched position, with their alert eyes fixed on the job in hand. The 'hypnotic' eye characteristic is probably more defined in the Border Collie than any other breed and it is this quality which makes them so superb in herding sheep, using their eyes to guide a herd without the need to nip or bark. It will be hard to find a breed that is more receptive to training than the Border Collie. Their intelligence is second to none and their minds are like sponges, absorbing all new tasks with an eagerness and the greatest desire to please. Because of this, these dogs are like a gift from heaven for those wanting to compete in obedience/agility/herding trials. They are born, and it is always in their natures, to herd sheep and if this is not what they are required to do, other activities must be given to keep them content and happy - and to stop them rounding up the children! hmmm.. what a handsome dog, isn't it?  |
|
Category : General Info
Comment : 0 Comment |
|
|
Bila Topan K'ras Melanda Hidupmu
by. Dolvin ≈ July 16, 2008 |
Count your blessings or well known as Bila Topan k'ras melanda hidupmu in Indonesia... is my favorite religy song this time..
last sunday.. this song became the hymne of the week at my church...
when sang it.. I just realize.. I like this song..
This song has a cheerful tones.. "Count your blessings" reminds u to thankful every minutes in your life and can make you feel strong.. when u have a problem.. ^^
Here's the lyric:
Bila Topan Kras Melanda Hidupmu
Bila topan k'ras melanda hidupmu,
bila putus asa dan letih lesu,
berkat Tuhan satu-satu hitunglah,
kau niscaya kagum oleh kasih-Nya.
Reff :
Berkat Tuhan, mari hitunglah,
kau 'kan kagum oleh kasih-Nya.
Berkat Tuhan, mari hitunglah,
kau niscaya kagum oleh kasih-Nya.
Adakah beban membuat kau penat,
salib yang kaupikul menekan berat?
Hitunglah berkatnya, pasti kau lega
dan bernyanyi t'rus penuh bahagia!
Reff
Bila kau memandang harta orang lain,
ingat janji Kristus yang lebih permai;
hitunglah berkat yang tidak terbeli -
milikmu di sorga tiada terperi.
Reff
Dalam pergumulanmu di dunia
janganlah kuatir, Tuhan adalah!
Hitunglah berkat sepanjang hidupmu,
yakinlah, malaikat menyertaimu!
Reff
|
|
Category : Music, Christian Soul
Comment : 0 Comment |
|
|
PageRank
by. Dolvin ≈ July 7, 2008 |
What is PageRank?PageRank is considers the importance of each page that casts a vote, as votes from some pages are considered to have greater value, thus giving the linked page greater value. We have always taken a pragmatic approach to help improve search quality and create useful products, and our technology uses the collective intelligence of the web to determine a page's importance. from: google.comHmm.. Do you know there is free tools to check and monitor your PageRank easily and also can let you know, estimates the value of your website.. yeah.. it still beta.. but there is nothing to lose if you want to try it.. hihiihi.... here is the link... http://www.smartpagerank.com/
|
|
Category : General Info
Comment : 2 Comment |
|
|
|
|
| Page : « Prev 15 | 16 - 17 - 18 - 19 - 20 - 21 - 22 - 23 - 24 - 25 - 26 - 27 - 28 - 29 - 30 | Next 15 » |
|
|
| |
S |
M |
T |
W |
T |
F |
S |
| | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
|
|
|
|
|
