Build C/C++ Applications Using MySQL Connector and Visual Studio 2022 | Connect C/C++ to MySQL

How to build C/C++ programs using the MySQL connector/c++ and Visual Studio 2022 on Windows. How to connect C/C++ applications to MySQL database.
**********************

***********************************

🔥 *Complete Udemy Courses* :

⬇️ *Free Document Proofreading* ⬇️

[BoostMyTool]

#include <stdlib.h>
#include <iostream>

#include "mysql_connection.h"
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include
using namespace std;

//for demonstration only. never save your password in the code!
const string server = "tcp://127.0.0.1:3306";
const string username = "root";
const string password = "";

int main()
{
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::PreparedStatement *pstmt;

try
{
driver = get_driver_instance();
con = driver->connect(server, username, password);
}
catch (sql::SQLException e)
{
cout << "Could not connect to server. Error message: " << e.what() << endl;
system("pause");
exit(1);
}

//please create database "quickstartdb" ahead of time


stmt = con->createStatement();
stmt->execute("DROP TABLE IF EXISTS inventory");
cout << "Finished dropping table (if existed)" << endl;
stmt->execute("CREATE TABLE inventory (id serial PRIMARY KEY, name VARCHAR(50), quantity INTEGER);");
cout << "Finished creating table" << endl;
delete stmt;

pstmt = con->prepareStatement("INSERT INTO inventory(name, quantity) VALUES(?, ?)");
pstmt->setString(1, "banana");
pstmt->setInt(2, 150);
pstmt->execute();
cout << "One row inserted." << endl;

pstmt->setString(1, "orange");
pstmt->setInt(2, 154);
pstmt->execute();
cout << "One row inserted." << endl;

pstmt->setString(1, "apple");
pstmt->setInt(2, 100);
pstmt->execute();
cout << "One row inserted." << endl;

delete pstmt;
delete con;
system("pause");
return 0;
}

[geraldmacherechedze]

This is the ONLY video that helped me, there isn't much info about C++ on YouTube, Thanks ALOT!

[Bob-Is-A-PotterNow]

Thanks for both the tutorial AND example source. I used to hate "excercise left to the student." It's been some time since working with VC++ and SQL, this serves as a great refresher!

[aleksandrguz]

Thanks pal. You are the only one who can explain me how to include mySQL to cpp code)

[nevell]

Thank very very very much man, I don't know what I would have done without your guide, really thanks!

[yegorkliushin]

I LOVE YOU!!!!
The only one mornal guide that i found during the whole day

[Auditor]

Thanks so much dude, you really saved me there. Quick and simple.

[baageledilepodisi]

i followed the instructions but run into "application error (0xc0150002)" on debugging

[sudarson]

Thanks for the tutorial! You're a life saver.

[anishkashyap]

Very nice content sir. It was getting very difficult for me to connect c++ and mysql but you helped me a lot 🥺🥺

[nguyenxuanthong]

great! it worked for me
Thanks a lot <3

[adityarajamani]

wait this video only shows how to write data into sql....but how do i read info frm sql into c++?

[onlyc]

FRIEND THANK YOU SO MUCH! I 3 COULD NOT CONNECT THE LIBRARY TO MY PROJECT! YOU ARE THE BEST HINDUS I HAVE EVER MEET AND WILL MEET IN THE FUTURE!

[essersr-]

Thank you for this video who was really useful. Something that I wanted to say however, is that I immediately knew you were Tunisian from the 2 first seconds. Man fallatch sout tounsi mebin lelef 😂. Barakallahou fik khouya !

[footballvids]

What about newer versions of VSC? How do I access the project's properties there?

[shahinabdullayev]

Thank you for the video. I did as you but when bulding the prject link errors (LNK2001) appear. I don't why. Could you help me if you know the solution. I am using Visual Studio 2022.

[elshodnematov]

cannot open source file mysql_connection.h and others, what should I do?

[barok]

Thnak you very much, you solve my problem.

[mode-]

nice guide bro, thank u so mutch u angel from the sky, whoo help in hard situation and more smart than all people in Internet
❤❤

[vlados]

OH MY GOD THANKS I LOVE YOU MY BROTHER ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