mysql> create database akash_classes;
Query OK, 1 row affected (0.01 sec)
mysql> use database akash classes
mysql> use database akash classes;
mysql> use database akash_classes;
mysql> use database akash_classes;
mysql> use akash_classes;
Database changed
mysql> create table info (roll_no(int),name(varchar),marks_obtained(int),mobile(int));
mysql> create table info (roll_no int, name varchar(40), marks_obtained int, mobile int);
Query OK, 0 rows affected (0.06 sec)
mysql> describe info
-> ;
+----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| roll_no | int | YES | | NULL | |
| name | varchar(40) | YES | | NULL | |
| marks_obtained | int | YES | | NULL | |
| mobile | int | YES | | NULL | |
+----------------+-------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
mysql> insert into info values (111,'shubham',99,9975577605)
-> ;
mysql> insert into info values (111,'shubham',100,997557760);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (112,'aditya',50,385648396););
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (112,'aditya',50,385648396);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (113,'anurag',90,987654321);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (114,'rajan',60,123456789);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (115,'ravi',80,543216789);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (116,'priyesh',66,883216700);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (116,'prience',39,663216440);
Query OK, 1 row affected (0.01 sec)
mysql> insert into info values (117,'mayank',89,589641232);
Query OK, 1 row affected (0.01 sec)
mysql> select * from info
-> ;
+---------+---------+----------------+-----------+
| roll_no | name | marks_obtained | mobile |
+---------+---------+----------------+-----------+
| 111 | shubham | 100 | 997557760 |
| 112 | aditya | 50 | 385648396 |
| 112 | aditya | 50 | 385648396 |
| 113 | anurag | 90 | 987654321 |
| 114 | rajan | 60 | 123456789 |
| 115 | ravi | 80 | 543216789 |
| 116 | priyesh | 66 | 883216700 |
| 116 | prience | 39 | 663216440 |
| 117 | mayank | 89 | 589641232 |
+---------+---------+----------------+-----------+
9 rows in set (0.05 sec)
mysql> delete table info;
mysql> drop table info;
Query OK, 0 rows affected (0.04 sec)
mysql> select * from info;
ERROR 1146 (42S02): Table 'akash_classes.info' doesn't exist
mysql> drop database [Link];
mysql> drop database akash_classes;
Query OK, 0 rows affected (0.02 sec)