Sengoli sa Lingoloa
MySQLHo hlopha ka mabaka a mangata?MySQL laela ka ho theoha setatemente/mosebetsi o nyolohang wa potso
Mofuta oa MySQL
Re tseba ho sebelisa polelo ea SQL SELECT ho bala lintlha tse tsoang tafoleng ea MySQL.
Haeba re hloka ho hlophisa data e baloang, re ka sebelisa MySQL's LITABA poleloana ho seta lebala leo u batlang ho le hlophisa ka tsela efe, ebe u khutlisetsa liphetho tsa lipatlisiso.
sebōpeho-puo
Se latelang ke polelo ea SQL SELECT e sebelisang ORDER BY clause ho hlophisa lintlha tsa potso pele e khutlisetsa data:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- U ka sebelisa karolo efe kapa efe e le mokhoa oa ho hlophisa ho khutlisa liphetho tse hlophisitsoeng.
- O ka beha likarolo tse ngata ho hlopha.
- U ka sebelisa mantsoe a sehlooho a ASC kapa DESC ho hlophisa liphetho tsa lipotso hore li hlophisoe ka tatellano e nyolohang kapa e theohang.Ka tloaelo, e maemong a holimo.
- O ka eketsa MAKAE... LIKE clauses ho beha maemo.
Ho sebelisa poleloana ea ORDER BY molaong oa taelo
Ba latelang ba tla sebelisa ORDER BY clause ho SQL SELECT statement ho bala lintlha tse ho MySQL data table chenweiliang_tbl:
Mohlala
Leka mehlala e ka tlase 'me liphetho li tla hlophisoa ka tatellano ea ho nyoloha le ho theoha.
Mofuta oa SQL
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)
Bala boitsebiso bohle ho tafole ea chenweiliang_tbl 'me u hlopha ka tatellano ea ho nyoloha ka karolo ea submission_date.
Ho sebelisa ORDER BY clause ho PHP script
U ka sebelisa mosebetsi oa PHP mysqli_query() le taelo e tšoanang ea SQL SELECT ka ORDER BY clause ho fumana lintlha.
Mosebetsi ona o sebelisetsoa ho phethahatsa litaelo tsa SQL ebe o hlahisa lintlha tsohle tse botsitsoeng ka PHP function mysqli_fetch_array().
Mohlala
Leka mohlala o latelang, lintlha tse botsitsoeng li khutlisetsoa ka tatellano e theohang sebakeng sa submission_date.
MySQL ORDER BY test:
<?
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/ ) o ile a arolelana "MySQL multi-field conditional sorting? Taelo ea MySQL ka ho theoha le ho nyoloha polelo ea potso / mosebetsi", e leng thuso ho uena.
Rea u amohela ho arolelana sehokelo sa sengoloa sena:https://www.chenweiliang.com/cwl-476.html
Rea u amohela ho mocha oa Telegraph oa blog ea Chen Weiliang ho fumana lintlha tsa morao-rao!
📚 Tataiso ena e na le boleng bo boholo, 🌟Ona ke monyetla o sa tloaelehang, se ke oa o fetoa! ⏰⌛💨
Share le rata haeba u rata!
Ho arolelana le lintho tseo u li ratang ke khothatso ea rona e tsoelang pele!