Scribd
Upload
16 views1 page

Queries SQL

Uploaded by

امجاد ماجد
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
16 views1 page

Queries SQL

Uploaded by

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

create table course(

coursecv_name varchar(50),
coursecv_number varchar(50),
cradit_hours int(2),
department varchar(10)

);
show tables;
select * from course;
insert into course values ("introduction to computer science","cs1310",4,"cs");
insert into course values("data structures","cs3320",4,"cs");
insert into course values("discrete mathematics","math 2410",3,"math");
insert into course values("database","cs3380",3,"cs");
select * from course;

show tables;
create table section (
section_id int(10),
course_number varchar(50),
semester varchar(10),
year int(10),
instructor varchar(50)
);
show tables;
create table grade_report(
student_number int (50),
section_identifier int(50),
grade varchar(30);
):

show tables;
select *from course ;
insert into course values ("Introduction to computer sc1ence" ,"cs1310",4,"c5");
select * from course ;
insert into course ("department,credit_hrs", "course_name","course_number")
va1ues("cs",4,"cs3320", "Data structures" ,"cs3320");
select * from course ;

You might also like