Tugas DDL 2

Kelompok 10 DDL 2:

Kelas : 12.2E.04

Nama :1. Andro Dewa (12173142)

            2. R. Wisnu Murti (12171976)

            3. Haris Eko (12172455)

            4. Tarman Kiswanto (12172936)

            5. Agung Supriyadi (12173528)

1.”xampp/mysql/bin/mysql.exe” –u root –p

2.create database,show databases;

3.use db_les_private;

4.create table siswa(Nis char(6) primary key,Nama varchar(40),Tgl date,Kelas varchar(15),No_telp varchar(18));

5.show tables;

6.desc siswa;

7.alter table siswa change nama nama_siswa varchar(30);

8.alter table siswa change tgl tgl_lahir date;

9.alter table siswa change kelas kelas_siswa varchar(20);

10.alter table siswa drop no_telp;

11.alter table siswa rename siswa_baru;

12.desc siswa_baru;

13.create table tutor(id_tutor char(8),nama_tutor varchar(38),jenis varchar(20),jml_kelas smallint(4)); ,create table ruang(id_ruang char(3),nama_ruang varchar(10));

14.desc tutor; ,desc ruang;

15.alter table tutor add primary key(id_tutor);

16.alter table tutor modify jml_kelas int(4);

17.desc ruang; ,alter table ruang modify id_ruang int;

18.drop table ruang;

19.alter table tutor rename tutor_les;

20.show tables;