What is NoSQL?
NoSQL (Not Only SQL) is a broad category of database management systems that are designed to handle large volumes of unstructured, semi-structured, or structured data in a way that differs from traditional relational databases...
Category: Database
Dr. E. F. Codd’s 12 rules of RDBMS
Dr. E. F. Codd’s 12 rules for fully RDBMS Note that based on these rules there is no fully relational database management system available today. In particular, rules 6, 9, 10, 11 and 12...
MySQL Server : Open Source Database : MySQL Introduction
MySQL Intro Why MySQL? Features and Benefits of MySQL MySQL Products MySQL Certification Program MySQL Website MySQL Architecture MySQL Intro MySQL Database : Open Source Database solution -The MySQL Database powers the most demanding...
MySQL Server : Open Source Database : MySQL Setup
MySQL Setup for Windows MySQL Setup for Linux Check MySQL Version MySQL Setup for Windows Install MySQL Server 5 or above on windows Click here to Download MySQL Community Server Click double on below...
MySQL Server : Open Source Database : Connecting MySQL
MySQL Connection with Windows MySQL Connection with Linux Check MySQL Version MySQL Connection with Windows Try Login by selecting “MySQL 5.5 Command Line Client” option as below Login with MySQL Server Enter password: *****...
MySQL Server : Open Source Database : Create Database
Create Database MySQL Utility Statement Example for CREATE DATABASE MYSQLADMIN command for creating DATABASE Create Database It helps to create a database with the given name. To use this statement, you need the CREATE...
MySQL Server : Open Source Database : Alter Database
Alter Database Examples Alter Database ALTER DATABASE command helps to modify database specification and also help to rename database; Syntax ALTER {DATABASE | SCHEMA} [db_name] alter_specification … ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA...
MySQL Server : Open Source Database : Drop Database
Drop Database Drop Database using mysqladmin command Examples Drop Database DROP DATABASE drops all tables in the database and deletes the database. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name The DROP DATABASE statement removes...
MySQL Server : Open Source Database : MySQL DataTypes
MySQL DataTypes Working with NULL Values Comment in MySQL Examples MySQL DataTypes Every table is composed of a number of columns. For each column, an intended data type must be specified. A data type...
MySQL Server : Open Source Database : Create/Alter/Drop Table
CREATE Table Creating Column Definitions Defining Table Types Options and Attributes CREATE Table Example ALTER Table DROP Table Examples CREATE Table It creates additional tables in the database using CREATE TABLE First, we must...
Recent Comments