Tugas MySQL BAB 4

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.0.67-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select lcase('teknik informatika');

+-----------------------------+

| lcase('teknik informatika') |

+-----------------------------+

| teknik informatika |

+-----------------------------+

1 row in set (0.11 sec)

mysql> select lower('teknik informatika');

+-----------------------------+

| lower('teknik informatika') |

+-----------------------------+

| teknik informatika |

+-----------------------------+

1 row in set (0.02 sec)

mysql> select ucase('tehnik informatika');

+-----------------------------+

| ucase('tehnik informatika') |

+-----------------------------+

| TEHNIK INFORMATIKA |

+-----------------------------+

1 row in set (0.00 sec)

mysql> select upper('tehnik informatika');

+-----------------------------+

| upper('tehnik informatika') |

+-----------------------------+

| TEHNIK INFORMATIKA |

+-----------------------------+

1 row in set (0.00 sec)

mysql> select substring('tehnik infornatika',6);

+-----------------------------------+

| substring('tehnik infornatika',6) |

+-----------------------------------+

| k infornatika |

+-----------------------------------+

1 row in set (0.05 sec)

mysql> select substr('komputer',3);

+----------------------+

| substr('komputer',3) |

+----------------------+

| mputer |

+----------------------+

1 row in set (0.00 sec)

mysql> select substring('tehnik informatika',2,6);

+-------------------------------------+

| substring('tehnik informatika',2,6) |

+-------------------------------------+

| ehnik |

+-------------------------------------+

1 row in set (0.01 sec)

mysql> select substring('tehnik informatika',-11,5);

+---------------------------------------+

| substring('tehnik informatika',-11,5) |

+---------------------------------------+

| infor |

+---------------------------------------+

1 row in set (0.08 sec)

mysql> select left('tehnik informatika',6);

+------------------------------+

| left('tehnik informatika',6) |

+------------------------------+

| tehnik |

+------------------------------+

1 row in set (0.00 sec)

mysql> select right('tehnik informatika',11);

+--------------------------------+

| right('tehnik informatika',11) |

+--------------------------------+

| informatika |

+--------------------------------+

1 row in set (0.00 sec)

mysql> select ascii('5');

+------------+

| ascii('5') |

+------------+

| 53 |

+------------+

1 row in set (0.03 sec)

mysql> select ord('A') ord('a');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'ord('

a')' at line 1

