/SQL/How ot change name of column mysql

How ot change name of column mysql

How to alter table column name in mysql

ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;

6

Source: phoenixnap.com

How to change column name in mysql

alter table product change price price_kg float;

1

How ot change name of column mysql

ALTER TABLE tableName CHANGE `oldcolname` `newcolname` datatype(length);

0

Similar codes

0 vote133 views1 answer
Download mysql database to excel in android studio
SQL
0 vote141 views1 answer
How to inner join 4 tables in sql
SQL
12 votes145 views5 answers
Sql primary key
SQL
0 vote150 views1 answer
Postgresql port 5432 not open
SQL
2 votes128 views4 answers
Mysql select into new table
SQL
0 vote122 views1 answer
Psql check if value in array
SQL
0 vote142 views1 answer
Postgresql replace html tags from string
SQL
1 vote136 views2 answers
Procedure syntax
SQL
0 vote129 views1 answer
Oracle sql copy table without data
SQL
0 vote130 views2 answers
How to find sql server agent jobs related to a database
SQL

Share