MySQL database UPDATE potso joang? Ntlafatsa syntax/taelo/polelo

Mokhoa oa ho etsa potso ea NTLHAISO polokelongtshedimosetsong ea MySQL ? NTLHAISO ea mantsoe/litaelo/lipolelo.

MySQL UPDATE potso

Haeba re hloka ho fetola kapa ho ntlafatsa lintlha ho MySQL, re ka sebelisa taelo ea SQL UPDATE ho sebetsa. .

sebōpeho-puo

E latelang ke syntax e akaretsang ea SQL bakeng sa taelo ea UPDATE ea ho fetola data ea tafole ea MySQL:

UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]

• O ka ntlafatsa karolo e le 'ngoe kapa ho feta ka nako e le 'ngoe.
• O ka hlakisa boemo bofe kapa bofe ho poleloana ea WHERE.
• O ka ntlafatsa data ka nako e le 'ngoe tafoleng e le' ngoe.

Temana ea WHERE e thusa haholo ha o hloka ho nchafatsa data moleng o boletsoeng tafoleng ea data.

Ntlafatsa lintlha ka taelo ea taelo

Ka tlase re tla sebelisa poleloana ea WHERE ho taelo ea SQL UPDATE ho ntlafatsa lintlha tse boletsoeng tafoleng ea chenweiliang_tbl:

Mohlala

Mohlala o latelang o tla ntlafatsa boleng ba sebaka sa chenweiliang_title seo chenweiliang_id ea sona e leng 3 lethathamong la lintlha:

mysql> UPDATE chenweiliang_tbl SET chenweiliang_title='学习 C++' WHERE chenweiliang_id=3;
Query OK, 1 rows affected (0.01 sec)
 
mysql> SELECT * from chenweiliang_tbl WHERE chenweiliang_id=3;
+-----------+--------------+---------------+-----------------+
| chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 3 | 学习 C++ | chenweiliang.com | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
1 rows in set (0.01 sec)

Ho tsoa ho sephetho, chenweiliang_title eo chenweiliang_id ea eona e leng 3 e fetotsoe.

Ntlafatsa lintlha u sebelisa mongolo oa PHP

PHP e sebelisa mosebetsi mysqli_query() ho phethahatsa lipolelo tsa SQL, o ka sebelisa kapa oa se sebelise poleloana ea WHERE ho lipolelo tsa SQL UPDATE.

Hlokomela: O se ke wa sebedisa polelo ya WHERE ho ntjhafatsa data yohle e tafoleng, kahoo ela hloko.

Ts'ebetso ena e na le phello e ts'oanang le ho etsa polelo ea SQL ho mysql> taelo ea taelo.

Mohlala

Mohlala o latelang o tla ntlafatsa lintlha tsa sebaka sa chenweiliang_title seo chenweiliang_id e leng 3.

<?
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 = 'UPDATE chenweiliang_tbl
 SET chenweiliang_title="学习 Python"
 WHERE chenweiliang_id=3';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法更新数据: ' . mysqli_error($conn));
}
echo '数据更新成功！';
mysqli_close($conn);
?>