please give me suggestions for my database
Posted: Fri Sep 02, 2005 12:47 am
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
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