SQL Queries for Create a student table and insert data by G Krishna Chauhan

Source Code

 

CREATE TABLE students

(

studentID int,

studentname varchar(255),

parentname varchar(255),

address varchar(255),

phonenumber int

);



















#With column names and values




INSERT INTO students(studentID, studentname, parentname, address,phonenumber)

VALUES ('6', 'Rohit','Ram', 'Krishna 31 Jeevan Geet', '9358022035');

#With values only




INSERT INTO students

VALUES ('6', 'Rohit','Ram', 'Krishna 31 Jeevan Geet', '9358022035');