/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

-1 vote245 views3 answers
Compute age mysql
SQL
0 vote232 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
56 votes413 views5 answers
Psql create user
SQL
0 vote250 views1 answer
SAP Return
SQL
0 vote275 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote239 views1 answer
Drop df constraint sql server
SQL
3 votes245 views1 answer
Laravel database Using Named Bindings
SQL
-1 vote238 views5 answers
Online sql to linq generator
SQL
49 votes243 views6 answers
Get duplicate records in sql
SQL
28 votes218 views4 answers
Mysql delete database
SQL

Share