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 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 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: *****...
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...
Recent Comments