会python真的可以为所欲为0(回)
353天前
这里还有人吗1(回)
538天前这里还有人吗0(回)
538天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
763天前到处都是羊，不想上班0(回)
843天前
鸽子
0(回)
847天前mysql> |
mysql> SELECT prod_name |
-> FROM products |
-> ORDER BY prod_name; |
+----------------+ |
| prod_name | |
+----------------+ |
| .5 ton anvil | |
| 1 ton anvil | |
| 2 ton anvil | |
| Bird seed | |
| Carrots | |
| Detonator | |
| Fuses | |
| JetPack 1000 | |
| JetPack 2000 | |
| Oil can | |
| Safe | |
| Sling | |
| TNT (1 stick) | |
| TNT (5 sticks) | |
+----------------+ |
14 rows in set (0.09 sec) |
mysql> |
mysql> |
mysql> SELECT prod_id,prod_price,prod_name |
-> FROM products |
-> ORDER BY prod_price,prod_name; |
+---------+------------+----------------+ |
| prod_id | prod_price | prod_name | |
+---------+------------+----------------+ |
| FC | 2.50 | Carrots | |
| TNT1 | 2.50 | TNT (1 stick) | |
| FU1 | 3.42 | Fuses | |
| SLING | 4.49 | Sling | |
| ANV01 | 5.99 | .5 ton anvil | |
| OL1 | 8.99 | Oil can | |
| ANV02 | 9.99 | 1 ton anvil | |
| FB | 10.00 | Bird seed | |
| TNT2 | 10.00 | TNT (5 sticks) | |
| DTNTR | 13.00 | Detonator | |
| ANV03 | 14.99 | 2 ton anvil | |
| JP1000 | 35.00 | JetPack 1000 | |
| SAFE | 50.00 | Safe | |
| JP2000 | 55.00 | JetPack 2000 | |
+---------+------------+----------------+ |
14 rows in set (0.01 sec) |
mysql> |
mysql> SELECT prod_id,prod_price,prod_name |
-> FROM products |
-> ORDER BY prod_price DESC; # 降序 |
+---------+------------+----------------+ |
| prod_id | prod_price | prod_name | |
+---------+------------+----------------+ |
| JP2000 | 55.00 | JetPack 2000 | |
| SAFE | 50.00 | Safe | |
| JP1000 | 35.00 | JetPack 1000 | |
| ANV03 | 14.99 | 2 ton anvil | |
| DTNTR | 13.00 | Detonator | |
| TNT2 | 10.00 | TNT (5 sticks) | |
| FB | 10.00 | Bird seed | |
| ANV02 | 9.99 | 1 ton anvil | |
| OL1 | 8.99 | Oil can | |
| ANV01 | 5.99 | .5 ton anvil | |
| SLING | 4.49 | Sling | |
| FU1 | 3.42 | Fuses | |
| FC | 2.50 | Carrots | |
| TNT1 | 2.50 | TNT (1 stick) | |
+---------+------------+----------------+ |
14 rows in set (0.00 sec) |
mysql> |
mysql> |
mysql> SELECT prod_id,prod_price,prod_name |
-> FROM products |
-> ORDER BY prod_price DESC,prod_name; |
+---------+------------+----------------+ |
| prod_id | prod_price | prod_name | |
+---------+------------+----------------+ |
| JP2000 | 55.00 | JetPack 2000 | |
| SAFE | 50.00 | Safe | |
| JP1000 | 35.00 | JetPack 1000 | |
| ANV03 | 14.99 | 2 ton anvil | |
| DTNTR | 13.00 | Detonator | |
| FB | 10.00 | Bird seed | |
| TNT2 | 10.00 | TNT (5 sticks) | |
| ANV02 | 9.99 | 1 ton anvil | |
| OL1 | 8.99 | Oil can | |
| ANV01 | 5.99 | .5 ton anvil | |
| SLING | 4.49 | Sling | |
| FU1 | 3.42 | Fuses | |
| FC | 2.50 | Carrots | |
| TNT1 | 2.50 | TNT (1 stick) | |
+---------+------------+----------------+ |
14 rows in set (0.00 sec) |
mysql> |
mysql> |
mysql> SELECT prod_price |
-> FROM products |
-> ORDER BY prod_price DESC |
-> LIMIT 1; |
+------------+ |
| prod_price | |
+------------+ |
| 55.00 | |
+------------+ |
1 row in set (0.01 sec) |
mysql> |
