Scribd
Upload
5 views2 pages

Intro to SQL for Web Development

Uploaded by

xafariqbal333
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
5 views2 pages

Intro to SQL for Web Development

Uploaded by

xafariqbal333
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

Address :- New Delhi Contact :- 8882880965

STP COMPUTER EDUCATION


The Best Quality of Software Programming Computer Education
[Link]

SUBJECT :- WEB DEVELOPMENT

Chapter - 1
Intro to SQL
STRUCTURED QUERY LANGUAGE

DATABASE

DATABASE LANGUAGE DATABASE SOFTWARE

SQL MYSQL

DATABASE SOFTWARE
We use database software to store data.

DATABASE LANGUAGE
We use database language (SQL) to control the behavior of database
software (MYSQL)

SQL CONTROLS THAT DATABASE SOFTWARE WHO BELONGS TO RDBMS


PROGRAM
CREATE DATABASE
CREATE DATABSE stp;

DELETE DATABASE
DROP DATABASE stp;

CREATE TABLE IN DATABASE


CREATE TABLE admission(
roll INT(11),
name VARCHAR(50),
subject VARCHAR(50)
);

INSERT DATA IN TABLE


INSERT INTO admission(roll,name,subject)
VALUES(1,”amit”,”Hindi”);

You might also like