ERD

sql

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('technik informatika');
+------------------------------+
| lcase('technik informatika') |
+------------------------------+
| technik informatika |
+------------------------------+
1 row in set (0.02 sec)

mysql> select lower('technik informatika');
+------------------------------+
| lower('technik informatika') |
+------------------------------+
| technik informatika |
+------------------------------+
1 row in set (0.00 sec)

mysql> select ucase('technik informatika');
+------------------------------+
| ucase('technik informatika') |
+------------------------------+
| TECHNIK INFORMATIKA |
+------------------------------+
1 row in set (0.00 sec)

mysql> select upper('technik informatika');
+------------------------------+
| upper('technik informatika') |
+------------------------------+
| TECHNIK INFORMATIKA |
+------------------------------+
1 row in set (0.00 sec)

mysql> select substring('technik informatika', 6);
+-------------------------------------+
| substring('technik informatika', 6) |
+-------------------------------------+
| ik informatika |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> select substr('computer', 3);
+-----------------------+
| substr('computer', 3) |
+-----------------------+
| mputer |
+-----------------------+
1 row in set (0.00 sec)

mysql> select substring('teknik informatika',2,6);
+-------------------------------------+
| substring('teknik informatika',2,6) |
+-------------------------------------+
| eknik |
+-------------------------------------+
1 row in set (0.00 sec)

mysql> select substring('tehnik informatika',8,11);
+--------------------------------------+
| substring('tehnik informatika',8,11) |
+--------------------------------------+
| informatika |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> select substring('tehnik informatika'.-11,5);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t
corresponds to your MySQL server version for the right syntax to use near '.
5)' at line 1
mysql> select substring('tehni infortika',-18'5);
'> SELECT SUBSTRING('TEHNIK INFORMATIKA',-11, 5');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t
corresponds to your MySQL server version for the right syntax to use near ''
SELECT SUBSTRING('TEHNIK INFORMATIKA',-11, 5')' at line 1
mysql> SELECT SUBSTRING('TEHNIK INFORMATIKA',-11, 5);
+----------------------------------------+
| SUBSTRING('TEHNIK INFORMATIKA',-11, 5) |
+----------------------------------------+
| INFOR |
+----------------------------------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT SUBSTRING('TEHNIK INFORMATIKA',-18,18
-> select substring('tehni infortika',-18, 18)
->
-> select substring('tehni infortika',-18, 18);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t
corresponds to your MySQL server version for the right syntax to use near 's
t substring('tehni infortika',-18, 18)

select substring('tehni infortika',' at line 2
mysql> SELECT SUBSTRING('TEHNIK INFORMATIKA',-18, 18);
+-----------------------------------------+
| SUBSTRING('TEHNIK INFORMATIKA',-18, 18) |
+-----------------------------------------+
| TEHNIK INFORMATIKA |
+-----------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT LEFT(TEHNIK INFORMATIKA', 6);
'> SELECT LEFT('TEHNIK INFORMATIKA', 6);
'> SELECT LEFT(TEHNIK INFORMATIKA',6);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t
corresponds to your MySQL server version for the right syntax to use near 'I
MATIKA', 6);
SELECT LEFT('TEHNIK INFORMATIKA', 6);
SELECT LEFT(TEHNIK INFOR' at line 1
mysql> SELECT LEFT('TEHNIK INFORMATIKA', 6);
+-------------------------------+
| LEFT('TEHNIK INFORMATIKA', 6) |
+-------------------------------+
| TEHNIK |
+-------------------------------+
1 row in set (0.00 sec)

mysql> SELECT RIGH('TEHNIK INFORMATIKA', 11);
ERROR 1305 (42000): FUNCTION RIGH does not exist
mysql> SELECT RIGHT('TEHNIK INFORMATIKA', 11);
+---------------------------------+
| RIGHT('TEHNIK INFORMATIKA', 11) |
+---------------------------------+
| INFORMATIKA |
+---------------------------------+
1 row in set (0.00 sec)

mysql> SELECT ASCTI('5');
ERROR 1305 (42000): FUNCTION ASCTI does not exist
mysql> SELECT ASCII('5');
+------------+
| ASCII('5') |
+------------+
| 53 |
+------------+
1 row in set (0.00 sec)

cara mermbuat file presentasi
*klik start
*klik All programs
*klik ms office -ms.office power point
*blank presentation
cara menyimpan file presentation
*klik file
*save(ctrl+s)/klik icon disket
*klik/pilih lokasi penyimpanan
*kasih nama pada file name
*klik save
untuk menambah slide pada power point
*klik menubar insert
*pilih new slide/ctrl+m
cara ke 2:
*trkan tombol enter pada area outline

CREDIBILITY

friends,..salah satu langkah awal yang mesti kita tempuh dalam karir hidup ini tuh tekad toek menjadi seorang muslim yangsangat jujur dan terpercaya sampe mati.seperti halnya rasulullah saw yang memulai karier kehidupannya tuw dengan gelar al-amien(orang yang sangat terpercaya)brouu..sebelum nabi muhammad saw dikukuhkan menjadi seorang rasul,beliau sudah sangat populer fi tengah masyarakat makkah sebagai pribadi yang sangat terpercaya dan amanah atau kredibel.
yawdh ddd..,daripada bingung,,mendingan kita enjoy aja dengan waktu muda kita dengan se efektif mungkin .okeee?
THANKS FOR ATTENTION