Chinyorwa Directory
MySQLMulti-field nemamiriro ekuronga?MySQL odha nekudzika nekukwira query statement/function
MySQL mhando
Isu tinoziva kushandisa SQL SELECT statement kuverenga data kubva kuMySQL tafura.
Kana isu tichida kugadzirisa iyo yekuverenga data, tinogona kushandisa MySQL's Odha BY clause yekuseta kuti ndeipi ndima yaunoda kuronga nayo, wozodzosera zvawanikwa.
girama
Izvi zvinotevera chirevo cheSQL SELECT chinoshandisa ORDER BY clause kugadzirisa dhata yemubvunzo usati wadzorera data:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- Unogona kushandisa chero nzvimbo seyakarongeka kudzosa mhinduro dzakarongwa.
- Iwe unogona kuseta akawanda minda kuti uronge.
- Unogona kushandisa ASC kana DESC keywords kuseta mhinduro dzemubvunzo kuti dzigadziriswe mukukwira kana kudzika.Nekusagadzikana, iri mukukwira kurongeka.
- Unogona kuwedzera PANE...KUFANANA nezvikamu zvekuisa mamiriro.
Uchishandisa iyo ORDER BY clause mune yekuraira kukurumidza
Zvinotevera zvichashandisa ORDER BY clause muSQL SELECT statement kuverenga data iri muMySQL data table chenweiliang_tbl:
muenzaniso
Edza mienzaniso iri pazasi uye mibairo icharongwa mukukwira nekudzika.
SQL mhando
mysql> use chenweiliang; Database changed mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date ASC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec) mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date DESC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec)
Verenga data rese riri patafura ye chenweiliang_tbl worongedza muhurongwa hwekukwira nechikamu che submission_date.
Kushandisa ORDER BY clause mune PHP script
Unogona kushandisa PHP basa mysqli_query() uye yakafanana SQL SELECT command ine ORDER BY clause kuti uwane iyo data.
Iri basa rinoshandiswa kuita SQL mirairo uye wozoburitsa ese akabvunzwa data kuburikidza neiyo PHP basa mysqli_fetch_array().
muenzaniso
Edza unotevera muenzaniso, iyo data yakabvunzwa inodzoserwa mukudzika kurongeka kweiyo submission_date field.
MySQL ORDER BY bvunzo:
<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT chenweiliang_id, chenweiliang_title,
chenweiliang_author, submission_date
FROM chenweiliang_tbl
ORDER BY submission_date ASC';
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 MySQL ORDER BY 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{
echo "<tr><td> {$row['chenweiliang_id']}</td> ".
"<td>{$row['chenweiliang_title']} </td> ".
"<td>{$row['chenweiliang_author']} </td> ".
"<td>{$row['submission_date']} </td> ".
"</tr>";
}
echo '</table>';
mysqli_close($conn);
?>Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) yakagovaniswa "MySQL multi-field conditional sorting? MySQL order nekudzika nekukwira query statement/function", iyo inobatsira kwauri.
Welcome to share link yechinyorwa chino:https://www.chenweiliang.com/cwl-476.html
Tikugashirei kuTeregiramu chiteshi cheChen Weiliang's blog kuti uwane zvichangobva kuitika!
📚 Iri gwara rine kukosha kukuru, 🌟Uyu mukana usingawanzo, usapotsa! ⏰⌛💨
Govera uye like kana uchida!
Kugovera kwako uye kuda ndiko kukurudzira kwedu kunoramba kuripo!