Page 1 of 1

please give me suggestions for my database

Posted: Fri Sep 02, 2005 12:47 am
by aaaphp000000
hi,
I create several tables in a mysql database, they are not used now because i need more knowledges of database modifications (i know "backup" first).

my questions:
is it harmful to existing rows of a table if i do:
(harmful = data lossing)

1. add new fields to the table.
2. change types of fields - i.e. from TINYINT(6) to TINYINT(8) or vice verse.
3. rename a field (can a field be renamed???).

thanks

Re: please give me suggestions for my database

Posted: Fri Sep 02, 2005 12:56 am
by feyd
aaaphp000000 wrote:1. add new fields to the table.
no.
aaaphp000000 wrote:2. change types of fields - i.e. from TINYINT(6) to TINYINT(8) or vice verse.
certain type changes have a chance of destructive. For example, changing varchar to int.
aaaphp000000 wrote:3. rename a field (can a field be renamed???)
renaming a field will do no damage; yes you can rename a field.