Friday, July 31, 2009

Calculation Using SQL Commands


lTo be able to calculate dates and
to be able to make use of SQL commands in retrieving data from two tables here are some commands:


Slide 4
The Table





Date Calculations

mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDA
mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDATE())-YEAR(birth))‏
-> - (RIGHT(CURDATE(),5)‏
-> AS age
-> FROM pet;
TE())-YEAR(birth))‏
-> - (RIGHT(CURDATE(),5)‏
-> AS age
-> FROM pet;


+-----------+--------------+------------------+-------+
| name | birth | CURDATE() | age |
+-----------+--------------+------------------+-------+
| Fluffy | 1993-02-04 | 2003-08-19 | 10 |
| Claws | 1994-03-17 | 2003-08-19 | 9 |
| Buffy | 1989-05-13 | 2003-08-19 | 14 |
| Fang | 1990-08-27 | 2003-08-19 | 12 |
| Bowser | 1989-08-31 | 2003-08-19 | 13 |
| Chirpy | 1998-09-11 | 2003-08-19 | 4 |
| Whistler | 1997-12-09 | 2003-08-19 | 5 |
| Slim | 1996-04-29 | 2003-08-19 | 7 |
| Puffball | 1999-03-30 | 2003-08-19 | 4 |

the result



mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDATE())-YEAR(birth))‏
-> - (RIGHT(CURDATE(),5)‏
-> AS age
-> FROM pet;


l.CURDATE() - gets the current date
l.YEAR() - pulls out the year part of a date
l.RIGHT() - pulls off the rightmost five characters that represent the MM-DD (calendar year) part of the date
l.AS age - an alias for the resulting column
l.MONTH() - pulls out the month part of a date


mysql> SELECT name, birth, death,
-> (YEAR(death)-YEAR(birth)) - (RIGHT(death,5)‏
-> AS age
-> FROM pet WHERE death IS NOT NULL ORDER BY age;



name | birth | death | age |
+-----------+--------------------+----------------+-------+
| Bowser | 1989-08-31 | 1995-07-29 | 5 |



mysql> SELECT name, birth FROM pet WHERE MONTH(birth) = 5;
+-------+---------------+
| name | birth |
+-------+---------------+
| Buffy | 1989-05-13 |
+-------+---------------+


For the second table:


mysql> SELECT pet.name,
-> (YEAR(date)-YEAR(birth)) - (RIGHT(date,5)
-> remark
-> FROM pet INNER JOIN event
-> ON pet.name = event.name
-> WHERE event.type = 'litter';



+---------+----------+----------------------------------------+
| name | age | remark |
+---------+----------+----------------------------------------+
| Fluffy | 2 | 4 kittens, 3 female, 1 male |
| Buffy | 4 | 5 puppies, 2 female, 3 male |
| Buffy | 5 | 3 puppies, 3 female |
+---------+----------+----------------------------------------+


Take Note:

lThe FROM clause joins two tables because the query needs to pull information from both of them
lWhen combining (joining) information from multiple tables, you need to specify how records in one table can be matched to records in the other
lINNER JOIN allows for rows from either table to appear in the result if and only if both tables meet the conditions specified in the ON clause



Slide 2
Read More




Monday, July 27, 2009

Weary without Encoding

tired me


A very tiring thing that I did for tonight! I was able to write a 10 page list of informations in an experiment notebook size for a "Book Report in Discrete Math" tomorrow! Can you imagine life without technology now? Wat the Heck! Can't take writing anymore in having technologies but since I don't have any choice but to write! I wrote it myself, with that Doctor like hand writing when writing so fast, for me to be able to take the exam tomorrow! It was a very weary thing to do. To get back to writing even if there's technology thou it's a very good lesson to teach computer dependents to avoid copying and pasting informations for their grades because it is really unfair to the person who really did the research. But in this case we have to do things using our own hands and that is to write! everything that's inside that "book report". I had a very long written informations from the web that's why I am so tired now, after I got finished in writing those sentences and even paragraphs.

Things with much worth can't just be taken for granted
Things still has to be done without technology
We have lived a life without technology before
So why can't we do it now?
No reason for us to be as dependent to computers as we are now
Needs can show us the limits in everything, isn't it?


things I used for the informations
Read More




A Nifty Score!

Amusing score I had in our accounting subject. I was amused upon knowing that I've made a lot of right guess in my answers to my test paper because I haven't really studied on that particular subject except that "Cycle of Accounting" which I guess have also helped me to gain that score of 42 out of 60! It's a great fulfillment for me that I have proved to myself that I was really listening and understanding her(our teacher's) discussions, through that unexpected score. But actually I just answered all the items with all my guessing powers! Ha ha ha. Now it's a power of me. I just find it so funny that my wild guess is also helping me even in my studies because my score was a big "YES"! to me..before that checking of papers happened I was really worried about my exam in Accounting because my answers we're just guesses and all.




While in my English subject I got 79 out of 100?! I failed to meet my expectation in that exam because all along, I was happy, thinking that I would get the perfect score. "
Ug sa dhang!" I only got 79, because I was not able to read the directions correctly. (I'm referring to those items that I haven't given the corresponding meanings of speeches)which caused my score to be like that! What a mess! It really displeased me! And my scores in my quizzes? Duuuh-- Even if my teacher told me that I'm gonna pass this prelim I still feel so bothered with my scores in this term such shameful scores for me. But I will retract my grades on midterms!

CONGRATULATIONS
to my guesses and stupidity! I'll can make my scores better the next time!


A guess won't work without an instilled knowledge in your mind with thinking,
Without understanding there can be no such word as guess.

Read More




Wednesday, July 22, 2009

Finally!



My obsession to this movie series has come to be more exciting coz I have was already able to buy one the book of the upcoming next twilight movie for its series which is "New Moon". I had bought only one book out of that 3 series stock in the National Bookstore at Gaisano Mall, because I was so confused if I will really buy it instead of buying a book in Philippine Literature that is going to be very useful for me especially during exams. Actually, before I got to see that books of the twilight series in the National Bookstore I was already thinking of buying that book for literature because literature is almost about stories, so I would need to have my own book. But, when we went to Gaisano Mall and have seen those books of the yesterday Twilight series I was already doubtful of what book to buy.





Day before that, I told my mother that I will buy a book and the book that I meant when I said that was the
Phil. Lit book but the price that I told her was the the price of that twilight series books which is 325 pesos each and that is the amount I will pay if I buy the 3 books that's also part of the series, which is the "New Moon, Eclipse and Breaking Dawn". Lol







Early in the morning today, my mother gave me
1thousand pesos to buy the book that I told her. When the money was already with me I became so confused of what to buy when I knew the price of that Phil Lit book is 500p more or less. Upon knowing that, I was thinking like it would be a waste of money for me to buy a book that is as expensive, and slender as that book unlike if I'll buy that books of twilight I'll already have 3books out of a thousand pesos. Get what I mean? And with that in Phil. Lit I can still think of a way to follow the lessons just like photocopying its pages and I can save an expense because more or less I can only spend 50p for every term in that subject because we only meet once a week in that subject. So we only have 4 meetings every month if there is always a class.
On the other side, I am also thinking like I will buy a book in Philippine Literature and buy only one book out of that 3 series from twilight because to think maybe I can't readily read that 3 books if I get to buy them while with that of the Phil. Lit book we are using and reading it once a week. But what if, by that time that I can buy another book of twilight series there will already be no stack in the national bookstore? I'm elated in what choice to choose. Because I really want to have the series of books of Twilight but how can I explain it to my mother if she will see the book that I will buy.





This doubt is driving me
insane. The change of the money when I bought the "New Moon " book is still with me and I'm still hesitant on what to buy.


Can anybody help me decide? =(




Read More




Thursday, July 16, 2009

HAppy 27th RACOISIE Monthsary

Extraordinary is how i can describe our long-lasting friendship as RACOISIE. Another month had passed and we had our monthsary again that we didn't noticed that were not incessantly talking like what we had when it was still summer. I feel so glad that even with our busy lives we can't forget the monthsary date of our friendship as RACOISIE oh! meN! It's sacred! Lol. Who will disagree! Even the word "PROMISE" is sacred! Once you said it, you mean it.(not an escape for questions dada :) Hmmm..
Thereby the friendship remains in our hearts and even distance can't separate us at heart. Ohlala! As usual I have this edit for the said monthsary:

t's US!
Together forever and never apart,
Maybe in distance, but never in heart







til eternity and beyond
(Ate Q Line)
the caption in this pic(is mine)

For our monthsary I was able to call the two of them using the unlimited call of a friend but I had more time talking to my beloved ate..:D I think that was almost 2hours? (you know yourself, whoever you are, it's you ate Q..(its obvious in the pic) Ha ha. I felt so weary, after how many hours of talking to the both of you. But at least I was able to hear your voices and laughter's again, that I miss to hear every time we are apart. =( Because we only talk in ym and are only sending comments from varieties of accounts that we have in every sites. But then again the day ended with our hearts left with gladness because of the solidarity of our superships!(Ate Q term again) I Love You both! Coisie!

RARA MOW AKO ATE Q..
AR2 KO NIMO DADA NQ..

=)


Read More




Laughing Class

Below is a naughty and crazy speech I've ever heard from a classmate, that has been recited in front of the class.

Speechcom Time: 1-2:30pm


This Made Me Laugh
by: Echavez

I don't think this made me laugh but it does. I laughed when I got my first kiss on a girl. It is a very unforgettable experience to me because it is so naughty and I like it. On that day, I don't know how to kiss a girl. Too much of being naughty makes me do that. I think it is stupid because I don't know and she know how to do it. The first time I saw her I thought she was innocent. But it was too late and she was not innocent she was so naughty. But too much naughtiness makes me love her more.

After three or four times of kissing I already learned to. I like the taste of her mouth. But it is just a kiss. I never do what you are thinking now. I think this made me laugh because that girl I kissed is always on my mind. That's why I still love her until now. I always laugh when I remember taht.

Who is that girl? It is a big secret of my life.

"Echavez"
the speech writer


Did it make you laugh too? Lol. He is a silly and naughty boy isn't he? Haha. Because the class were laughing too loud when we he was reciting that speech to the class. He was like shaking, and our teacher even hold his paper just for him to read it in front. I never thought that someone in the class could dare to write a speech like that nah to think it is to be recited in class. And he was able to write it so nice that the impact of it was so good. Hahaha! We almost roll in laughter. He has the guts to tell it to the whole class?! Hehe! How bout you?
Me? No Comment.
Still I can't stop myself from laughing even when I was typing this post.

Most laughable phrase
After three or four times of kissing I already learned to. I like the taste of her mouth.

*Laughing
*rolling laugh on the floor
.......


Read More




Wednesday, July 15, 2009

Which is Your Choice?

Boy to Boy?
or
Girl to Girl?





This video reminded me of what I am supposed to post about "kissing of same sex". This video was posted by a friend from facebook through a link(It's you Anj! lol). I never thought that it is a video of boys kissing each other because the title of the video is "If It's All I Ever Do" but the comments below the link made me wonder, so I watched it. Then I found out that those are guys or gays basta they are physically and sexually the same, Lol. Weeks ago I am watching "American Pie" with my friends and there are girls kissing each other too. In some of the scenes there, we came up with a debatable question and that is "Which is better" A boy to boy kiss? or a girl to girl kiss? So my gay friend said he is in favor of b2b because maybe for a fact that he is gay he will really choose that. But in men's case they said they are in favor of a g2g kiss same with us girls because we also choose the g2g kiss...



Our reason is that, even if you'll just look at girls sex kissing each other is really better than that of the boys in whichever way you look at it.. Just with a look I can say that its better we have the same reasons if why. Maybe nowadays its accepted but we also have to accept that all people would agree to it. Of course people every time they can see videos having this kinds of scenes. And we can't avoid that. Alright? And people are having different opinions when it comes to it. Respecting anyone's choice is all we could ever do.

So now, its your turn to speak up and say your comments too.

Which is better for you? Why?


Read More




Monday, July 13, 2009

New Moon Trailer

Oh my God! ive been longing to see this movie so much! Me and my friend? Hm! We were able to watch this movie accidentally, because we did not plan on what movie to watch but suddenly by looking at the posters outside the movie theater we choose twilight(which is its first movie for the series) and watched it. We did not expect that the movie is gonna be that nice and so romantic that we'd loved the movie that we choose and can never wait to see the next series. And now here is the "New Moon Trailer" which is gonna be the next movie for its series:




Just looking at this trailer, its going to be another interesting movie to watch. I promise to watch it soon as it is already in theaters. I have the e-book copy of the story, here in my laptop, the four series, but I haven't read it yet. Because its hard for me to read it on my computer due to radiation and less time spending my spare time in reading because I have other things to do. Ah, basta! I'll be watching "New Moon" wohooooooooooooooooooooh! Im so excited to see it! Wew! I can wait to watch it!


Read More




Sunday, July 12, 2009

The Denim Party '09


a mini poster for the party

A night with schoolmates and the managament for the acquaintance party. It was a very ugly event for most of the students who have witnessed it. For you to know why, here are the following reasons. Because the party was suppose to start at 5:30pm we even went there late so we could directly sit and the program might be starting by then when we arrive there. We thought that it would start after an hour from the right time that it was suppose to start(Filipino time style) Lol. Wait! you know what what? we reached there that the doors of the convention are still closed and its almost 8pm and seems like we are having a long time staying outside, because of filling up the attendance sheet on a yellow paper? Oh my! Can u imagine?! There are a lot of students for only one person to monitor the attendance! and the time might get exhausted just for that. And the cater for foods has just arrived? The stage was no styro's for any designs? Only a piece of white cloth on the stage that is to be used for projectors to show the presentations for every part of the program..Lol. The intermission numbers? Wat the! I dont know what to say, it was sooo awkward! the performers? they don't have the energy to perform their numbers! it seemed like they didn't practice for their performance.

this is the scene outside the convention center


after meal (at Jane)

modeling segment

gtg nah us. boooring!

at the convenience store from the venue

Click Here for more pics.


By the way if it is to be compared from the last acquaintance party? The last years event was better than what we had yesterday. It was totally different based on the preparations, intermissions, and all. Maye because their are countable persons behind it while last semester was being prepared by the Supreme Student Council(SSC) officers,their advicer and some from the management too.

Well anyways, maybe there were lots of reasons why it didn't became successful. But we can't think of any reason why it had to be that way. Because if we are going to base it on the budget we payed for the same amount which is 300p per student and we are even many now because of the new students. And it seems like they find it hard to organize it as nice as last year's party? Or maybe because, there are only few people who is willing to handle and help for it too. Hm...Looking forward to see a nice and joyful party next year for social contacts of the students.

For the continuation of the party(?)me and my friends, we headed to our house and drunk until 5am in the morning. Lol
And in that case, we can say that we enjoyed each others company!



The difference between failure and success is doing a thing nearly right and doing a thing exactly right.



Read More




Friday, July 10, 2009

Agnise (the replacement of Patience)

SQL Command Client Environment
Subj: File Organiation




Pulling myself in the real responsibility of a student is my shout for tonight. As what I have noticed, eversince this semester started I always hear our teachers repeating and reminding us of our responsibilities as a student, that we are provided by our parents and the teachers acting like our second parent in school. They keep telling us their students we also have responsibilities regarding our learning. We can learn through practicing, giving longer patience, than ever; understanding and trying. Those are my realizations for today that is when I tried to do the exercise1 we had in our Laboratory class, which will serve as a quiz to us from our teacher. During the laboratory time I copied the almost 80% of my answers (im not gonna be ashamed to admit this) and the rest are the only answers I have done for myself being an idiot and not looking at what you are typing is gonna kill time if you dont check and make it so right!

I have solved this 10questions in my own for tonight.
excercise lab1

1. create a table named student accgd to the figure.
2. insert all of the data (rows) prescribed in the figure
3. update student address living in Brgy. Lagao, Gensan to Brgy. Lagao, Gensan
4. Update student address living in Tupe, South Cotabato to the appropriate spelling of Tupi, South Cotabato
5. Delete student st08-001
6. List all data about the students with friends more than 200
7. List the studentNo, name, gender, of all male students
8. List the names of all female students living in Polomolok, South Cotabato
9. List the studentNo, name of male students with with friends less than 100
10. List all address without any repetition

I felt the fulfillment to what I decided to do tonight, maybe I ve just been through a lot of errors a while ago plus the arguements with friends because we have unlike ways ofanswering every questions, who directly talks like I'm so pity for not getting the answers quickly. I get interested with things only sometimes, so whenever I like to do something I have to do uphold it if I can. Because I only use my spare time in useful ways seldomly, like what I just did tonight, due to the error of downloading ym in my computer.


You will conquer by patience.

I am able to study the basic sql commands tonight, and I'm hopeful that I'll still remember what I just did a while ago that I was able to answer all the questions for that quiz.it feels so right after so many wrongs. Lol.
Read More




Wednesday, July 8, 2009

Ado.Net First Laboratoty Activity


Imports System.Data.OleDb


Public Class Form1


Inherits System.Windows.Forms.Form
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String






Private Sub save()
con.Open()
sql = "insert into oer(student number,Name,Address, Birthdate, Birthplace, Sex, Course, Year Level )values ('" & TextBox1.Text & "', '" & TextBox2.Text & " ', " & TextBox3.Text & "', '" & TextBox4.Text & "' , '" & TextBox5.Text & " ' ,'" & TextBox7.Text & " ' ,'" & TextBox7.Text & " ' ,'" & TextBox7.Text & " ' ,'" & TextBox8.Text & " ' ,'" & TextBox9.Text & " ' ,)"


Dim cmd As OleDbCommand = New OleDbCommand(sql, con)
cmd.ExecuteNonQuery()
con.Close()
End Sub


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
save()

GroupBox1.Enabled = True

End Sub




Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "provider= microsoft.jet.oledb.4.0;data source=lycloer.mdb"
con.Open()
sql = "select *from oer "
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "lycloer")
con.Close()
End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

End Sub
End Class










Here is our first task for our first laboratory activity during our class in Ado.Net (its a programming language). I received a lot of scolds from my friend who corrected all the mistakes in my saving and coding..because I placed it anywhere that's why it had errors. I was running out of patience when I told a friend to take charge of the editing for the program to run. I needed to make a new file in the application because he was also hesitant on what I did in my coding, so I did made a new one. Then, he copied and pasted the codes to where it should really be. Same with the saving of the file. I was having trouble at first because I understood it during the lecture but during the laboratory, I was not ANYMORE sure of the understanding that I had. But since I have a friend that is so good in programming he was able to help me (thou he scolded me because of being so idiot, it was worth it, because with him I've learned and understood a bit about this particular programming language).

When he was done copying and pasting all the codes in their proper places there was an error..that he was trying to fix. Then when it seemed like it was taking too long for him to solve that error we asked our teacher about it, and he said "spacing of two words is what the error meant", then we debugged it. After knowing about that spacing stuff is the error there. But then again it didn't work, having the same statement of error, in that same line. When I noticed that there was another two separated words that has space so when we take out that space it was already debugged! So I was still somehow proud of myself, because I was able to contribute something to fix that error which took us so long for the program to run.

I'm just so grateful that our teacher now for this subject was able to discuss it thoroughly and clearly that we were able to understand it, because during our last semester in our VB.Net class, our teacher was not able to give us the kind of learning that we wanna have. He failed to teach us properly. He is just attending our laboratory class and not giving us lectures. And if ever we have the lectures he is so fast in explaining things, he's just always telling us that it's easy to learn all that he teacher in front of us with a white board and a marker, but he wasn't able to satisfy our needs as his student. Well, people are different, so as the teachers.

All I can say for now is that I appreciate programming eveytime I can understand it and I! need the sincerity, patience and the courage to learn and understand everything about programming and its different languages.



"If debugging is the process of removing bugs, then programming must be the process of putting them in."
Read More




Wednesday, July 1, 2009

My Human Diary is Leaving

My cute sister is leaving for Dubai already. She has been waiting for that visa and yet it was a hasty occurrence. I was about to share something to her tonight, and I thought today will just be an ordinary day, like what the both of us used to have, like being online at 11pm and end after an hour or even extend for how many minutes. I did not expect that she is to let me know about a news of her leave for Dubai to work. I told her that I need her online today at 11pm and she replied "har, now online me." And I told her I can't go online at that moment because I was having my class, and I still have my next class which is until 5pm. I never mind to hurry in getting home because I didn't know that I would know about a news like that one.

I hurriedly went home from school because my mother commanded me to give my brother a hair-cut and buy my things for school at the same time for my yonger sister. When I got home I hurriedly went online because I was budgeting the hours that I'm gonna be using my laptop, because I was to upload plenty of pictures for a friend. When I opened my facebook account she left me a message and posted something on my wall saying "
har wer r u? was about to tell you that I'm leaving na.. but i can't find you everywhere? =(" Imagine?! I just knew about it today? and she is also leaving on the same day?I am so terrified! Of course who would not be startled, I was not expecting to know about that news on that same day that she is going to leave.

But since it's what she's been hoping for, (as usual) I support her for everything that she do. For I know that she always have good reasons for doing things.


All I know is that even when we’re miles apart -
You’ll still be and always gonna be my human diary sister [[ forever ]]
take my blessings with you
and be sure to keep in touch,
take care of yourself - be good to yourself
and remember, you'll be missed so much…or even more
:P

-Harhar-

Ate, Ill miss you online. Thou I know you'll still keep in touch and so do I. But its not gonna be the usual days like (everyday) that we are going to talk. I hope you'll b e able to find yourself there and will see the worth of your decision. For the reason that I know why you choose to work there, I'll be your sister, humrazz, harhar and etc. forever! My limitations are absolutely restricted. Wait. I feel like crying, well in fact I'm now crying (huhu) a bit lang naman. hmm..I know you'll still come back. But maybe because your my immediate comforter and adviser at all times you know how much I owe you every decision that I make. and the distance between us are just getting farther but I know it was never a hindrance to our sisterhood(hehe). We have been through the test of communication but we we're still able to get back our friendship. I just hope you'll be able to adjust in the new environment you are going to have very soon and will be able to chat with me, the same time that we used to. Take Care Ate. I'm just here, always here, right next to you. I Love You ate.
Read More




Return to top of page
Powered By Blogger | Design by Genesis Awesome | Blogger Template by Lord HTML