[go: up one dir, main page]
Scribd
Upload
93 views3 pages

MySQL Basics for CSE Students

This document provides instructions for creating a database and table using MySQL on Xampp server. It first explains what a database is and how to start the Xampp server. It then gives the steps to open the command prompt and navigate to the MySQL bin directory. Finally, it outlines how to create a new database called "DigitalGames" and a table within it called "BasicList" with three columns - serial, game name, and platform.

Uploaded by

Nahim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
93 views3 pages

MySQL Basics for CSE Students

This document provides instructions for creating a database and table using MySQL on Xampp server. It first explains what a database is and how to start the Xampp server. It then gives the steps to open the command prompt and navigate to the MySQL bin directory. Finally, it outlines how to create a new database called "DigitalGames" and a table within it called "BasicList" with three columns - serial, game name, and platform.

Uploaded by

Nahim
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Green University of Bangladesh

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Database System Lab (CSE-210)

Introduction to MySQL

Lecturer:
Author: Mr. Md. Shakhawat Hossain
Mahadi Ahammed Lecturer
ID: 182002006 Department of Computer Science and
Section: DB Engineering,
Green University of Bangladesh

Remark

February 13, 2020


1 Objective
The objective of this experiment is to learn about the basics of database and how to create a
database and a table in that database.

2 Equipment
1. A computer (we using windows operating system)

2. Xampp Software

3 What Is Database
A database is an organized collection of data, generally stored and accessed electronically from
a computer system. Where databases are more complex they are often developed using formal
design and modeling techniques.

4 Starting Xampp Server


• At first we need to install xampp on the computer.

• Go to the directory where you installed xampp.

• Find xampp-control.exe and open it.

• Start both Apache and MySQL.

5 Instructions

• Go to this directory xampp mysql bin.

• Write down the address of that directory.

• Go to the windows Search operation and search for cmd. Or hold down windows button
+ R and type cmd and click OK.

• This will open windows Command prompt (command line interpreter of Windows).

• Type cd/ and press Enter.

• Now type the drive name and press Enter.

1
• Type “cd xampp \ mysql \ bin” and press Enter.

• Now type “mysql -u root -p -h 127.0.0.1” and press enter. It will want password, we need
to press ‘Enter’ again.

6 Creating A New Database & A Table


• Now if we type ‘show databases’, it will show all databases.

• To create new database we will use ‘create’ : “create database DigitalGames;”.

• To use the created database : “use DigitalGames;”.

• To create a table : CREATE TABLE BasicList (serial int(11)unsigned auto increment


primary key not null, Game name VARCHAR(25) not null, platform varchar(20) not
null);

• If we use “show tables” command we can see the all tables in the database.

A New Database & A Table

You might also like