 |  |  |  |  |  |  |  |
Export SQL Query
Please support our C++ advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
•
•
Join Date: Mar 2008
Posts: 64
Reputation: 
Solved Threads: 5
Junior Poster in Training
I've posted something along these lines before, but it's a tad bit different this time, hopefully some of you can point me in the right direction.
I'm designing a tool that will make adding things to a database easy for people not familiar with SQL, it will basically export a query to the SQL server, and I don't really know how to do that. It will require authentication for the SQL (MySQL 5.0). Any help you can give me would very much be appreciated.
I'm designing a tool that will make adding things to a database easy for people not familiar with SQL, it will basically export a query to the SQL server, and I don't really know how to do that. It will require authentication for the SQL (MySQL 5.0). Any help you can give me would very much be appreciated.
•
•
Join Date: Aug 2005
Posts: 15,678
Reputation: 
Solved Threads: 1503
I'm confused -- you want to write a c++ SQL class but you don't know the SQL language yourself ??
Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.
•
•
Join Date: Mar 2008
Posts: 64
Reputation:
Solved Threads: 5
Junior Poster in Training
No, I'm sorry I just re-read that first post, I was tired when I made it, let me revise.
I'm writing a tool that will be used to create an SQL file. I know the table structure for the SQL, I just want to know how I get it to the MySQL server, actually have the program export it to the server. Sorry for my fragmented post earlier.
I saw something in an earlier post, called ODBC or something like that, would that be beneficial?
I'm writing a tool that will be used to create an SQL file. I know the table structure for the SQL, I just want to know how I get it to the MySQL server, actually have the program export it to the server. Sorry for my fragmented post earlier.
I saw something in an earlier post, called ODBC or something like that, would that be beneficial?
Last edited by Maulth; May 14th, 2008 at 7:15 pm.
•
•
Join Date: Aug 2005
Posts: 15,678
Reputation:
Solved Threads: 1503
yes, ODBC is one way, and is supported by most, if not all, modern SQL compliant data bases. There are already several free odbc c++ classes. So what you are trying to do has already been done several times in the past 10 or so years.
For MySql specifically, you can download free MySQL++.
For MySql specifically, you can download free MySQL++.
Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.
 |
Similar Threads
- uploading large txt file into phpmyadmin? (MySQL)
- query mdf directly? (MS SQL)
- How to import Excel Sheet data into SQL Server 2003 ???? Stpes. (MS SQL)
- SQL/XML Query (XML, XSLT and XPATH)
- Export DataTable to Excel with variable number of fields (VB.NET)
- Export to Excel from ASP.NET app (ASP.NET)
- Crystal Report Problem (ASP.NET)
- simply generate user front end for mysql ? (MySQL)
- Import/export tab delimited file (PHP)
- MySQL Maestro (Computer Science)
Other Threads in the C++ Forum
- Previous Thread: Issue with array assignment
- Next Thread: Text file traverse problem
Views: 1072 | Replies: 4
| Thread Tools | Search this Thread |
Latest C++ Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for C++
6 api application array arrays assignment beginner binary bitmap c++ c/c++ calculator char char* class classes code coding compile compiler console conversion convert count data database delete developer display dll email encryption error file format forms fstream function functions game generator getline givemetehcodez graph iamthwee ifstream image input int java lib loop looping loops map math matrix memory multidimensional multiple newbie news node number numbertoword output pointer problem program programming project python random read recursion recursive reference return rpg sort sorting string strings struct template templates text tree url variable vector video visual visualstudio win32 windows winsock word wordfrequency wxwidgets
