Create queries to display data for a project. Create queries to add data for you

Question

Create queries to display data for a project. Create queries to add data for your project. Explain why you design your queries as you did. By constructing an application that will be successfully utilize a MySQL features. Criteria: data display query created and structure explained . Data addition query created and structure explained . Create queries to display data for a project. Create queries to add data for your project. Explain why you design your queries as you did. By constructing an application that will be successfully utilize a MySQL features. Criteria: data display query created and structure explained . Data addition query created and structure explained . Criteria: data display query created and structure explained . Data addition query created and structure explained .

Explanation / Answer

If i am understanding this right the to display data we need select query and to add data we need insert query and if we are only talking about MySql queries then those could be as below but if we have different syntax(basically just for connection) in case we are using it in any programming language.

As no details of project and table are given so i am given query assuming Student table having name,age as two columns

1) Display data: Select * from Student;

This query will select all the data (all rows for all columns) in Student table.

2) Add Data : Insert into Student(name,age) values("John",25);

Here we are inserting data into table Student and first we specify columns and then their respective values.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.