Relevant information

About

A Simple but Dynamic Working Login page using React,Node JS,Mysql

Database name : user_data

Table name : users

Table columns

• id
• username
• password
• referral

Queries used

Creating the database

• CREATE DATABASE user_data;

Creating the table

• CREATE TABLE user_data (
  id INT PRIMARY KEY,
  username VARCHAR(50) UNIQUE,
  password VARCHAR(50),
  referral INT DEFAULT 0
  );

Selecting the username and password for login / registration

• SELECT username, password FROM users WHERE username="user input"

Inserting data for registering a new user

• INSERT INTO users SET username='user input',password='user input', referral='user input'

Adding referral points

• UPDATE users SET referral=referral+1 WHERE username='user input'