Practical
Оценка 5

Practical

Оценка 5
docx
09.05.2020
Practical
Practical.docx

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

 

Field

Data Type

DEPARTMENT_ID

Int(5)

DEPARTMENT_NAME

Varchar(20)

MANAGER_ID

Int(5)

 

Write the sql scripts on the space below


 

Practical Instruction for opening the

Practical Instruction for opening the

Exercise (A )Create a table for the following structure

Exercise (A )Create a table for the following structure
Скачать файл