Artikel Direktori
MySQLNgurutake kondisional multi-bidang?MySQL urutan kanthi mudhun lan munggah pernyataan pitakon / fungsi
Urut MySQL
Kita ngerti nggunakake statement SQL SELECT kanggo maca data saka tabel MySQL.
Yen kita kudu ngurutake data sing diwaca, kita bisa nggunakake MySQL Pesenan BY klausa kanggo nyetel kolom endi sing arep diurutake, banjur bali asil panelusuran.
toto wicoro
Ing ngisor iki ana statement SQL SELECT sing nggunakake klausa ORDER BY kanggo ngurutake data pitakon sadurunge ngasilake data:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- Sampeyan bisa nggunakake kolom apa wae minangka kondisi ngurutake kanggo ngasilake asil pitakon sing diurutake.
- Sampeyan bisa nyetel macem-macem kolom kanggo ngurutake.
- Sampeyan bisa nggunakake tembung kunci ASC utawa DESC kanggo nyetel asil pitakon supaya diurutake kanthi urutan munggah utawa mudhun.Kanthi gawan, iku ing urutan munggah.
- Sampeyan bisa nambah WHERE...LIKE klausa kanggo nyetel kahanan.
Nggunakake klausa ORDER BY ing command prompt
Ing ngisor iki bakal nggunakake klausa ORDER BY ing statement SQL SELECT kanggo maca data ing tabel data MySQL chenweiliang_tbl:
Kadadeyan
Coba conto ing ngisor iki lan asil bakal diurutake kanthi urutan munggah lan mudhun.
Urut 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)
Waca kabeh data ing tabel chenweiliang_tbl lan urutake munggah miturut kolom submission_date.
Nggunakake klausa ORDER BY ing skrip PHP
Sampeyan bisa nggunakake fungsi PHP mysqli_query () lan perintah SQL SELECT sing padha karo klausa ORDER BY kanggo entuk data.
Fungsi iki digunakake kanggo nglakokaké printah SQL banjur output kabeh data queried liwat fungsi PHP mysqli_fetch_array ().
Kadadeyan
Coba conto ing ngisor iki, data sing ditakoni bali ing urutan mudhun saka kolom tanggal_kirim.
MySQL ORDER BY tes:
<?
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);
?>Blog Hope Chen Weiliang ( https://www.chenweiliang.com/ ) nuduhake "MySQL multi-field conditional sorting? MySQL supaya kanthi mudhun lan munggah statement query / fungsi ", kang mbiyantu kanggo sampeyan.
Sugeng rawuh kanggo nuduhake link artikel iki:https://www.chenweiliang.com/cwl-476.html
Mbukak kunci pitulung AI lan pamit kanggo karya sing ora efisien! 🔓💼
🔔 Entuk "DeepSeek Prompt Word Artifact" langsung ing direktori sing disematake saluran! 🎯
📚 Kangen = Mundur sak lawase! Tumindak saiki! ⏳💨
Share lan seneng yen sampeyan seneng! Enggo bareng lan seneng sampeyan minangka motivasi terus!