How can I change a field name in mysql?

Wrox Programmer Forums

		Wrox Programmer Forums > PHP/MySQL > Beginning PHP
How can I change a field name in mysql?

Beginning PHP Beginning-level PHP discussions. More advanced coders should post to the Pro PHP forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning PHP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 1st, 2003, 07:39 AM

scifo

scifo is offline

Authorized User

Join Date: Jul 2003

Posts: 11

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How can I change a field name in mysql?

I could not find any function or SQL statement to do this.

MEG

Old

August 1st, 2003, 07:45 AM

a5xo3z1

a5xo3z1 is offline

Authorized User

Join Date: Jun 2003

Posts: 26

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Hi scifo,

take a look at the ALTER TABLE statement, which is explained here

http://www.mysql.com/doc/en/ALTER_TABLE.html

Cheers,
Frank

Old

August 1st, 2003, 09:41 AM

scifo

scifo is offline

Authorized User

Join Date: Jul 2003

Posts: 11

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Sorted
Thanx.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with change postgreSQL connection to MySQL	chadneiro	PHP How-To	2	July 7th, 2010 12:37 PM
The Totals Field doesn't change with Paging.	sams	ASP.NET 1.0 and 1.1 Professional	4	June 22nd, 2007 02:23 AM
how to change values in asp:bound field	hertendreef	ASP.NET 2.0 Professional	3	May 31st, 2006 08:45 AM
change the 'From...' field in email	Derek_05	Access VBA	1	February 15th, 2006 08:47 AM
How to change the display control for Yes/No field	Caz	Access VBA	1	June 21st, 2004 11:55 AM