'why mysql can have two duplicate columns?

As it shows , this table has two duplicate columns , but I tried to create a table and add a duplicate column,failed,how to add a duplicate column like this ?

mysql> select * from tableA limit 10;
+------+-------+------------------+--------+-----------+
| id   | id_no | contno           | ishigh | contno   |
+------+-------+------------------+--------+-----------+
| NULL | NULL  | 8026000161690448 | NULL   | NULL      |
| NULL | NULL  | 8026000168763808 | NULL   | NULL      |
| NULL | NULL  | 8026000163553868 | NULL   | NULL      |
| NULL | NULL  | 8026000168945478 | NULL   | NULL      |
| NULL | NULL  | 8026000160011788 | NULL   | NULL      |
| NULL | NULL  | 8026000159745758 | NULL   | NULL      |
| NULL | NULL  | 1005043000850458 | NULL   | NULL      |
| NULL | NULL  | 8026000160549108 | NULL   | NULL      |
| NULL | NULL  | 8026000163560088 | NULL   | NULL      |
| NULL | NULL  | 8026000158243148 | NULL   | NULL      |
+------+-------+------------------+--------+-----------+
10 rows in set (0.00 sec)

the create table DDL is:

CREATE TABLE `tableA` (
  `id` int(11) DEFAULT NULL,
  `id_no` varchar(100) DEFAULT NULL,
  `contno` varchar(100) DEFAULT NULL,
  `ishigh` varchar(100) DEFAULT NULL,
  `contno` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source