Creating Database

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 👇👇👇👇👇 :-

1. You can also use PHPMyAdmin to create database and table -

2. 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 !! 💥 If everything is perfect, you have succesfully created a database and table where further we are going to store our data.