I'm a student and wanting to know if the syntax for C++ insert/update/delete statements for adding records to a table is the same or similar to statements in SQL?
I've searched and can't really find a difinitive answer for C++.

ie.
insert into tableName values whatever
delete from tableName values where columnName = "whatever"

Recommended Answers

All 2 Replies

Well do you want the SQL syntax or do you want to know how to do it in C++ because you need separate libraries to do things like that in C++ (If I had to recommend one I'd suggest SQLite)

SQL and C++ are two completely different language.
C++ is a (real) programming language. While SQL is a query language intended to interpreted by a RDBMS.
In fact, the entire MySQL is written in C++ [1].
What you can do is perhaps call the SQL queries from a C++ program; that will require you to mess up with few SQL libraries (search the web to find a apt one).

[1]:http://www.research.att.com/~bs/applications.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.