To add a record to the database, you use the INSERT INTO command. First you give the name of the table, and then you list the values for the fields. For example,
INSERT INTO Users VALUES (10, 'James Crowley', 'PASSWORD')
will add a new record to the Users table, filling the fields with 10, and James Crowley. Obviously, in this case, you need to know the order in which the fields come, and you can't miss any out. A better way is to specify the field names, thus telling the database what order you are giving the values for the fields in, and also which fields you want to include. For example
INSERT INTO Users (UserName, UserID) VALUES ('James Crowley',
10)
Note that in the above example, the UserID is given last, and the Password field is ignored. If you do miss any fields out, they will remain Null, or be given their default value. Please note that if a field is an AutoNumber, you should not include it when adding the records. The database will automatically assign a new value to it. For example, if the UserID field was an AutoNumber field (which would be very likely, as it would need a unique number for each record), you would use something like this:
INSERT INTO Users (UserName, Password) VALUES ('James Crowley',
'PASSWORD')
Comments