blocks|key|2701525|text|使用以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2701526|ALTER+TABLE+tableName+CHANGE+oldcolname+newcolname+datatype(length);|code-block|syntax|javascript|2701527|RENAME函数用于Oracle数据库。|offset|length|style|CODE|2701528|ALTER+TABLE+tableName+RENAME+COLUMN+oldcolname+TO+newcolname+datatype(length);|2701529|2701530|@lad2025在下面提到了这一点，但我想补充一下他说的话会更好。谢谢@lad2025！|2701531|您可以使用MySQL+8.0中的RENAME+COLUMN重命名需要重命名的任何列。|2701532|ALTER+TABLE+table_name+RENAME+COLUMN+old_col_name+TO+new_col_name;|2701533|2701534|+ALTER+TABLE+Syntax：重命名列：|blockquote|BOLD|2701535|2701536|2701537|与在不更改列定义的情况下重命名列相比，|2701538|可以更改列名，但不能更改其definition.|unordered-list-item|2701539|More。|2701540|2701541|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/49925232/4762528|1|https://dev.mysql.com/doc/refman/8.0/en/alter-table.html^0|0|0|0|6|0|0|0|0|8|0|0|G|D|0|0|0|K|5|1|I|1|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1M|8|@$I|1N|J|1O|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|1P|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1R|8|@]|9|@$I|1S|J|1T|1|1U]]|A|$]]|$1|R|3|S|5|6|7|1V|8|@$I|1W|J|1X|K|L]]|9|@]|A|$]]|$1|T|3|U|5|D|7|1Y|8|@]|9|@]|A|$E|F]]|$1|V|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|W|3|X|5|Y|7|20|8|@$I|21|J|22|K|Z]]|9|@$I|23|J|24|1|25]]|A|$]]|$1|10|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|28|8|@]|9|@]|A|$]]|$1|14|3|15|5|16|7|29|8|@]|9|@]|A|$]]|$1|17|3|18|5|16|7|2A|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]]|1B|$1C|$5|1D|1E|1F|A|$1G|1H]]|1I|$5|1D|1E|1F|A|$1G|1J]]]]

Use the following query:
<pre><code>ALTER TABLE tableName CHANGE oldcolname newcolname datatype(length);
</code></pre>
The <code>RENAME</code> function is used in Oracle databases.
<pre><code>ALTER TABLE tableName RENAME COLUMN oldcolname TO newcolname datatype(length);
</code></pre>
<hr />
<a href="https://stackoverflow.com/a/49925232/4762528">@lad2025</a> mentions it below, but I thought it'd be nice to add what he said. Thank you @lad2025!
You can use the <code>RENAME COLUMN</code> in MySQL 8.0 to rename any column you need renamed.
<pre><code>ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;
</code></pre>
<blockquote>
<a href="https://dev.mysql.com/doc/refman/8.0/en/alter-table.html" rel="noreferrer">ALTER TABLE Syntax</a>:
RENAME COLUMN:
<ul>
<li>Can change a column name but not its definition.</li>
<li>More convenient than CHANGE to rename a column without changing its definition.</li>
</ul>
</blockquote>

blocks|key|2701543|text|在服务器版本中:+5.6.34+MySQL社区服务器|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2701544|ALTER+TABLE+table_name
CHANGE+COLUMN+old_column_name+new_column_name+data_type;|code-block|syntax|javascript|2701545|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In Server version: 5.6.34 MySQL Community Server

<pre><code>ALTER TABLE table_name
CHANGE COLUMN old_column_name new_column_name data_type;
</code></pre>

blocks|key|2701607|text|来自MySQL+5.7+Reference+。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2701608|语法：|2701609|2701610|+ALTER+TABLE+t1+CHANGE+a+b+DATATYPE；|blockquote|2701611|2701612|2701613|例如:对于具有列customer_name，customer_street，customercity.的Customer表|2701614|我们希望将customercity更改为customer_city：|2701615|alter+table+customer+change+customercity+customer_city+VARCHAR(225);|code-block|syntax|javascript|2701616|entityMap^0|2|J|0|0|0|0|0|0|8|D|M|F|12|C|1G|8|0|5|C|K|D|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|12|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|13|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|14|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|15|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|16|8|@$9|17|A|18|B|C]|$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1F|8|@$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|R|3|S|5|T|7|1K|8|@]|D|@]|E|$U|V]]|$1|W|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]]|X|$]]

