Ìwé Directory
Ìṣètò MySQL oní-ọ̀pọ̀-agbègbè? ÌṢẸ́ MySQL NÍPASẸ̀ Ìsọ̀kalẹ̀/àgbékalẹ̀ ìbéèrè ìbéèrè/iṣẹ́
MySQL lẹsẹsẹ
A mọ lati lo SQL SELECT gbólóhùn lati ka data lati MySQL tabili.
Tí a bá nílò láti to àwọn ìwífún tí a kà, a lè lo àkójọpọ̀ ORDER BY ti MySQL láti sọ irú pápá àti ọ̀nà ìtòjọ tí a fẹ́ lò, lẹ́yìn náà a ó dá àwọn èsì ìwárí padà.
girama
Atẹle yii jẹ alaye yiyan SQL ti o nlo ORDER BY gbolohun ọrọ lati to awọn data ibeere ṣaaju ki o to da data naa pada:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- O le lo aaye eyikeyi bi ipo tootọ lati da awọn abajade ibeere to lẹsẹsẹ pada.
- O le ṣeto awọn aaye pupọ lati to lẹsẹsẹ.
- O le lo awọn koko-ọrọ ASC tabi DESC lati ṣeto awọn abajade ibeere lati ṣe lẹsẹsẹ ni ọna ti o lọ soke tabi ti sọkalẹ.Nipa aiyipada, o wa ni aṣẹ ti o ga.
- O le ṣafikun NIBI… JORA awọn gbolohun ọrọ lati ṣeto awọn ipo.
Lilo BEERE NIPA gbolohun ọrọ ninu aṣẹ aṣẹ
Awọn atẹle yoo lo ORDER BY gbolohun ọrọ ninu ọrọ SQL SELECT lati ka data naa ninu tabili data MySQL chenweiliang_tbl:
Apeere
Gbiyanju awọn apẹẹrẹ ti o wa ni isalẹ ati pe awọn abajade yoo jẹ lẹsẹsẹ ni ọna ti o ga ati ti sọkalẹ.
SQL lẹsẹsẹ
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)
Ka gbogbo data ti o wa ninu tabili chenweiliang_tbl ki o to lẹsẹsẹ ni ọna ti o ga soke nipasẹ aaye submission_date.
Lilo BEERE NIPA gbolohun ọrọ ninu iwe afọwọkọ PHP kan
O le lo iṣẹ PHP mysqli_query() ati aṣẹ SQL SELECT kanna pẹlu ORDER BY gbolohun ọrọ lati gba data naa.
Iṣẹ yii ni a lo lati ṣiṣẹ awọn aṣẹ SQL ati lẹhinna gbejade gbogbo data ti o beere nipasẹ iṣẹ PHP mysqli_fetch_array ().
Apeere
Gbiyanju apẹẹrẹ atẹle, data ti o beere ti pada ni ọna ti o sọkalẹ ti aaye submission_date.
Ibere MySQL NIPA idanwo:
<?
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);
?>Ní ìrètí, àpilẹ̀kọ náà "MySQL Multi-Field Condition Sorting? MySQL ORDER BY Descending/Ascending Order Query Statement/Function" tí a pín lórí ìwé ìròyìn Chen Weiliang ( https://www.chenweiliang.com/ ) yóò wúlò fún ọ.
Má ṣe ṣiyemeji láti pín ìjápọ̀ àpilẹ̀kọ yìí: https://www.chenweiliang.com/cwl-476.html