jawabankuis1

2
mysql> create table tblMahasiswa ( -> NIM Char(9) Not Null Primary Key, -> NamaMhs Varchar(25), -> TglLahir Date Not Null Default '1989-12-31', -> TB SmallInt(3) Not Null Default 155); Query OK, 0 rows affected (0.08 sec) mysql> desc tblMahasiswa; +----------+-------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+------------+-------+ | NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TglLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | +----------+-------------+------+-----+------------+-------+ 4 rows in set (0.05 sec) mysql> alter table TblMahasiswa ADD BB TinyInt(3) Unsigned Not NUll Default 50; Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc tblMahasiswa; +----------+---------------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+------------+-------+ | NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TglLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | | BB | tinyint(3) unsigned | NO | | 50 | | +----------+---------------------+------+-----+------------+-------+ 5 rows in set (0.00 sec) mysql> alter table TblMahasiswa change TglLahir TanggalLahir Date Not Null Defau lt '1989-12-31'; Query OK, 0 rows affected (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc tblMahasiswa; +--------------+---------------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+------------+-------+ | NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TanggalLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | | BB | tinyint(3) unsigned | NO | | 50 | | +--------------+---------------------+------+-----+------------+-------+ 5 rows in set (0.00 sec) mysql> rename table TblMahasiswa to TblMhs; Query OK, 0 rows affected (0.02 sec) mysql> show tables; +------------------+ | Tables_in_dataku | +------------------+ | tblmhs | +------------------+

Upload: yusup

Post on 11-Apr-2016

213 views

Category:

Documents


1 download

TRANSCRIPT

mysql> create table tblMahasiswa ( -> NIM Char(9) Not Null Primary Key, -> NamaMhs Varchar(25), -> TglLahir Date Not Null Default '1989-12-31', -> TB SmallInt(3) Not Null Default 155);Query OK, 0 rows affected (0.08 sec)

mysql> desc tblMahasiswa;+----------+-------------+------+-----+------------+-------+| Field | Type | Null | Key | Default | Extra |+----------+-------------+------+-----+------------+-------+| NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TglLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | +----------+-------------+------+-----+------------+-------+4 rows in set (0.05 sec)

mysql> alter table TblMahasiswa ADD BB TinyInt(3) Unsigned Not NUll Default 50;Query OK, 0 rows affected (0.08 sec)Records: 0 Duplicates: 0 Warnings: 0

mysql> desc tblMahasiswa;+----------+---------------------+------+-----+------------+-------+| Field | Type | Null | Key | Default | Extra |+----------+---------------------+------+-----+------------+-------+| NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TglLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | | BB | tinyint(3) unsigned | NO | | 50 | | +----------+---------------------+------+-----+------------+-------+5 rows in set (0.00 sec)

mysql> alter table TblMahasiswa change TglLahir TanggalLahir Date Not Null Default '1989-12-31';Query OK, 0 rows affected (0.05 sec)Records: 0 Duplicates: 0 Warnings: 0

mysql> desc tblMahasiswa;+--------------+---------------------+------+-----+------------+-------+| Field | Type | Null | Key | Default | Extra |+--------------+---------------------+------+-----+------------+-------+| NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | TanggalLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | | BB | tinyint(3) unsigned | NO | | 50 | | +--------------+---------------------+------+-----+------------+-------+5 rows in set (0.00 sec)

mysql> rename table TblMahasiswa to TblMhs;Query OK, 0 rows affected (0.02 sec)

mysql> show tables;+------------------+| Tables_in_dataku |+------------------+| tblmhs | +------------------+

1 row in set (0.00 sec)

mysql> alter table TblMahasiswa ADD JenisKel Enum('Pria','Wanita') Not NUll after NamaMhs;ERROR 1146 (42S02): Table 'dataku.tblmahasiswa' doesn't existmysql> alter table TblMhs ADD JenisKel Enum('Pria','Wanita') Not NUll after NamaMhs;Query OK, 0 rows affected (0.05 sec)Records: 0 Duplicates: 0 Warnings: 0

mysql> desc tblMhs;+--------------+-----------------------+------+-----+------------+-------+| Field | Type | Null | Key | Default | Extra |+--------------+-----------------------+------+-----+------------+-------+| NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | JenisKel | enum('Pria','Wanita') | NO | | | | | TanggalLahir | date | NO | | 1989-12-31 | | | TB | smallint(3) | NO | | 155 | | | BB | tinyint(3) unsigned | NO | | 50 | | +--------------+-----------------------+------+-----+------------+-------+6 rows in set (0.00 sec)

mysql> alter table TblMhs Modify TB TinyInt(3) Unsigned Not NUll Default 150;Query OK, 0 rows affected (0.01 sec)Records: 0 Duplicates: 0 Warnings: 0

mysql> desc tblMhs;+--------------+-----------------------+------+-----+------------+-------+| Field | Type | Null | Key | Default | Extra |+--------------+-----------------------+------+-----+------------+-------+| NIM | char(9) | NO | PRI | | | | NamaMhs | varchar(25) | YES | | NULL | | | JenisKel | enum('Pria','Wanita') | NO | | | | | TanggalLahir | date | NO | | 1989-12-31 | | | TB | tinyint(3) unsigned | NO | | 150 | | | BB | tinyint(3) unsigned | NO | | 50 | | +--------------+-----------------------+------+-----+------------+-------+6 rows in set (0.00 sec)

mysql> insert into TblMhs Values -> ('222070001','Bambang H','Pria','1989-12-13',159,55);Query OK, 1 row affected (0.03 sec)

mysql> select * from tblMhs;+-----------+-----------+----------+--------------+-----+----+| NIM | NamaMhs | JenisKel | TanggalLahir | TB | BB |+-----------+-----------+----------+--------------+-----+----+| 222070001 | Bambang H | Pria | 1989-12-13 | 159 | 55 | +-----------+-----------+----------+--------------+-----+----+1 row in set (0.05 sec)

mysql> \t