Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hi, all: Could someone give me a
- Thread starter hz
- Start date
hi hz,
mysql> ALTER TABLE mytable CHANGE COLUMN old_col_name
new_col_name VARCHAR(25)
check the ALTER TABLE command in the manual.
Cheers [sig]<p>Ken<br><a href=mailto:admin@mysqlwebring.com>admin@mysqlwebring.com</a><br><a href= Webring</a><br>[/sig]
mysql> ALTER TABLE mytable CHANGE COLUMN old_col_name
new_col_name VARCHAR(25)
check the ALTER TABLE command in the manual.
Cheers [sig]<p>Ken<br><a href=mailto:admin@mysqlwebring.com>admin@mysqlwebring.com</a><br><a href= Webring</a><br>[/sig]
Guest_imported
New member
- Jan 1, 1970
- 0
Thanks, Ken.
I knew this ALTER command from reading the manual, but I can't find a similiar command ONLY do the rename without redefining the data type! Any ideas?
I knew this ALTER command from reading the manual, but I can't find a similiar command ONLY do the rename without redefining the data type! Any ideas?
- Status
Similar threads
- Locked
- Question
