Error can’t create table …
I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had
CREATE TABLE `chapters` (
`chapter_id` int(10) unsigned NOT NULL auto_increment,
`chapter_title` varchar(255) NOT NULL,
PRIMARY KEY (`chapter_id`)
);
ALTER TABLE `articles`
[...]
Posted on January 8th, 2009 under MySQL • 1 Comment
How would you like to optimize a 10 minute query down to 24 seconds? This was an optimization I had to do at work and I thought I’d share this with anyone. Even though I was using MySQL as an example, I think the technique should work on any database. Let’s say you have a [...]
Posted on January 8th, 2009 under General SQL • 2 Comments
This is actually a song I wrote after I went back from San Diego. It must have been in Spring 1997.
Posted on January 6th, 2009 under Poetry • No Comments
This is another poetry in Indonesian that I made about the same time as my other poetry “Manusia”. I’m sure I was about the same state of mind as when I was writing “Manusia”
Posted on January 5th, 2009 under Poetry • No Comments
I don’t really remember when I wrote this poem. From the log it was September 1998 and early in the morning. Around that time (early morning and 1998) was one of my hardest. I also was stupid enough (I guess) to quit school and jump into the job market. I guess it’s part of my guilt of “wasting” my parents’ money sending me to complete school. At the time, I’m not sure if I ever complete my bachelor degree.
Posted on January 5th, 2009 under Poetry • No Comments