MYSQL basic

Query for creating table
query:

CREATE TABLE student_Detail(
   user_id INT AUTO_INCREMENT PRIMARY KEY,
   f_name VARCHAR(20),
   l_name VARCHAR(20)
); 

create-table

Query for inserting values into table
query:

insert into student_detail values('bhavesh','lakhani');
       insert into student_detail values('vivek','patel');
       insert into student_detail values('abhilash1','shah');

insert2

Query to See table
query:

 select *From student_detail;

table-data

Note: I have included mysql basic detail because i am going to use into
my java JDBC Program later we will see all concept about SQL.

Leave a Reply

Your email address will not be published. Required fields are marked *