Created
August 20, 2016 07:17
-
-
Save saifiahmada/e41b9e4cc9032f7446d43f0df9c84336 to your computer and use it in GitHub Desktop.
perintah dasar mariadb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql -uroot -p | |
show databases; | |
create database belajar_mariadb; | |
use belajar_mariadb; | |
show tables; | |
show create table mahasiswa; | |
alter table mahasiswa add column no_hp varchar(13); | |
alter table mahasiswa modify column nama varchar(100); | |
desc mahasiswa; | |
drop table mahasiswa; | |
show tables; | |
drop database belajar_mariadb; | |
show databases; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment