Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2016
    Posts
    1

    Post Unanswered: Need help with very simple MySQL queries and applying foreign keys to single table

    Hi, so I'm interested in making a recommender system and after detailed scanning and scraping I came across this project (which instantly caught my interest):

    https://www.google.co.in/url?sa=t&rc...rMF8-hWsf_p9fw

    In here, if you jump straight to the end towards integrating 3 data tables(movies,user and reviews)

    [I have these tables in .csv format if anyone wishes to implement and test]

    I'm getting an error while executing the MySQL query #1 given on pg #52 of the report.

    I'm new here so didnt know which forum to put this question into, also since I'm new to MySQL if someone is genuinely interested with helping me out can reach me directly at mrinmay93@gmail.com too.

    Any and every form of help is truly appreciated!
    Thanks and hope you have a good day!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the query is?
    the table design is?
    the error message is?
    the sample data is?
    the desired results are?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2016
    Posts
    1

    On the Internet

    Search for "CSV to SQL" and then you can find this link
    When the file is too large to input you can change the ini files.
    If you use XAMPP you can change the "upload_max_filesize" to 8M for example in the php.ini file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •