Posted by Rik on 05/30/06 11:37

lorento wrote:
> No problem, if you add new fields..it will not affect any data.
>
> But if you change the type of fields it will affect your data.

With a little remark on the side:
If you change the fields, it should be no problem if you've created your
queries to accommodate that.

Let's say you have a table 'table':
Fields: field1, field2, field3

Adding field4 betweeen field1 en field2

Now this query will work as you're used to:
"INSERT INTO `table` (`field1`,`field2`,`field3`) VALUES
('var1','var2','var3')"

This query will break:

"INSERT INTO `table` VALUES ('var1','var2','var3')"

Grtz,
--
Rik Wasmus

[Back to original message]