[quote][b] sql test[/b] [quote]SELECT Rockstars.LastName, Rockstars.FirstName, Usernames.username FROM Group INNER JOIN Usernames ON Group.P_Id=Usernames.P_Id Usernames BY Rockstars.LastName[/quote] [b] unix test[/b] [quote]% who % sort % jobs % ps % kill %1[/quote] [/quote]

Last edited by the_legend_killer (2008-09-25 09:37:07)

[quote=eney0715]Did you mean anything (as in anything) by that??[/quote] Yeah....I meant....have you been smoking chronic? [b]@Guile[/b] What's with your posts?

[quote=Infamous J]Yeah....I meant....have you been smoking chronic? [/quote] [i][b]Wuuu...I am thinking of another thing... But, seriously??.. Dang..Nevermind..[/b][/i] [quote=the_legend_killer]want me to explain that to you?! [/quote] [i][b]Oooohhh..Please..That post makes me want to take my special medicine!!.. [/b][/i]

Last edited by eney0715 (2008-09-25 09:43:10)

^^^^^^^^^^^ spam - I cant sleep! 3:44 am here

[quote=eney0715]Oooohhh..Please..That post makes me want to take my special medicine!!.. [/quote] ok the read this one [spoiler] Unix/Linux [spoiler]ls list files and directories ls -a list all files and directories mkdir make a directory cd directory change to named directory cd change to home-directory cd ~ change to home-directory cd .. change to parent directory pwd display the path of the current directory cp file1 file2 copy file1 and call it file2 mv file1 file2 move or rename file1 to file2 rm file remove a file rmdir directory remove a directory cat file display a file less file display a file a page at a time head file display the first few lines of a file tail file display the last few lines of a file grep 'keyword' file search a file for keywords wc file count number of lines/words/characters in file command > file redirect standard output to a file command >> file append standard output to a file command < file redirect standard input from a file command1 | command2 pipe the output of command1 to the input of command2 cat file1 file2 > file0 concatenate file1 and file2 to file0 sort sort data who list users currently logged in * match any number of characters ? match one character man command read the online manual page for a command whatis command brief description of a command apropos keyword match commands with keyword in their man pages ls -lag list access rights for all files chmod [options] file change access rights for named file command & run command in background ^C kill the job running in the foreground ^Z suspend the job running in the foreground bg background the suspended job jobs list current jobs fg %1 foreground job number 1 kill %1 kill job number 1 ps list current processes kill 26152 kill process number 26152[/spoiler] SQL [spoiler]SELECT LastName,FirstName FROM Persons SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons INNER JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons LEFT JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName SELECT Company, SUM(Amount) FROM Sales SELECT column,SUM(column) FROM table GROUP BY column HAVING SUM(column) condition value[/spoiler][/spoiler] [quote=As cicatrizes]:idea::rose::clock::globe::cake: hollah![/quote] nice one spammer! [quote=losher29]^^^^^^^^^^^ spam - I cant sleep! 3:44 am here [/quote] why?! did malow say a good bye to you or something!

[b]GUILE: looks like the kapre clan will also make a pact.,i think it'l get 30 flags in no time.,^__________^[/b] [b]hello kuya jesse?had a good night sleep?[/b]

Last edited by As cicatrizes (2008-09-25 09:49:51)

[b]wahaha..yah kuya guile what's that?? [/b] [spoiler]bz studies mr.pee [/spoiler]

[b]@Kuya Jesse: Aaaahhh..Okeeiii... I was thinking of something..But..nevermind that one.. Nyahaha..So you really thought that i am smoking that tobacco??.. Naaaah..Chronics are way off-limits... [/b]

[quote=Infamous J] You said you couldn't stop laughing or smiling....so I thought maybe you had been smoking the wacky tobacco. [/quote] roflmao! [quote=As cicatrizes]GUILE: looks like the kapre clan will also make a pact.,i think it'l get 30 flags in no time.,^__________^[/quote] im also thinking to change the rules and pm ducheszv cause their are many players are not reading the rules like 3 unique poster before your turn but nope! they keep on posting [quote=eney0715]@Kuya Guile: Aaaaahhh...I get it now.. [/quote] want some more?! [quote=CuTeUkoi]wahaha..yah kuya guile what's that?? [/quote] read my last spoiler on my reply at eney! [quote=CuTeUkoi]bz studies mr.pee [/quote] yup mr pee is busy?! so you miss him?! [quote=losher29]yeah she said a lot of good byes hahaha. [/quote] looks like someone is missing someone already

Last edited by the_legend_killer (2008-09-25 09:59:02)

[b]Guile[/b] We will go to Norzagaray, Bulacan (Falcon Crest) We will do some weird activities there.... And weird I mean unusual (what's teh diff! haha) [b]MabeL[/b] ahahhahhaha Your hiphop words are making me ....... LOL [b]Jie[/b] YeahHHH! Long time no see ;DD [i]- Sorry for the late replies[/i]