Homework SourseCreate queries to display data for a project Create queries
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 .
Solution
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.
