UAS Basis Data 2

Create

Drop

Update

Alter

MySQL

SQL

Oracle

PhpMyAdmin

Kecepatan

Kemudahan

Mendukung Query Language

Harga Mahal

create database UAS;

use UAS

show tables;

create database uas

use uas

show tables

create database UAS;

use UAS

show tabels;

create UAS;

use UAS

show tables;

Int

timestamp

Longfloat

timeyear

drop

Alter

Insert

create

insert into mhs

(nim, nama, alamat)

("C030319192", "Rena", "AMD permai"),

("C030319193", "Subhan", "Kayutangi 2");

insert into mhs

(nim, nama, alamat)

values

("C030319192", "Rena", "AMD permai"),

("C030319193", "Subhan", "Kayutangi 2");

insert into mhs

(nim, nama, alamat)

value

("C030319192", "Rena", "AMD permai"),

("C030319193", "Subhan", "Kayutangi 2");

insert into mhs

(nim, nama, alamat)

values

("C030319192", "Rena", "AMD permai"),

("C030319192", "Subhan", "Kayutangi 2");

Desc

Describe

Show columns from

desc table

select all from mahasiswa;

select * from mahasiswa.

select # from mahasiswa;

select * from mahasiswa;

SELECT * FROM mahasiswa WHERE nama=Bayu;

SELECT ALL FROM mahasiswa WHERE nama LIKE ‘Bayu’;

SELECT nama FROM mahasiswa WHERE nama=’Bayu’;

SELECT * FROM mahasiswa WHERE nama=’Bayu’;