mysql> desc branch;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| bid | int(4) | NO | PRI | | |
| cid | int(3) | NO | | | |
| bdesc | text | NO | | | |
| bloc | varchar(25) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
+-------+--------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------+------+-----+---------+----------------+
| cid | int(3) | NO | PRI | NULL | auto_increment |
| cname | text | NO | | | |
+-------+--------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
+-----+-------+------+---------------+
| cid | cname | bid | bdesc |
+-----+-------+------+---------------+
| 101 | WANG | 1011 | cororate hq |
| 101 | WANG | 1012 | cDDororate hq |
| 101 | WANG | 1013 | DDrate hq |
| 102 | JV | NULL | NULL |
| 103 | dJV | 1015 | DDratDDhq |
| 103 | dJV | 1016 | DDratDDhDq |
| 104 | JAMES | 1014 | DDratDDhq |
| 105 | TOMES | NULL | NULL |
+-----+-------+------+---------------+
8 rows in set (0.00 sec)
Query OK, 2 rows affected (0.00 sec)
+-----+-------+------+---------------+
| cid | cname | bid | bdesc |
+-----+-------+------+---------------+
| 101 | WANG | 1011 | cororate hq |
| 101 | WANG | 1012 | cDDororate hq |
| 101 | WANG | 1013 | DDrate hq |
| 103 | dJV | 1015 | DDratDDhq |
| 103 | dJV | 1016 | DDratDDhDq |
| 104 | JAMES | 1014 | DDratDDhq |
+-----+-------+------+---------------+
6 rows in set (0.00 sec)