Mysql Query

Help
, ,
#1

How to rename existing column name from table using mysql query

#2

Hi @Arun_Pondhe

Try this

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

Thanks
Ashwin S

#3

In my case RENAME keyword is not working …Error getting

ALTER TABLE Student_Record RENAME COLUMN StudentID TO EmployeeID;

#4

Hi @Arun_Pondhe
Do One thing drop the column as student id
ALTER TABLE Student_Record
DROP COLUMN StudentID

and
ALTER TABLE Student_Record
Add COLUMN Employee iD

Thanks
Ashwin S

#5

ALTER TABLE Student_Record
Add COLUMN Employee iD

not working ADD keyword :smile::smile: amazing

#6

Hi @Arun_Pondhe

Try this

ALTER TABLE Student_Record

ADD COLUMN Employee ID int AFTER Student ID

Thanks
Ashwin S