|
|
Insert RecordINSERT INTO People (firstname, LName, address) values ('John', 'Smith', '100 Main Street')The SQL Statement above will insert THREE fields: firstname, LName, address into the table named People: INSERT INTO People The following values respectively: 'John', 'Smith', '100 Main Street' When dealing with numbers do the following (no quotes)INSERT INTO People (studentid, age, no_children) values (1234, 45, 4)The SQL Statement above will insert THREE fields: studentid, age, no_children into the table named People: INSERT INTO People The following values respectively: 1234, 45, 4 |