/SQL/How to alter table column name in mysql

How to alter table column name in 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

Change column name mysql command line

ALTER TABLE `members` ADD COLUMN `credit_card_number` VARCHAR(25);

2

Source: guru99.com

Rename table column name in mysql

ALTER TABLE table_name CHANGE old_column_name new_column_name datatype(length);

1

Alter table mysql

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id,
  ADD first_name varchar(35) NULL
    AFTER last_name;

0

Source: techonthenet.com

Similar codes

0 vote161 views1 answer
Myswql show full processlist
SQL
3 votes178 views1 answer
Oracle apex call duration
SQL
22 votes230 views4 answers
Date format mysql
SQL
-1 vote168 views1 answer
Sql syntax create timestamp column
SQL
0 vote180 views1 answer
Oracle procedure chain step
SQL
0 vote179 views1 answer
Traccar mysql
SQL
2 votes164 views1 answer
Drop table purge
SQL
0 vote178 views1 answer
Code to move ietms from one table to another myswl
SQL
-1 vote160 views1 answer
Plsql while
SQL
1 vote164 views3 answers
How to filter repeated same result using sql query
SQL

Share