Re: MySql Alter table

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


.

Relevant Pages

  • Re: Combo-Box list unsorting
    ... RecordSource property and select it. ... it'll take you to the query. ... drag-dropping fields from Table1 to the Form. ... want one of the fields (say Field2) in Table1 and the Form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Combo-Box list unsorting
    ... I am still in the process of creating my database. ... However, in the form Field option, I still see Field2 (ex. ... query as the RowSource for the combo box rather than just the table. ... Source a field I (called visitType) in a table called visits. ...
    (microsoft.public.access.gettingstarted)
  • Re: need to delete record having two different fields with same identical value
    ... Assuming you're always comparing the same two fields (Field1 and Field2) ... Run the query to check it, and then turn it into a delete query. ... which might be a lot safer (I hate deleting data unless I ...
    (microsoft.public.access.gettingstarted)
  • Re: Using flexible query criteria
    ... criteria for the query is based on the user's input in the main form. ... One of the user inputs is a field called "Vendor_Name" (in the form of ... and said that Field1 is the primary key and is an autonumber field, and Field2 is the field shown in the combo box, you must modify it to a UNION select, similar to ...
    (comp.databases.ms-access)
  • Re: Group By, Max and Min
    ... SELECT field1, field2, field3, LAST, MIN, MAX ... I have (from a previous saved query) these fields: ...
    (microsoft.public.access.queries)