Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
MySQL
create table STUDENT_TABLE(ROLLNO Integer,NAME Varchar(10),GENDER char(1),MARKS Float,DOB Date,Mob_no Integer,CITY Varchar(15)); insert into STUDENT_TABLE values(101,'A','M',95,'1998-02-12',580,'JAMNAGAR'); insert into STUDENT_TABLE values(102,'B','F',96,'1998-02-13',581,'DWARKA'); insert into STUDENT_TABLE values(103,'C','M',97,'1998-02-14',582,'RAJKOT'); insert into STUDENT_TABLE values(104,'D','F',98,'1998-02-15',583,'AHMEDABAD'); insert into STUDENT_TABLE values(105,'E','M',100,'1998-02-17',584,'GANGHINAGAR'); insert into STUDENT_TABLE values(106,'F','F',100,'1998-02-18',585,'VADODRA'); insert into STUDENT_TABLE values(107,'G','M',98,'1998-02-19',586,'DELHI'); insert into STUDENT_TABLE values(108,'H','F',97,'1998-02-20',587,'MUMBAI'); insert into STUDENT_TABLE values(109,'I','M',96,'1998-02-21',588,'CHENNAI'); insert into STUDENT_TABLE values(110,'J','F',95,'1998-02-22',589,'BHOPAL'); Select * from STUDENT_TABLE;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Práctica MySQL 1
pt.stackoverflow.com/questions/170610
ruthresh
find tax rates for current time period
Srinivas
Simon_Test1
kuy09:admin@pkms99.info
Question no:2
Práctica MySQL 2
Teste listagem
Please log in to post a comment.