natural-sort.txt

MariaDB [testing]> CREATE TABLE `new_table` (`testing` varchar(255) NOT NULL, `inserted` datetime NOT NULL,PRIMARY KEY (`testing`)) ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)

MariaDB [testing]> INSERT INTO new_table (`testing`, `inserted`) VALUES('e', NOW());
Query OK, 1 row affected (0.00 sec)

MariaDB [testing]> INSERT INTO new_table (`testing`, `inserted`) VALUES('a', NOW());
Query OK, 1 row affected (0.01 sec)

MariaDB [testing]> INSERT INTO new_table (`testing`, `inserted`) VALUES('d', NOW());
Query OK, 1 row affected (0.00 sec)

MariaDB [testing]> INSERT INTO new_table (`testing`, `inserted`) VALUES('b', NOW());
Query OK, 1 row affected (0.00 sec)

MariaDB [testing]> INSERT INTO new_table (`testing`, `inserted`) VALUES('c', NOW());
Query OK, 1 row affected (0.01 sec)

MariaDB [testing]> SELECT * FROM new_table;
+---------+---------------------+
| testing | inserted            |
+---------+---------------------+
| a       | 2016-04-07 13:58:26 |
| b       | 2016-04-07 13:58:32 |
| c       | 2016-04-07 13:58:33 |
| d       | 2016-04-07 13:58:30 |
| e       | 2016-04-07 13:58:23 |
+---------+---------------------+
5 rows in set (0.00 sec)