/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

2 votes320 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote315 views1 answer
What is the use of index in mysql table
SQL
0 vote291 views1 answer
Sqlite3 now
SQL
0 vote321 views1 answer
Login failed for login due to trigger execution
SQL
0 vote349 views1 answer
Drop index in sql
SQL
0 vote323 views1 answer
What is default mysql database password in linux
SQL
4 votes323 views4 answers
Sqlite describe table
SQL
0 vote385 views2 answers
Sql query print strings and int
SQL
0 vote359 views1 answer
Typical max-connect-errors mysql
SQL
0 vote317 views2 answers
Sql use not in
SQL

Share