Results 1 to 2 of 2
Thread: easy sql syntax question
Apr 28, 2003, 19:06 #1
easy sql syntax question
I have a DB table that I may want to add fields to in the future. How can I structure my insterts and updates so that adding fields wont break the queries?http://www.echo-consulting.net - Sound Solutions for Online Inspriations.
Apr 28, 2003, 19:37 #2
- Join Date
- Sep 2001
- 0 Post(s)
- 0 Thread(s)
If the new fields are NOT NULL, or don't have a default value, your queries will break no matter what you do.
That said, if your new fields can take NULL or default values, just remember to list the field list in your insert statements:
INSERT INTO table1 (field1, field2) VALUES ('value1', 'value2');
INSERT INTO table1 VALUES ('value1', 'value2');