Database

Tutorial MongoDB

14 Jul 2017

Contoh Database { firstname:"dodot", lastname:"didit", memberships: ["mem1", "mem2"], address:{ street: "jl. pramuka sokaraja", city:"banyumas" } contacts:[ {name:"brath", relationship:"friend"}, ] } Membuat Tabel > use mycustomers switched to db mycustomers > db mycustomers Membuat user db.createUser({ user:"didit", pwd:"12345", roles: ["readWrite", "dbAdmin"] }); Membuat collection / table > db.createCollection('customers'); Insert data ke collection customers > db.customers.insert({first_name:"wirog", last_name:"sebastian"}); WriteResult({ "nInserted" : 1 }) Insert 2 data > db.

Belajar MySql/MariaDb

By tipobrata in database

06 Jul 2017

Login ke terminal mysql cd /opt/lampp/bin $ ./mysql -u testuser -p Create Table MASTER create table t_master as select 1 id, 'A' data union all select 2 id, 'B' data union all select 3 id, 'C' data; MariaDB [testdb]> select * from t_master; +----+------+ | id | data | +----+------+ | 1 | A | | 2 | B | | 3 | C | +----+------+ 3 rows in set (0.