DreamsCoder.com

We Code your Dreams


home > Creating Table in MySql




Creating Table in MySql





mysql> create table BRC_2(B_no int primary key,B_name varchar(25) NOT NULL,
B_city varchar(25))engine=innodb;
Query OK, 0 rows affected (0.01 sec)

mysql> desc BRC_2;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| B_no   | int(11)     |      | PRI | 0       |       |
| B_name | varchar(25) |      |     |         |       |
| B_city | varchar(25) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

Label - database





by - Chinmay Mahajan





Are you looking for something else?


Suggested Programs




How to store and display regional languages code in PHP MySql