· 4 years ago · Jun 14, 2021, 12:08 PM
1mysql>USE School;
2mysql>CREATE TABLE Student
3 ->(Roll no integer NOT NULL PRIMARY KEY,
4 ->Name Varchar(20) NOT NULL,
5 ->Marks integer (11));
6mysql>INSERT INTO Student VALUES (1,"Raj Kumar",93);
7mysql>INSERT INTO Student VALUES
8(2,"Deep Singh",98);
9mysql>INSERT INTO Student VALUES
10(3,"Ankit Sharma",76);
11mysql>SELECT*FROM Student;
12
13RAW Paste Data
14mysql>USE School;
15mysql>CREATE TABLE Student
16 ->(Roll no integer NOT NULL PRIMARY KEY,
17 ->Name Varchar(20) NOT NULL,
18 ->Marks integer (11));
19mysql>INSERT INTO Student VALUES (1,"Raj Kumar",93);
20mysql>INSERT INTO Student VALUES
21(2,"Deep Singh",98);
22mysql>INSERT INTO Student VALUES
23(3,"Ankit Sharma",76);
24mysql>SELECT*FROM Student;
25create new paste / syntax languages / archive / faq / tools / night mode / api / scraping api / news / pro
26privacy statement / cookies policy / terms of serviceupdated / security disclosure / dmca / report abuse / contact
27
28