如何改变所列的值mysql
代码示例
N
UPDATE tableName SET columnName = yourValue;
#to update multiple columns:
UPDATE tableName SET column1 = value1, column2 = value2; #and so onN
mysql> DESCRIBE users;
+---------+------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+-------------------+-----------------------------+
| id | int(11) | NO | MUL | NULL | |
| name | varchar(255) | YES | | NULL | |
| address | varchar(10) | YES | | NULL | |
| date | timestamp | NO | | CURRENTTIMESTAMP | on update CURRENTTIMESTAMP |
| uid | int(10) unsigned | NO | PRI | NULL | auto_increment |
+---------+------------------+------+-----+-------------------+-----------------------------+类似页面
带有示例的类似页面
其他语言
此页面有其他语言版本
empty row
Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................