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>
Diposkan oleh Chuii CRF di 23:03 0 komentar
Cara Instalasi pada MySQL
gambarnya
