Scribd
Upload
3 views7 pages

SQL Basics for Database Management

Uploaded by

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

SQL Basics for Database Management

Uploaded by

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

DATABASE

MANAGEMENT
SYSTEMS LAB
E.S. RAKESH KUMAR (Asst. Prof)
Department of
Computer Science & Engineering,
Bhaskar engineering college.
Form of basic SQL QUERY
 SQL: Structured query language.
SQL: access and manipulate data in database.
In order to execute SQL,we use different DBMS TOOLS:
MySQL
SL server
Oracle SQL etc
In SQL we have
 C R U D operations
create, Read, Update, delete
How to create a table in SQL

 MySQL>CREATE TABLE EMPLOYEE(


EMP NO INTEGER;
EMP NAME VARCHAR;
………………);
THE TABLE GETS CREATED
 TO VIEW TABLE
 MYSQL>DESC TABLE NAME;
 TO INSERT VALUES IN THE TABLE

MYSQL> INSERT INTO TABLE(EMP NAME,EMP NO…..);


 TO VIEW THE INSERTED TABLE
MYSQL>SELECT* FROM EMPLOYEE;


UPDATE AND RENAME

 Syntax
 SYNTAX
 MYSQL>alter table table
 MYSQL>update table where
name rename column
column no =;
To get table
To get table
MYSQL>SELECT*FROM TABLE
MYSQL>SELECT*FROM TABLE
THANK YOU

You might also like