Task - Using CREATE
A grocery store's business is expanding, and they need an efficient way to keep track of their products. They hire you to make an application for them, which is based on a MySQL database where they can store and monitor all the products that they have in stock.
Your task is to write the C# code for:
- Connecting to your local MySQL database;
- Creating a new table called
products
with the following columns:
- id: A column of type integer;
- name: A string value up to 100 characters;
- category: A string representing the category of the product. Can be up to 100 characters;
- price: A float value representing the price;
- stock_quantity: An integer representing the quantity of the product available in stock.
You can either create and connect to a new database or use an existing one.
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.22
Task - Using CREATE
Swipe to show menu
A grocery store's business is expanding, and they need an efficient way to keep track of their products. They hire you to make an application for them, which is based on a MySQL database where they can store and monitor all the products that they have in stock.
Your task is to write the C# code for:
- Connecting to your local MySQL database;
- Creating a new table called
products
with the following columns:
- id: A column of type integer;
- name: A string value up to 100 characters;
- category: A string representing the category of the product. Can be up to 100 characters;
- price: A float value representing the price;
- stock_quantity: An integer representing the quantity of the product available in stock.
You can either create and connect to a new database or use an existing one.
Thanks for your feedback!