+ 1

How to create a table ?

need the answer in well description..am confused.

1st Sep 2017, 8:23 AM
divya
divya - avatar
5 Answers
+ 8
1)create database bank ; // first u need to create a database , in which there will a table 2) use bank; 3)create table divyatable (name varchar (10) not null , rollno int primary key , class int ); // here database is bank , table is divyatable , and fields in table are name,rollno 4) desc divyatable ; //to see structure of table 5)insert into divyatable values ("divya" ,14); 👈👈👈 // a record is added //add some more records similarily 6) select * from divyatable; //to see all records
1st Sep 2017, 8:36 AM
Changed
Changed - avatar
+ 7
see pt.5) at divya
1st Sep 2017, 8:43 AM
Changed
Changed - avatar
+ 1
MySQL
1st Sep 2017, 8:30 AM
divya
divya - avatar
+ 1
how to add values ??
1st Sep 2017, 8:38 AM
divya
divya - avatar
+ 1
thnks...😊
1st Sep 2017, 8:44 AM
divya
divya - avatar