articulus Directory
MySQLMulti agri conditionalis Sorting?MySQL ut descendendo ascendendo query dicitur / munus
MySQL generis
Scimus uti SQL SELECT constitutione data ex tabula MySQL legere.
Si opus est notitias legere, uti MySQL's PER ORDINEM clausula uter utri vis utra qua via, et inde proventum redde.
grammatica
Subsequens est SQL enunciatio SELECTA quae ordinem per clausulam adhibet ut interrogationis notitias exponat antequam notitia revertitur:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- Qualemlibet agrum uti potes ut condicione quadam ad reditus interrogationes digestos reddendos.
- Plures campos exstruere potes.
- ASC vel ASC keywords uti potes ut proventus interrogationis exponas ad ordinem ascendendum vel descendendum.Defalta, ascendendo.
- Potes addere UBI ... VELUT clausulas ad condiciones ponendas.
Using the order by clause in order prompt
Sequentia ordinem BY clausula in SQL propositione selecta utetur ut notitias in MySQL tabellae chenweiliang_tbl datas legas:
Exempli gratia
Exempla infra proba et eventus in ascendendo et descendendo ordinabuntur.
SQL sort
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)
Lege omnia data in mensa chenweiliang_tbl et qualia sunt in ordine ascendendo per campum submission_date.
Using the order by clause in a PHP script
Potes uti PHP functione mysqli_query() eodemque SQL SELECT imperio cum ORDINE BY clausula ut data.
Munus hoc adhibitum est ad SQL mandata exsequendam ac deinde omnia data quaestionis per PHP functionem mysqli_fetch_array output().
Exempli gratia
Conare hoc exemplum, data quaestionis ordine descendendo campi submissionis redditur.
ORDINE MySQL 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);
?>Spes Chen Weiliang Blog ( https://www.chenweiliang.com/ ) communis "MySQL multi campi condicionalis voluptua? MySQL ordo descendendo et ascendendo interrogationis enuntiatio/munus", quod utile est tibi.
Grata communicare nexum huius articuli:https://www.chenweiliang.com/cwl-476.html
Grata ad canalem Telegram Chen Weiliang's blog ut tardus updates!
📚 Hic dux ingens valorem continet, 🌟 Haec rara occasio est, id non fallunt! ⏰⌛💨
Share and like si libet!
Tua communicatio et similia continua sunt motiva nostra!