Untitled

unknown

plain_text

2 years ago

471 B

Indexable

Never

mysql -u root -p

use grading_sys;

drop table students;

CREATE TABLE `students` (
  `No` int(11) NOT NULL,
  `Student No.` int(11) NOT NULL,
  `First Name` varchar(50) NOT NULL,
  `Last Name` varchar(50) NOT NULL,
  `Gender` varchar(50) NOT NULL,
  `Section` varchar(50) NOT NULL,
  `Prelim` int(11) NOT NULL,
  `Midterm` int(11) NOT NULL,
  `Final` int(11) NOT NULL,
  `Average` int(11) NOT NULL,
  `Equivalent` varchar(50) NOT NULL,
  `Remark` varchar(50) NOT NULL
);