Tugas ERD

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>

Tugas KKPI Ms.Power Point

Cara membuat file presentasi:

· Klik start.

· All program.

· Microsoft Office 2003.

· Microsoft Office Power Point 2003.

Cara mengubah Background:

• Klik Format.
• Pilih Background.
• Klik segitiga full down.
• Pilih Background yang anda inginkan.
• Klik OK.
• Klik Apply atau Apply to All.

Cara memberi efek dan animasi:

• Klik Slide Show.
• Pilih Custom Animation.
• Klik Title atau Subtitle.
• Lalu klik Add Effect.
• Pilih Effect yang anda inginkan.
• Klik OK.

Cara menyimpan file:

• Klik File.
• Pilih Save As / Ctrl+S atau klik icon disket.
• Pilih lokasi penyimpanan.
• Beri nama pada file name.
• Klik Save.

Cara untuk menambah Slide:

• Cara pertama:

• Klik menu bar insert.
• Pilih new slide.

• Cara kedua:
• Ctrl+M

• Cara ketiga:
• Tekan tombol enter pada area Outline.

kalo d'fikir" cinta tyu gtu" za...

• ngeliat,
• suka,
• kenalan,
• minta no hape,
• smsan,
• PDKT,
• ngedate,
• nembak,
• jadian,
• berantem,
• putuszz!!!
• nangis"
• jomblo agy dech...!!!

V coba bandingin ma persahabatan.....

• ngeliat,
• suka,
• kenalan,
• minta no hape,
• smsan,
• ketemu agy,
• jalan bareng,
• seneng" bareng,
• sedih bareng,
• terpisah jarak,,,
• V te"p bisa smsn,,,,

N 1 agy,,

da mantan pacar,V gax da yang nama'y mantan temen....!!!!

cinta...???!!!!
pa se cinta tyu...???kalo d'fikir" cwo tyu smua'y sma ya...???
smua'y brengsek...!!!Susah banget pengen nyari cowo yang bener ...!!!
V napa Qta tyu te"p butuh cowo padahal Qta tw kalo cowo tyu k'banyakan'y brengsek...
V mang ga smua cowo brengsek se....!!!!V ma'af za ya buat cowo"yang ngerasa kesindir....???!!!
V mang tyu fakta yang Q temuin...
ya V mudah"an cowo"yang ngerasa brengsek tyu cpet"tobat ya...???
inget za,karma tyu masih ada... dan pasti'y masih berlaku...!!!!
jangan d'kira cowo tyu bisa seenaknya mainin perasaan cewe...!!!

Makna Cinta

Cinta adalah suatu perasaan yang timbul pada diri Qta untuk menyayangi,memiliki dan melindungi seseorang yang Qta cintai.Cinta itu anugrah terindah dari Tuhan Yang Maha Esa.Dari mulai diciptakannya manusia,Dia telah memberikan rasa cinta itu.
Cinta diberikan oleh Tuhan agar manusia bisa hidup saling menyayangi.Dari waktu ke waktu,cinta gak pernah bisa luput dari fikiran manusia.Apalagi bagi remaja yang sedang masa-masa rentannya buat terjangkit virus love.
Cinta itu gak kan pernah lenyap dimakan waktu sampai suatu hari nanti(kiamat).Cinta itu barulah sirna dari fikiran manusia.
cinta punya kekuatan buat bikin hati kita berubah-ubah,kadang kita sedih,senang,kesal,marah,rindu,bahkan rela mati bunuh diri gara-gara putus cinta.
Cinta gak cuma nerima aja tapi kita juga harus rela ngorbanin sesuatu yang paling berharga buat orang yang paling kita cintai,tapi jangan sampai rela ngorbanin virgin(keperawanan) demi pacar yang belum tentu jadi jodoh kita.