From MySQL 5.7 Reference <a href="https://dev.mysql.com/doc/refman/5.7/en/alter-table.html" rel="noreferrer">Manual</a>.

Syntax :

<blockquote>
 ALTER TABLE t1 CHANGE a b DATATYPE;
</blockquote>

e.g. : for Customer TABLE having COLUMN customer_name, customer_street, customercity.

And we want to change customercity TO customer_city :

<pre><code>alter table customer change customercity customer_city VARCHAR(225);
</code></pre>

blocks|key|133376|text|在MySQL+8.0中，您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|133377|ALTER+TABLE+table_name+RENAME+COLUMN+old_col_name+TO+new_col_name;|code-block|syntax|javascript|133378|133379|+ALTER+TABLE+Syntax：|blockquote|offset|length|133380|133381|重命名列：|style|BOLD|133382|133383|133384|可以更改列名，但不能更改其定义。|unordered-list-item|133385|133386|133387|在不更改列定义的情况下重命名列比更改列更方便。|133388|133389|133390|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/alter-table.html^0|0|0|0|1|I|0|0|0|0|5|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|1D|8|@]|9|@$K|1E|L|1F|1|1G]]|A|$]]|$1|M|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1I|8|@$K|1J|L|1K|P|Q]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|T|3|U|5|V|7|1N|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|V|7|1Q|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]]|13|$14|$5|15|16|17|A|$18|19]]]]

From MySQL 8.0 you could use
<pre><code>ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;
</code></pre>
<blockquote>
<a href="https://dev.mysql.com/doc/refman/8.0/en/alter-table.html" rel="noreferrer">ALTER TABLE Syntax</a>:
RENAME COLUMN:
<ul>
<li>Can change a column name but not its definition.
</li>
<li>More convenient than CHANGE to rename a column without changing its definition.
</li>
</ul>
</blockquote>
<a href="https://dbfiddle.uk/?rdbms=mysql_8.0&amp;fiddle=dc21e8c179aa5325d9f337c54cb0e63f" rel="noreferrer">DBFiddle Demo</a>

blocks|key|2701643|text|您可以使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2701644|ALTER+TABLE+`dbName`.`tableName`+CHANGE+COLUMN+`old_columnName`+`new_columnName`+VARCHAR(45)+NULL+DEFAULT+NULL+;|code-block|syntax|javascript|2701645|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use following code:

<pre><code>ALTER TABLE `dbName`.`tableName` CHANGE COLUMN `old_columnName` `new_columnName` VARCHAR(45) NULL DEFAULT NULL ;
</code></pre>

blocks|key|134811|text|ALTER+TABLE+`table_name`+CHANGE+`$old_column_name`+`new_column_name`+VARCHAR(40)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|134812|这对我很有效|unstyled|134813|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>ALTER TABLE `table_name` CHANGE `$old_column_name` `new_column_name` VARCHAR(40)
</code></pre>
this is working for me

blocks|key|2701652|text|mysql中的重命名列名|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2701653|alter+table+categories+change++type++category_type+varchar(255);|code-block|syntax|javascript|2701654|entityMap^0|7|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Rename column name in mysql

<pre><code>alter table categories change type category_type varchar(255);
</code></pre>

blocks|key|2913997|text|在mysql中，您的查询应该如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2913998|ALTER+TABLE+table_name+change+column_1+column_2+Data_Type;|code-block|syntax|javascript|2913999|您已经在Oracle中编写了查询。|2914000|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In mysql your query should be like 

<pre><code>ALTER TABLE table_name change column_1 column_2 Data_Type;
</code></pre>

you have written the query in Oracle.

blocks|key|2914006|text|语法:+ALTER+TABLE+table_name+CHANGE+old_column_name+new_column_name+datatype；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2914007|如果表名为学员，列名为+name+。然后，如果要将Name更改为First_Name|offset|length|style|BOLD|2914008|ALTER+TABLE+Student+CHANGE+Name+First_Name+varchar(20);|code-block|syntax|javascript|2914009|entityMap^0|0|5|2|B|6|P|4|W|A|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]|$D|S|E|T|F|G]|$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|N|$]]

Syntax: ALTER TABLE table_name CHANGE old_column_name new_column_name datatype;

If table name is Student and column name is Name.
Then, if you want to change Name to First_Name 

<pre><code>ALTER TABLE Student CHANGE Name First_Name varchar(20);
</code></pre>

