Scribd
Upload
2 views1 page

MySQL Steps.pdf

The document provides a series of MySQL commands for creating and managing a database named 'Arihant'. It includes commands to create a 'Student' table, insert records, and query data based on gender. The commands demonstrate basic database operations such as creating a database, showing tables, and selecting data from a table.

Uploaded by

nupurpillai1017
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
2 views1 page

MySQL Steps.pdf

The document provides a series of MySQL commands for creating and managing a database named 'Arihant'. It includes commands to create a 'Student' table, insert records, and query data based on gender. The commands demonstrate basic database operations such as creating a database, showing tables, and selecting data from a table.

Uploaded by

nupurpillai1017
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

Start MySql Shell

Type command-> \sql

Command to create database

CREATE DATABASE Arihant;

show databases;
use Arihant;

Create table Student(rollno int primary key, name varchar(50), gender char);

show tables;

desc Student;

insert into Student(rollno, name, gender) values


(1, ’Neha’, ‘F’), (2, ‘Rehan’,’M’), (3,’Isha’,’F’), (4,’Saksham’,’M’), (5,’Tanmay’,’M’);

Select * from Student;

Select * from Student where gender=’M’;

You might also like