[RESOLVED] Very simple questions

campsoup1988

I was woundering how to change the name of a field listing in mysql.

I was also woundering if it is possible to change the type of interger in the database in mysql for example, changing a varchar(40) to a varchar(100)

I was also woundering if it is possible to rearange the fields in a database.

Thanks,

Campsoup1988

thorpe

1 Take a look at ALTER TABLE.

2 Take a look at ALTER TABLE.

3 Why?

campsoup1988

thorpe wrote:
# 1 Take a look at ALTER TABLE.

2 Take a look at ALTER TABLE.

3 Why?

ok, I think that might have the answer to my first two questions, I need to look it over more carefully, I am not quiet used to the mysql manuel, since I was never given a copy of it when I was in the class, and it is a bit too big to download at home on dial-up (have to wait to school starts to download it)

my third question was not a big deal, but it was because I forgot to include a field listing in my table, and I did not want it listed on the bottom of the table.

Thanks,
Campsoup1988

bradgrafelman

campsoup1988 wrote:
I was also woundering if it is possible to rearange the fields in a database.

See this link. More specifically, the user comment posted by Aaron Powers.

campsoup1988

bradgrafelman wrote:
See this link. More specifically, the user comment posted by Aaron Powers.

Thank You! I did not think they include that feature since it does not seem to important! hugs

Thanks everyone!