如何以正确或恰当的方式格式化MySQL
如何以正确或恰当的方式格式化MySQL
提问于 2020-11-17 17:50:19
假设我有这样的代码
SELECT * from mytable WHERE rowNumber = 4;这就是结果(没有实际的结果，只是说明)
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| rowNumber | printStatus | reprintDetailId | reprintDetail | expeditionName | printedDate | awbCode | orderNumbers | buyerName | buyerAddress | buyerMobile | oldStockKeepingUnit | stockKeepingUnit | productName | kategori | koliNumbers | orderPackNumber | orderPackName | orderItemQuantity | unitName | productWeight | weightUnitName | deliverySchedule | sameday_code |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| 4 | REPRINT | 4 | pengembalian barang(refund) | JAKSEL | 2020-11-13 17:51:36 | 94148181 | 94148181 | Ellin Natalia | Jalan Pati Unus No. 33, Lt. 2, KEBAYORAN BARU, KOTA JAKARTA SELATAN, DKI JAKARTA, 12120 | 089692646971 | 960-931 | 0-09-1-00960 | Ayam Fillet 500g | REG | 1 | 3.00 | 0.5 Kg | 1.50 | kg | 1.50 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| | REPRINT | 4 | pengembalian barang(refund) | JAKSEL | 2020-11-13 17:51:36 | 94148181 | 94148181 | Ellin Natalia | Jalan Pati Unus No. 33, Lt. 2, KEBAYORAN BARU, KOTA JAKARTA SELATAN, DKI JAKARTA, 12120 | 089692646971 | 961-932 | 0-09-1-00961 | Ayam Kampung 650g | REG | 1 | 1.00 | 0.65 Kg | 0.65 | kg | 0.65 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| | REPRINT | 4 | pengembalian barang(refund) | JAKSEL | 2020-11-13 17:51:36 | 94148181 | 94148181 | Ellin Natalia | Jalan Pati Unus No. 33, Lt. 2, KEBAYORAN BARU, KOTA JAKARTA SELATAN, DKI JAKARTA, 12120 | 089692646971 | 961-932 | 0-09-1-00961 | Ayam Kampung 650g | REG | 2 | 3.00 | 0.65 Kg | 1.95 | kg | 1.95 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+这就是rowNumber = 4的数据，我应该更改代码的哪一部分，以便将出现双倍值的值折旧为只有1值，因为存在相同的值和相同的均值
预期结果
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| rowNumber | printStatus | reprintDetailId | reprintDetail | expeditionName | printedDate | awbCode | orderNumbers | buyerName | buyerAddress | buyerMobile | oldStockKeepingUnit | stockKeepingUnit | productName | kategori | koliNumbers | orderPackNumber | orderPackName | orderItemQuantity | unitName | productWeight | weightUnitName | deliverySchedule | sameday_code |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| 4 | REPRINT | 4 | pengembalian barang(refund) | JAKSEL | 2020-11-13 17:51:36 | 94148181 | 94148181 | Ellin Natalia | Jalan Pati Unus No. 33, Lt. 2, KEBAYORAN BARU, KOTA JAKARTA SELATAN, DKI JAKARTA, 12120 | 089692646971 | 960-931 | 0-09-1-00960 | Ayam Fillet 500g | REG | 1 | 3.00 | 0.5 Kg | 1.50 | kg | 1.50 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| | | | | | | | | | | | 961-932 | 0-09-1-00961 | Ayam Kampung 650g | REG | 1 | 1.00 | 0.65 Kg | 0.65 | kg | 0.65 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+
| | | | | | | | | | | | 961-932 | 0-09-1-00961 | Ayam Kampung 650g | REG | 2 | 3.00 | 0.65 Kg | 1.95 | kg | 1.95 | Kg | - | PHS |
+-----------+-------------+-----------------+-----------------------------+----------------+---------------------+----------+--------------+---------------+-----------------------------------------------------------------------------------------+--------------+---------------------+------------------+-------------------+----------+-------------+-----------------+---------------+-------------------+----------+---------------+----------------+------------------+--------------+回答 1
Stack Overflow用户
发布于 2020-11-17 18:25:15
如果我没理解错你的问题，你想去掉select中的重复项。
为了避免重复，你应该使用DISTINCT。
将选择更改为：
SELECT DISTINCT *
FROM mytable
WHERE rowNumber = 4;请注意，如果所有选定的值都等于已找到行的，则DISTINCT仅从select中排除一行。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/64872852
复制相关文章
相似问题
腾讯云开发者
