Question

Write an INSERT statement that adds this row to the Categories table: category_name: Brass Code the INSERT statement so MySQL automatically generates the category_id column.

Answer 1

Answer:

Query:

insert into Categories (category_name) values ('Brass Code');

Explanation:

• The query is a medium through which a user of the database can communicate with the database or tables or any particular data. It means that when a user wants to access the database or tables or any data then there is a medium of query which is also known as SQL query.
• The query can help to make the database(which is a collection of tables), make the table in the database, add the data, modify the data or delete the data.
• For add the data there is a insert query which syntax is as follows: insert into table_name (column_1_name,column_2_name,....,column_n_name) values (column_1_values,column_2_values,....,column_n_values);
• There is only one column value in the question which a user needs to add so that can be done by the help of a statement that is defined on the answer part.