To boldly go where no SQL has gone before Part 2
Let’s continue looking at a database schema for storing details of every Star Trek Episode. If you are new to databases, a schema is just the design of the structure of t...
PACK_KEYS in MySQL
ACK_KEYS is the MySQL features used to generate packed index for MYISAM storage engines. PACK_KEYS is an optional option, used with the MySQL CREATE TABLE statement which...
Getting started with IBM Bluemix and MySQL
While creating a web application in IBM Bluemix using J2EE and MySQL, my colleagues and I learned a few things about database connectivity that I’d like to share on this ...
New Nginx stack with PHP and MySQL (LEMP)
LEMP, WEMP and MEMP for Linux, Windows and OSX respectively, it provides a ready to run environment with the Nginx Web Server, PHP and MySQL....
NewSQL Vs. SQL on Hadoop
NoSQL, NewSQL, SQL on Hadoop – SQL seems to be everywhere these days. The data management landscape is complex and moving very fast.......
|Most Popular Resource in the Category|
Importing CSV data into MySQL with a PHP script
This tutorial will show you how to import csv data into MYSQL with a simple PHP script. Many times you have to write a script because the import function in phpMyAdmin wi...
How To Create a Custom Function in MySQL
With MySQL 5.x, you can create custom functions that can be invoked from other SQL statements. Here is an example of creating a custom function called OverlapSeconds() th...
Basic Database Design
Database design is becoming key to developing applications. Almost all web applications are driven by a database, and with Core Data, Cocoa applications are starting to h...