Tags » Database

[ MYSQL ] - Penjabaran SQL JOIN

Assalamualaikum wr. Wb

Terkadang kita membutuhkan data dari dua buah table yang berbeda, maka dalam query kita mudah saja untuk mengambilnya. Yang jadi permasalahan adalah, JOIN apa yang harus kita pakai untuk memudahkan dalam pengambilan data dalam dua table ?? 46 more words

Database

[ MYSQL ] - Cek Row Duplikat

Assalamualaikum wr wb

Sudah lama saya tidak menulis tentang MYSQL padahal sudah sekitar satu bulan ini saya ngotak ngatik query yang ada di Engine DB Mysql. 123 more words

Database

Generate Sequence in Mysql trough Query

Syntax : select @r:=@r+1,

from (select @r:=0)

table name 

………

Example : select @r:=@r+1 as Sequence,Info from
(select @r:=0)t,
(
select ‘sagar’ as Info
union… 24 more words

Database

Project Mezzanine: The Great Migration at Uber Engineering

What happens when you have to migrate hundreds of millions of rows of data and more than 100 services over several weeks while simultaneously keeping Uber running for millions of riders? 24 more words

Ubernomics

The FBI’s secret biometrics database they don’t want you to see

From RT America

The Federal Bureau of Investigation (FBI) wants to prevent information about its creepy biometric database, which contains fingerprint, face, iris, and voice scans of millions of Americans, from getting out to the public. 803 more words

Tyranny

TRIAL DATABASE: MethodsNow

MethodsNow is on trial until 15 June 2016.

MethodsNow is a module of the SciFinder database which is used for research and comparison in chemical analysis methods. 35 more words

Bilkent