Unique Order Number

Learn to avoid the redundancy of rows.

Delete the wrong order

Let’s first delete the wrong order:

1 mysql> delete from orders where id = 2;
2 Query OK, 1 row affected (0.01 sec)
3
4 mysql> select * from orders;
5 +----+--------------+---------------------+-------------+
6 | id | order_number | ordered_at          | customer_id |
7 +----+--------------+---------------------+-------------+
8 |  1 | ABC001       | 2016-09-09 08:34:55 |   1         |
9 +----+--------------+-----------
...