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

• How to limit PHPMYADMIN access to specific databaseHi , Can someone please tell me how I can give limit access from phpMYADMIN to a specific database
• Relational AlgebraHi, I need some help with relational algebra. The schema for this database is as follows: (note th
• Combine data from two rows into oneWhen I do a query, I get the following results (see attached image). I would like the January rows
• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"
• Wordpress with Mys SQL - Can handled the user of 2.4 MHi I am really follow WordPress, when to start building the site. Cause it is easy and non technica
• Selling DumpsDumps and Cvv prices depends on country and card type. Please contact me for further details. I got