Comand Promt Mysql

Sabtu, 05 September 2015


change direktori dulu

cd ../..

cd xampp/bin

masuk mysql

mysql -u root

create data base

CREATE DATABASE PRAKTIK;

SHOW DATABASES;

USE PRAKTIK;

SHOW TABLES;

perintah insert
insert into post(id,nama,body) values('1','h','juga');

perintah select

select * from post;

perintah update

update post set nama='halo' where id=1;

perintah delete

delete from post where id=1;