blocks|key|136457|text|https://dev.mysql.com/doc/refman/8.0/en/alter-table.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|136458|对于MySQL+8|136459|alter+table+creditReportXml_temp+change+column+applicationID+applicantID+int(11);|code-block|syntax|javascript|136460|entityMap|0|LINK|mutability|MUTABLE|url^0|0|1K|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|4]]]]

<a href="https://dev.mysql.com/doc/refman/8.0/en/alter-table.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/alter-table.html</a>

For MySQL 8

<pre><code>alter table creditReportXml_temp change column applicationID applicantID int(11);
</code></pre>

blocks|key|2913852|text|对于mysql版本5|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2913853|alter+table+*table_name*+change+column+*old_column_name*+*new_column_name*+datatype();|offset|length|style|CODE|2913854|entityMap^0|0|0|2E|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

for mysql version 5

<code>alter table *table_name* change column *old_column_name* *new_column_name* datatype();</code>

blocks|key|136091|text|使用ALTER+TABLE命令重命名MySQL列|type|unstyled|depth|inlineStyleRanges|entityRanges|data|136092|ALTER+table是用于更改MySQL表结构的基本命令。您可以使用它来添加或删除列，更改列中的数据类型，甚至重命名整个数据库。我们最关心的函数是如何利用ALTER+TABLE来重命名列。|136093|子句为我们提供了对重命名过程的额外控制。RENAME+COLUMN和CHANGE子句都允许更改现有列的名称。不同之处在于，CHANGE子句还可用于更改列的数据类型。这些命令很简单，您可以使用最适合您的需求的子句。|136094|如何使用RENAME+COLUMN子句(MySQL+8.0)|136095|重命名列的最简单方法是使用ALTER+TABLE命令和rename+column子句。此子句从MySQL+8.0版开始可用。|136096|让我们来演示一下它的简单语法。要更改列名，请在MySQL+shell中输入以下语句：|136097|ALTER+TABLE+your_table_name+RENAME+COLUMN+original_column_name+TO+new_column_name;|code-block|syntax|javascript|136098|将your_table_name、original_column_name和new_column_name与您的表名和列名进行交换。请记住，不能将列重命名为表中已存在的名称。|136099|注意：是ALTER+TABLE+RENAME+COLUMN命令所必需的。ALTER+table+RENAME是重命名整个表的现有语法。|offset|length|style|BOLD|136100|RENAME+column子句只能用于重命名列。如果需要其他函数，例如更改数据定义或列的位置，则需要使用CHANGE子句。|136101|使用CHANGE子句重命名MySQL列|136102|CHANGE子句为重命名过程提供了重要的补充。它可用于重命名列，并使用相同的命令更改该列的数据类型。|136103|在MySQL客户端shell中输入以下命令，以更改列的名称及其定义：|136104|ALTER+TABLE+your_table_name+CHANGE+original_column_name+new_col_name+data_type;|136105|即使您想保留现有的数据类型，data_type元素也是必需的。|136106|使用其他选项可进一步操作表列。此更改还允许您使用可选的FIRST+%7C+AFTER+column_name子句将列放置在表中的不同位置。例如：|136107|ALTER+TABLE+your_table_name+CHANGE+original_column_name+new_col_name+y_data_type+AFTER+column_x;|136108|您已经成功地更改了列的名称，将数据类型更改为y_data_type，并将列定位在column_x之后。|136109|entityMap^0|0|0|0|0|0|0|0|0|0|3|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1J|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1K|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1L|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1M|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1N|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1O|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1P|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1Q|8|@$U|1R|V|1S|W|X]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1T|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1U|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1V|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1W|8|@]|9|@]|A|$]]|$1|16|3|17|5|N|7|1X|8|@]|9|@]|A|$O|P]]|$1|18|3|19|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|N|7|20|8|@]|9|@]|A|$O|P]]|$1|1E|3|1F|5|6|7|21|8|@]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|22|8|@]|9|@]|A|$]]]|1H|$]]

