Creating Database - VirajKanse/Student_Authentication GitHub Wiki

Create a database called registration. In the registration database, add a table called users. The users table will take the following four fields.

  • id int(100)
  • stud varchar(255) --> (stud == student name)
  • rl varchar(255) -->(rl == roll number)
  • enr varchar(255) -->(enr == enrollment number)

There are two ways to create database and table as follows :point_down::point_down::point_down::point_down::point_down: :-

  1. You can also use PHPMyAdmin to create database and table -
  1. Otherwise You can create table through MySQL query -
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

And boooom !! :collision: If everything is perfect, you have succesfully created a database and table where further we are going to store our data.