这是表格,我正试图将'letter'更改为'letters'。我试着
UPDATE table
SET Field = 'letters'
WHERE Type = 'varchar(32)'
但是不工作
+----------------+--------------+------+-----+-------------------+-------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+-------------------+-------------------+
| id | int | NO | PRI | NULL | auto_increment |
| ts | timestamp | YES | | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| phrase | varchar(128) | NO | | NULL | |
| letter | varchar(32) | NO | | NULL | |
| ip | varchar(16) | NO | | NULL | |
| browser_string | varchar(64) | NO | | NULL | |
| results | varchar(64) | NO | | NULL | |
+----------------+--------------+------+-----+-------------------+-------------------+
Update用于更改表中的数据。要更改表的结构,应该使用ALTER
命令。访问此链接:
重命名MySQL中的列