<h1>Rename MySQL Column with ALTER TABLE Command</h1>
ALTER TABLE is an essential command used to change the structure of a MySQL table. You can use it to add or delete columns, change the type of data within the columns, and even rename entire databases. The function that concerns us the most is how to utilize ALTER TABLE to rename a column.
Clauses give us additional control over the renaming process. The RENAME COLUMN and CHANGE clause both allow for the names of existing columns to be altered. The difference is that the CHANGE clause can also be used to alter the data types of a column. The commands are straightforward, and you may use the clause that fits your requirements best.
<h2>How to Use the RENAME COLUMN Clause (MySQL 8.0)</h2>
The simplest way to rename a column is to use the ALTER TABLE command with the RENAME COLUMN clause. This clause is available since MySQL version 8.0.
Let’s illustrate its simple syntax. To change a column name, enter the following statement in your MySQL shell:
<pre><code>ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;
</code></pre>
Exchange the your_table_name, original_column_name, and new_column_name with your table and column names. Keep in mind that you cannot rename a column to a name that already exists in the table.
Note: The word COLUMN is obligatory for the ALTER TABLE RENAME COLUMN command. ALTER TABLE RENAME is the existing syntax to rename the entire table.
The RENAME COLUMN clause can only be used to rename a column. If you need additional functions, such as changing the data definition, or position of a column, you need to use the CHANGE clause instead.
<h2>Rename MySQL Column with CHANGE Clause</h2>
The CHANGE clause offers important additions to the renaming process. It can be used to rename a column and change the data type of that column with the same command.
Enter the following command in your MySQL client shell to change the name of the column and its definition:
<pre><code>ALTER TABLE your_table_name CHANGE original_column_name new_col_name data_type;
</code></pre>
The data_type element is mandatory, even if you want to keep the existing datatype.
Use additional options to further manipulate table columns. The CHANGE also allows you to place the column in a different position in the table by using the optional FIRST | AFTER column_name clause. For example:
<pre><code>ALTER TABLE your_table_name CHANGE original_column_name new_col_name y_data_type AFTER column_x;
</code></pre>
You have successfully changed the name of the column, changed the data type to y_data_type, and positioned the column after column_x.

blocks|key|134804|text|在MySQL中更改名称我们必须使用"ALTER“table命令，后跟"CHANGE”。下面是查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|134805|ALTER+TABLE+tablename+CHANGE+COLUMN+oldcolname+newcolname+datatype;|offset|length|style|CODE|134806|ALTER+TABLE+tablename+CHANGE+oldcolname+newcolname+datatype;|134807|PS-您可以在查询中添加"COLUMN“单词或忽略。它的工作原理是一样的。|134808|"RENAME“在Oracle数据库中使用。|134809|entityMap^0|0|0|1V|0|0|1O|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|O|$]]

Changing name in MySQL we have to use &quot;ALTER&quot; table command followed by &quot;CHANGE&quot;. Below is the query.
<code>ALTER TABLE tablename CHANGE COLUMN oldcolname newcolname datatype;</code>
<code>ALTER TABLE tablename CHANGE oldcolname newcolname datatype;</code>
PS- You can add &quot;COLUMN&quot; word or ignore in the query. It will work same.
&quot;RENAME&quot; is used in Oracle database.

blocks|key|2701823|text|ALTER+TABLE+table_name+CHANGE+old_column_name+new_column_name+columnDataType;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2701824|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>ALTER TABLE table_name CHANGE old_column_name new_column_name columnDataType;
</code></pre>

blocks|key|134838|text|适用于MySQL+<=+8|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|134839|ALTER+TABLE+table_names+CHANGE+`old_column_name`+`new_column_name`+varchar(50);|code-block|syntax|javascript|134840|entityMap^0|3|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

For MySQL &lt;= 8
<pre><code>ALTER TABLE table_names CHANGE `old_column_name` `new_column_name` varchar(50);
</code></pre>

blocks|key|2914084|text|如果您正在使用gui+SQL+SMS。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2914085|您可以执行要重命名的db+->表->表->列->列|2914086|右键单击并重命名|2914087|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

if you are using gui SQL SMS
you can do db -&gt; Tables -&gt; Table -&gt; columns -&gt; column you want to rename
right click and rename

I am trying to rename a column in MySQL community server 5.5.27 using this SQL expression:



<pre class="lang-sql prettyprint-override"><code>ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;
</code></pre>

I also tried

<pre class="lang-sql prettyprint-override"><code>ALTER TABLE table_name RENAME old_col_name TO new_col_name;
</code></pre>

But it says:

<blockquote>
 Error: check the Manual that corresponds to your MySQL server version
</blockquote>

Rename a column in MySQL

Oracle数据库

数据库

服务器

MySQL

我正在尝试使用以下MySQL表达式重命名SQL 5.5.27中的列：ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;我也试过了ALTER TABLE table_name RENAME old_col_name TO new_col_name;但上面写着：错误:请查看与您的MySQL服务器版本对应的手册

问在MySQL中重命名列
EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL中重命名列EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在MySQL中重命名列
EN