Task1: Run sql queries to MySql from a programming language 1- Program in C/C++.

Question

Task1: Run sql queries to MySql from a programming language

1- Program in C/C++.

2- Write the code required to connect to MySql

3- Write the code to execute the following queries

Query 1

SELECT S.snum, S.sname
FROM Student S , Enrolled E
WHERE S.snum = E.snum AND E.cname =

Run sql queries to MySql from a programming language Program in C/C++. Write the code required to connect to MySql Write the code to execute the following queries SELECT S.snum, S.sname FROM Student S , Enrolled E WHERE S.snum = E.snum AND E.cname = CSCI 4707 SELECT COUNT(S.snum), E.cname FROM Student S, Enrolled E WHERE S.snum=E.snum GROUP BY E.cname; Copy both the code and response to your answer sheet. Create trigger on student table to be automatically executed after an update occurs on the table. The function of this trigger is to add 1 to the students age if its id is updated. It can be written directly to MySql. Execute an update query on student table to update one student id from your programming language. Copy your trigger code, your programming code for executing the update query, and the response of execution to your answer sheet.

Explanation / Answer

c++ code to connect and execute the query #include #include #include using namespace std; #define SERVER "HOST" #define USER "USR" #define PASSWORD "PSWD" #define DATABASE "example" int main() { MYSQL *connect; connect=mysql_init(NULL);// connecting done here if (!connect) { cout

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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