IN MYSQL SELECT, WILDCARD MUST GO FIRST!

mysql> SELECT *, from_unixtime(created) FROM payment_transaction_details;
+----+---------+-----------+------------+------------------------+
| id | ppl_id  | reason_id | created    | from_unixtime(created) |
+----+---------+-----------+------------+------------------------+
|  1 | 9383651 |        31 | 1360781624 | 2013-02-13 10:53:44    |
| 11 | 9383661 |        71 | 1360781645 | 2013-02-13 10:54:05    |
| 21 | 9383671 |        11 | 1360781697 | 2013-02-13 10:54:57    |
| 31 | 9383681 |         1 | 1360781765 | 2013-02-13 10:56:05    |
+----+---------+-----------+------------+------------------------+
4 rows in set (0.00 sec)

mysql> SELECT from_unixtime(created), * FROM payment_transaction_details;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from payment_transaction_details' at line 1

WHY SO?


转载本文请联系原作者获取授权，同时请注明本文来自吴全丰科学网博客。
链接地址：https://blog.sciencenet.cn/blog-322380-661668.html

上一篇：视觉科学和计算机视觉的网站和通信录
下一篇：牛顿关于颜色和色觉的​疑问