/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 vote176 views1 answer
Raven ql select count
SQL
0 vote218 views1 answer
Oracle table privileges
SQL
0 vote221 views1 answer
Get schema of table sql
SQL
0 vote213 views1 answer
Connect by query in oracle
SQL
2 votes187 views1 answer
Oracle create directory
SQL
1 vote257 views2 answers
Mysql limit offset
SQL
0 vote198 views1 answer
Connexion mysql
SQL
0 vote202 views1 answer
Oracle array
SQL
4 votes204 views1 answer
Add constraint fk
SQL
0 vote154 views1 answer
Ms sql print more than 1 variable
SQL

Share