Inserting New Data in SQL

The INSERT INTO statement makes inserting new data into the database very easy. All you need to do is specify into which table you want to insert data, into which columns to insert data, and finally what data to insert. The basic syntax is as follows: INSERT INTO table_name (column_names) VALUES (data_values) This line of code adds a record to the Category table: INSERT INTO Category (CategoryId, Category) VALUES (1, ‘Thriller’); You can see that inserting data is simply a matter of listing each column name (separated by a comma) in the...

read more