Question

ID Title Author Price 1 Richie Karen Year 1955 1958 1959 C JAVA Script Java C++ prolog 2 4 10 20 10 5 Schwartz Ross Maria 1959 1972 20 10 6 7 Perl Wall 1987 20 The above relation has information about different books. The table information is already saved as txt format in Moodle under the name Quiz2Data.txt. Using MySql on your computer do: Create a database Create a table with name book, then load Quiz2Data.txt (check file DataLoad in Moodle for the steps to load the file) O

create table please for my SQL

data.txt

1,C,Richie,1955
2,JAVA Script,Karen,1958
4,Java,Schwartz,1959
5,C++,Ross,1959
6,prolog,Maria,1972
7,Perl,Wall,1987

Answer 1

create table book(ID varchar(20) primary key, Title varchar(20), Author varchar(40), year INT, price decimal(10,2) );

Now use insert command to insert data.

syntax for insertion:-

insert into book values(value1,value2,value3,value4,value5);

note:- if datatype in table is varchar, during insertion use quote for values. i.e. since ID in book is varchar. so we will write 'value1' ( look it is inside quote). Similarly for other varchar values.

DON'T FORGET TO HIT LIKE.

THANKS BY HEART.