Produktif TKJ

[root@server ~) # /etc/init.d/mysql

Starting MySQL:

[root@server ~]#mysql -u root  -p

Enter password:

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

Your MySQL connection  id is 4

Server version:5.0.45 Source distribution

Type 'help;

 information_schema

 kelas2c

 mysql

 test

4rows in set (0.08 sec)

mysql>show databases

 Database

 information_schema

 kelas2c

 mysql

 test

4 rows in set (0.00 sec)

mysql>create database kelas2e;

Query OK,1 row affected (0.00 sec)

mysql>use kelas2e;         Database->Table->Field->Record

Database changed

mysql>Create table Siswa(nis,nama,kelas,dll......                            ),

    ->nis varchar(6) primary key,

    ->nama varchar (30),

    ->kelas varchar (5),

    ->

    ->jkl char(1));

Query OK 0 rows diffected (0.00 sec)

mysql>show

l jkL l char(1) l YES  l    l

4 rows in set (0.06 sec)

mysql> show column from siswa;

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

 corresponds to your MySQL server version for the right syntax to use 

nis varchar(6)  YES  NULL

nama varchar(30) YES NULL

kelas varchar(5)  YES  NULL

jkl char(1)    YES  NULL

4 rows in set (0.00 sec)

mysql> insert into siswa(

    -> nis, nama, kelas,jkl)value ('090087','Lina','2E','P');

Query OK

mysql> select *from siswa order by nama ASC;

nis     nama

098965  Arif

090087  Bejo

090080  Lina

mysql> select *from siswa where jkl='P';

nis  nama  jkl