Question

create a database with roll number
​

Answer 1

FØLLØW ME

CREATE TABLE STUDENTS (

Roll_no INT NOT NULL,

NAME VARCHAR (20) NOT NULL,

AGE INT NOT NULL,

City CHAR (25),

PRIMARY KEY (ID)

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (1, Abi, 22, Mumbai);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (2, Bala, 20, Chennai);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (3, DISHA, 21, Mumbai);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (4, Ram, 21, Banglore);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (5, Shailaja, 23, Kolatta);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (6, Rohan, 23, Banglore);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (7 , Ramya, 23, Chennai);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (8, Rani, 23, Kerala);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (9, Ragu, 23, Andhra);

INSERT INTO STUDENTS (ROLL_NO, NAME, AGE, CITY)

VALUES (10, Sreya, 23, Kerala);

Select * from Student;