Jump to content


Photo

Column Headings


  • Please log in to reply
1 reply to this topic

#1 cerin

cerin
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 18 February 2006 - 09:30 PM

While doing a tutorial I ran into a mistake where you make one of the column names the same as the table name. Even though it tells the reader to do it that way in the latter parts of the tutorial they have it set as something different. So, I was wondering how to change a column heading in a table, because it confuses me a little havin them both with the same name.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 February 2006 - 10:23 PM

ALTER TABLE has a CHANGE parameter that allows you to change both the name and type of the column -- check out [a href=\"http://dev.mysql.com/doc/refman/5.0/en/alter-table.html\" target=\"_blank\"]this refman page[/a].
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users