Question

Write down the procedure for creating tables in database.

Answer 1

Answer:

syntax for creating a data base:

CREATE TABLE<table name>

(dataname1 data type,

dataname2 data type,

dataname3 data type,

" "

" "

" "

dataname n datatype);

2.syntax:example

CREATE TABLE student ( slno integer , studentname varchar(20) , sem integer , branch varchar(10) , result varchar(10) , percentage decimal(4,2));

3.syntax:

DESC student;

4.syntax:

insert into student values (1, 'soma' , 2 , 'cs' , 'pass' , 60.66);

5.step or syntax

insert into student values(2, 'ayesha' , 3 , 'MTT' , 'firstclass' , 72.99);

6.syntax:

select * from student;