Category: MySQL

mysqlCertificationPath.png 0

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

mysqlForWindows0.png 0

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

mysqlForWindows3.png 0

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 0

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 0

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 0

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 Constraints 0

MySQL Server : Open Source Database : MySQL Constraints

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 Server : Open Source Database : MySQL Index 0

MySQL Server : Open Source Database : MySQL Index

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