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;
