Category: Javaskool Category

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...

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...

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 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...

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...

MySQL Constraints UNIQUE Constraint PRIMARY KEY Constraint Defining Auto-Increment Referential Integrity Constraints CHECK Constraint DEFAULT Constraint Examples MySQL Constraints MySQL also supports many types of constraints to support data integrity. A constraint can be...

MySQL Index Examples MySQL Index Indexes on data tables speed up searches which cut down the time it takes to execute complex queries. Scanning a sorted index is quicker and more efficient access than...

Using Auto_Increment Downloads Examples Using Auto_Increment The AUTO_INCREMENT attribute can be used to generate a unique identity or ID for newly inserted rows. CREATE TABLE employee ( emp_id MEDIUMINT NOT NULL AUTO_INCREMENT, emp_name CHAR(30)...

MySQL Insert Record MySQL Replace Record MySQL Update Record MySQL Delete Record Downloads Examples MySQL Insert Record The INSERT Command Inserting Data in a MySQL Database Once tables have been created, the database sits...