Create Table in SQL

we will create a table called book with the following fields

1. bookname

2. price

3. subject

the query is

create table book(bookname varchar(10),price int,subject varchar(10))

insert statement

insert into book values('basic c','250','c')--in actual order

insert into book (price,subject,bookname) values('300','c++','basic cpp')---change the order

insert into book values('bookname','price','subject')

 

                                                                    

 

Contact us for software training, education or development