Databases
StackOverflow2013
Postsdbo
POpopulating a database from a file using c++
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpopulating a database from a file using c++
    primarykey
    data
    text
    <p>I've searched all over the net and looked in books, but I'm totally stuck. I'm trying to populate a database using a .txt file, sql and c++. I know one can use LOAD DATA INFILE, but I must use C++ for this project. </p> <p>Here is the database table in SQL:</p> <pre><code>create table Employee( employeeID char(5) not null, employeeTYPE char(15), employeeNAME char(25), hireYEAR integer, primary key(employeeID) ); </code></pre> <p>Here is the text file to be inserted into the database:</p> <pre><code>E0001 Assistant Joseph 2000 E0002 Assistant Thomas 2012 </code></pre> <p>I understand how to connect to the database and I know how to read into a file in C++, however I'm stuck on how to read into a file with the C++/SQL combo. Here is what I have so far for int main (), but any help or links would be so appreciated. Thank you:</p> <pre><code>int main () { MYSQL *connect, mysql; connect=mysql_init(&amp;mysql); //initialize the instance //log in and connect to the database connect=mysql_real_connect (connect, SERVER, USER, PASSWORD, DATABASE, 0, NULL, 0); //not included for privacy ifstream inFile; inFile.open ("employee.txt"); if (inFile.fail()) { cout &lt;&lt; "open for employee.txt. failed"; exit (1); } while (inFile) { mysql_query(connect, "insert into Employee values"); //not sure how to do this part... } inFile.close(); mysql_close(connect); return 0; } </code></pre> <p>//EDIT WITH ANSWER Thank you for the help, I have come to understand the problem. In order to read into the database from a file using C++ embedded in SQL, there are a few syntax ideas that must be known. </p> <p>For example, to concatenate a string, the "+" character is used. This differs from PHP where the "." character is used. Additionally, in order to utilize the ' character, an escape character \ must be used. </p> <p>Once you've connected to the database and opened the file using C++, you enter into a loop to read in from the file.</p> <p>the syntax to store the Insert statement in the string sql:</p> <pre><code> sql = "insert into TABLE values (\'"+ string1 + "\', \' " +string2 + " \', \'" +string3 + "\', \'" +string4+ "\')"; </code></pre> <p>Finally, in order to convert the strings to chars, the statement:</p> <pre><code>sql.c_str() </code></pre> <p>must be used as the second argument to mysql_query</p> <p>Hope this helps someone searching for help with this in the future. I'm a noob, so please let me know if there are any errors in my explanation above. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USuser2884789
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POpopulating a database from a file using c++
      1. USSoftware_Designer
      1. VTFavorite
    1. COYou really need to ask a *specific* question, show us what your understanding of how to solve that question is, and show us where you get stuck. "I'm trying to do X. Here's what I have so far." is not a question.
      singulars
      1. POpopulating a database from a file using c++
      1. USDavid Schwartz
    2. COspecifically, how can you read from a text file into a database using c++. How can one account for the spaces between the input values in the .txt file. Specifically, the SQL input statement would be for example, "insert into Employee values ('E0001', 'Assistant', 'Jospeh', 2000), ('E0002', 'Assistant', 'Thomas', 2012); but how could this be translated into insertion using c++.
      singulars
      1. POpopulating a database from a file using c++
      1. USuser2884789
    3. CODo you know how to read a line from a file? If not, don't need to do that first? If you do, why isn't that in your code? You've made it almost impossible for the people who want to help you to understand what you need help with.
      singulars
      1. POpopulating a database from a file using c++
      1. USDavid Schwartz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload