Tags » Mysql

MySQL 5.7 - Index Condition Pushdown Optimization Bug

MySQL 5.7 – Index Condition Pushdown Optimisation Bug

Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index.  95 more words

Database

OwnCloud (Your very own Dropbox)

Are you interested in having your very own Dropbox like service setup. Then you have come to the right place. A little while ago I came across an opensource application known as “OwnCloud.” OwnCloud provides very similar functionality to the likes of services like ‘Dropbox’ or ‘Google Drive,’ that allow users to backup their files and sync them across multiple devices. 1,590 more words

Owncloud

Kulik perbedaan Web Statis dengan Web Dinamis

Buat yang masih gak tau apa itu website, di artikel saya sebelumnya saya sudah menjelaskan pengertian dari website itu sendiri. Siapa yang masih bingung dengan perbedaan Web Statis dengan Web Dinamis hayo? 388 more words

Design

Koneksi PDO ke MySQL

PDO seperti sudah menjadi hal yang wajib dalam PHP, mengapa ? karena sekarang serba “OOP”, rata-rata dibahasa pemrograman apapun dan framework apapun mengharuskan kita untuk menggunakan konsep OOP. 112 more words

Pdo

Moving persistent data out of Redis

Historically, we have used Redis in two ways at GitHub:

We used it as an LRU cache to conveniently store the results of expensive computations over data originally persisted in Git repositories or MySQL. 245 more words

Programming

Ordenar datos NULL con SQL

Este es un dato o Tips que recurrentemente surge cuando en las tablas datos definidos como NULL. Un valor NULL corresponde a un valor NO DEFINIDO o bien NO ASIGNADO, lo que no necesariamente corresponde a un dato con valor cero (0) ni tampoco al de cadena vacía (”) ya que éstos si son valores conocidos, Entonces, si NULL es un valor indefinido ¿Como podríamos ordenar ascendente o descendentemente algo que no sabemos que es? 186 more words

SQL

Create a new user on the MySQL CLI

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';