MySQL is an open-source relational database management system. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data.

It’s free and open-source software under the terms of the GNU License, and is also available under a variety of proprietary licenses.

nodejs - node-orm2 — Node.js Object Relational Mapping 🧭

node-orm2 — Node.js Object Relational Mapping 🧭

ORM Package for Node.js. Works with MySQL, PostgreSQL and SQLite. var orm = require('orm'); orm.connect("mysql://username:password@host/database", function (err, db) { if (err) throw err; var Person = db.define('person', { name : String, surname :...

Cover Image by MilesAndryPrower on DeviantArt

MySQL Select Statements

The SELECT statement is used to select or fetch data from a your MySQL Database. It’s the most common type of query issued to a database. There are many ways to query a database, but were going to focus on the SELECT statement...

Cover Image by MilesAndryPrower on DeviantArt

☑ Optimize a MySQL database

If you have deleted a large part of your table or updated many variable length rows, you should consider running the optimize command. If you want to quickly generate the optimize commands for every table in you database, executing the...

mongodb - SQL to Mongo correspondence table

SQL to Mongo correspondence table

This list is the PHP version »SQL to Mongo correspondence table (there is a more general version in the official MongoDB manual). SQL queryMongo query statementCREATE TABLE USERS (a Number, b Number)Implicit creation...

what is php 3 1 - Simple PHP & MySQL Pagination

Simple PHP & MySQL Pagination

When looking at MySQL output, it is sometimes more convenient to split up the number of records returned into separate pages and include hyperlinks to further pages in the result set, a layout often referred to as pagination. The following is an...

what is php 3 1 - Simple PHP .htpasswd 🔑 Manager

Simple PHP .htpasswd 🔑 Manager

Sometimes simplicity is also convenient, and in the case of authentication on the most popular web server, Apache, .htpasswd fits the bill You may opt for a PHP/MySQL login which in itself is simple enough, but requires the availability of MySQL. If...