Mysql newbie question

I have 3 tables
TABLE #1 "users"
3 columns
User-ID int (11)
Location varchar (250)
Age int (11)
Primary-key (User-ID)

TABLE #2 "books"
5 columns
ISBN varchar (13)
Book-title varchar(255)
Book-author varchar (255)
Year-of-publication int(10)
Publisher varchar (255)

TABLE #3 "Book-raitings"
3 columns
User-ID int (11)
ISBN varchar (13)
Book-rating int (11)


Primary-key (user-id, ISBN)

The Location column varchar will be of format "city, state, country)

I have to generate top 10 books per...

Mysql newbie question

from Databases http://ift.tt/1RfyRQQ
via IFTTT

Share :

Tweet

✚

Related Post

• Selecting Current Date Datahi, im not sure if this is a simple question but it makes me wonder. i have a field on my database
• Merge Various XML FilesI am looking for a program to use that will allow me to easily merge various XML files. from Datab
• Is there a way to extract all queries from this database?www . daccaa . org/meetings.htm They make it insanely difficult to find meetings, you have to know
• Adding Text to a TextArea from a variable PHP<form method="POST"> <label for="Players"> Players Team One: </label> <?php
• Unable to start PhpMyAdmin via XAMPPI'm in the midst of creating a social network and I'm at the key, most crucial, part of it all. A d
• 2016 Updated RU webmasters and affiliates 60 000 Email/skype DatabaseAt the database: 60,000 email + skype Database update: 11 April 2016 Source: Large Russian affiliat