Practical

Practical

Instruction for opening the MySql Database

Launch XAMPP software

·         Start the Apache

·         Start the MySql

·         Click on the ‘Admin’ button on XAMPP Control Panel

Practical 1

Steps to create a database

Using scripts

CREATE TABLE CUSTOMER  (

CUST_ID INT NOT NULL,

CUST_NAME VARCHAR (20) NOT NULL,

City CHAR (25));

View the structure

1.     

2.       

3.       

4.       

See the structure of the ‘customer’ table

Or type in DESC command in SQL tab

Exercise

(A )Create a table for the following structure

Table : Deptartment

DEPARTMENT_ID

MANAGER_ID

Write the sql scripts on the space below