mysql> select hex(2250;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '' at

line 1

mysql> select ord('A'),ord('a');

+----------+----------+

| ord('A') | ord('a') |

+----------+----------+

| 65 | 97 |

+----------+----------+

1 row in set (0.00 sec)

mysql> select hex(225);

+----------+

| hex(225) |

+----------+

| E1 |

+----------+

1 row in set (0.02 sec)

mysql> select char(66);

+----------+

| char(66) |

+----------+

| B |

+----------+

1 row in set (0.11 sec)

mysql> select char(66,85,78,65,70,73,84);

+----------------------------+

| char(66,85,78,65,70,73,84) |

+----------------------------+

| BUNAFIT |

+----------------------------+

1 row in set (0.03 sec)

mysql> select bin(8);

+--------+

| bin(8) |

+--------+

| 1000 |

+--------+

1 row in set (0.02 sec)

mysql> select insert('BunNugroho'3,1,'nafit');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '3,1,'

nafit')' at line 1

mysql> select insert('BunNugroho'3,1,'nafit');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '3,1,'

nafit')' at line 1

mysql> SELECT INSERT('BunNugroho'3,1,'nafit ');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '3,1,'

nafit ')' at line 1

mysql> select lenght('tehnik informatika');

ERROR 1305 (42000): FUNCTION lenght does not exist

mysql> select locate('format','tehnik informatika');

+---------------------------------------+

| locate('format','tehnik informatika') |

+---------------------------------------+

| 10 |

+---------------------------------------+

1 row in set (0.02 sec)

mysql> select ltrim(' tehnik informatika');

+--------------------------------+

| ltrim(' tehnik informatika') |

+--------------------------------+

| tehnik informatika |

+--------------------------------+

1 row in set (0.00 sec)

mysql> select trim(leading '+' from '++++MYSQL++++');

+----------------------------------------+

| trim(leading '+' from '++++MYSQL++++') |

+----------------------------------------+

| MYSQL++++ |

+----------------------------------------+

1 row in set (0.03 sec)

mysql> select space(15);

+-----------------+

| space(15) |

+-----------------+

| |

+-----------------+

1 row in set (0.00 sec)

mysql> select replace(www.lampung.go.id','.','dot');

'> '

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '.id',

'.','dot');

'' at line 1

mysql> select replace(www.lampung.go.id','.', 'dot ');

'> '

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '.id',

'.', 'dot ');

'' at line 1

mysql> select replace('www.lampung.go.id','.', 'dot ');

+--------------------------------------------+

| replace('www.lampung.go.id','.', 'dot ') |

+--------------------------------------------+

| wwwdot lampungdot godot id |

+--------------------------------------------+

1 row in set (0.03 sec)

mysql> select reverse(ABCDEFHTIJK');

'> '

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '');

'' at line 1

mysql> select reverse('ABCDEFHTIJK');

+------------------------+

| reverse('ABCDEFHTIJK') |

+------------------------+

| KJITHFEDCBA |

+------------------------+

1 row in set (0.00 sec)

mysql> select quote("sekarang hari jum'at");

+-------------------------------+

| quote("sekarang hari jum'at") |

+-------------------------------+

| 'sekarang hari jum\'at' |

+-------------------------------+

1 row in set (0.08 sec)

mysql> select LPAD('TI',5,'++');

+-------------------+

| LPAD('TI',5,'++') |

+-------------------+

| +++TI |

+-------------------+

1 row in set (0.00 sec)

mysql> select RPAD('TI',8,'++');

+-------------------+

| RPAD('TI',8,'++') |

+-------------------+

| TI++++++ |

+-------------------+

1 row in set (0.02 sec)

mysql> select elt(1,'TI','TK','SI',MI','KA');

'> '

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near '','KA

');

'' at line 1

mysql> select elt(1,'TI','TK','SI','MI','KA');

+---------------------------------+

| elt(1,'TI','TK','SI','MI','KA') |

+---------------------------------+

| TI |

+---------------------------------+

1 row in set (0.03 sec)

mysql> select field('TI','TI','TK','SI','MI','KA');

+--------------------------------------+

| field('TI','TI','TK','SI','MI','KA') |

+--------------------------------------+

| 1 |

+--------------------------------------+

1 row in set (0.00 sec)

mysql> select find_in_set('TK','TI,TK,SI,MA,KA');

+------------------------------------+

| find_in_set('TK','TI,TK,SI,MA,KA') |

+------------------------------------+

| 2 |

+------------------------------------+

1 row in set (0.00 sec)

mysql>

Mengutamakan Persahabatan

Di Tatasurya,di Bumi, di Indonesia, di sebuah desa yang besar yang kaya akan tanah yang subur dan tepatnya lagi di ladang tempat bermain anak-anak(gaq penting banget)...

Ricky:"will yuu kita main kejar-kejaran"
Willy:"yuu kita ajak Kevin dan Hendra juga yha"
Ricky:"yu"

setiba di rumah Kevin...

Ibu Kevin:"Hai kalian mau cari Kevin ya?dia sedang di rumah Hendra..."
Willy:"ow begitu ya~makasih ya tante"
Ibu kevin:"sama-sama"
Ricky:"kalau boleh tau kemana ya?"
Ibu kevin:"Katanya ia kerumah Hendra~"

Ricky dan Willy pu ke rumah Hendra~

Ricky:"Hen......"
Hendra:"uit??"
Ricky:"kevin mana?"
Hendra:"Kevin tuh lagi di WC~"

beberapa saat pun Kevin Kluar~

Willy:"Kev maen yuk?"
Kevin:"Gaq ah malas~"
willy:"kok gitu? uda beberapa hari ini kamu gaq pernah maen lagi sama kita~??ada apaan seh?"
Kevin:"Gaq kok malas aja...~"
Willy:"lu lagi ehm...ehm ya?"
Kevin:"paan seh??"
Willy:"itu lho Poling in loph??"
Kevin:"Falling in love kalek??Ops..!!"
Willy:"Piwid...~ma siapa tuh?"
Kevin:"mau tauk aj~!!dah ya akuw pulang dulu~"

kevin pun langsung meninggalkan mereka~

Besoknya di Skul....

Guru BI:"Kevin!!Mengapa kamu melihat Cindy terus?"
Steven:"Biasa pak....jatuh cinta lagi...lagi2 kevin jatuh cinta~"
satu kelas:Cieeee....

"tuh kan pasti kevin sedang jatuh cinta~"bisik willy kepada Ricky,"Ha???Gaq dhe gaq ikot-ikotan~"balas Ricky~"Halah jangan-jangan lu ud ada lagi~"jawab willy

Guru:"Diam-diam smua vrisik sekali kalian cuam 1 berita kok~"
Sekelas:"uuuuuuuu...."

Setelah jam sepulang sekolah~

Hendra:"wil,wil...!!!"
WillY:"hm?"
Hendra:"Will lu tau gaq cara dapetin Cindy?"
Willy:"haaa??lu suka Cindy gituh?"
Hendra:"ssstt....ntar ketahuan~"
Willy:"ew tembak aj dia~"
Hendra:"tembak~klo tembak ntar mari dung~"
Willy:"cape deh~tembak itu lho~nyatakan cinta mu~"
Hendra:"ok dhe~"

sepulang sekolah willy-pun kerumah Ricky~

Willy:"Ric lu tau gaq~kayanya Kevin dan Hendra suka...."
Ricky:"haaa???HOMO???"
Willy:"ngeres lu,denger dulu~mereka berdua tuh kayanya suka Cindy~"
Ricky:"wow bisa brantem nie~"
Willy:"tapi khan blom tentu~
Ricky:"semoga aj~"

besok sepulang sekolah lagi~
dan di belakang sekolah tepatnya ada kejadian seru~
Kevin dan Hendra sama-sama menyatakan cintanya kepada Cindy~

Willy:"Rick cari Kevin dan Hendra yuk~?"
Ricky;"YU........"

willy dan ricky pun melihat kejadian yang menghebohkan tersebut~

Willy:"tidakkkk......Cindy itu milik ku!!!!"

dan aku yakin kalian tahu~~MEREKA BERANTEM~
dan saat itu masalah persahabatan yang telah terjalin selama 5 tahun pun terpecah belah~

Ricky:"Hei,hei,hei!!!masa cuma gara-gara cewek kalian brantem sih???"

Mereka bertiga pun masih bertengkar~

Hendra:"kalau begitu biar Cindy yang menentukan....~"
Willy dan Kevin:"Boleh"

Cindy:"ehm...Sorry ya guys gue udah ada pacar gitu loh~(sok berbahasa non-baku~)"

3 orang itu:"Tidakkkkkkkkkkkk......!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"

Ricky:"sudah lah,sudah~"

mereka malah makin bertengkar dan saling memusuhi~

Ricky pun mempunyai ide bagus~
iya ingin mempertumakan mereka bertiga di satu tempat yang sama~

Ricky pun mengundang mereka untuk datang kerumah Ricky....
dan tiba2....

Willy:"apaan ini!!!!! saya tak terima masa saya belum tembak kalian udah tembak...?"
KEvin:"saya yang duluan tembak dia kaliikk..."
Hendra:"apa saya yang memberi bunganya terlebih dahulu~"
Ricky:"woi saya juga sudah menembaknya lebih dahulu tauk dan sekarang iya telah menjadi pacar kuw~"
Willy,Kevin,dan Hendra:"APA tidak mungkin~!!!!!!!"
Ricky:"sudah kubilang sudahlah sudah masa cuma gara-gara cewe ini kalian marah~?"
Willy:"sialan kamu ternyata kamu merebutnya dari ku~"
Hendra:"kita putus dari persahabatan ini~"
Kevin:"tak ada lagi persahabatan abadi kita lagi ok??"
Ricky:"tunggu, sebenarnya...."
bertiga:"ha??apa??apa??"
Ricky:"aku baru saja putus dengannya dari tadi pagi~karna bagi ku kalian yang utama~"
(sebenarnya Ricky Berbual~hehe)

mereka berempat pun makin akarab sejak itu........

TUGAS KKPI

PRESENTASI MICROSOFT POWER POINT
Presentasi adalah program paket yang digunakan atau untuk menyampaikan informasi melalui alat peraga secara langsung.
Cara membuat satu file presentasi:

• Klik start
  
• All progaram
  
• Ms office
  
• Ms office power point 2003

Cara menyimpan file presentasi :

• Klil file
• Save atau ctrl + S
• Atau klik icon disket
• Pilih lokasi penyimpanan
• Kasih nama pada file name klik save.

Cara menambah slide :

• Klik insert
  
• Klik new slide
• atau ctrl + M
• Tekan tombol enter pada area outline