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

• MySQL CONCAT, HAVING and JOINhi can this be use all together? here is my query: SELECT CONCAT(fullname," ",address1," ",city,"
• Error While Connect MySQL DAtabaseHi guys i want to ask you about connect mysql database from different hosting servers using php. an
• What are pros and cons of PostgreSQL and MySQL?What are pros and cons of PostgreSQL and MySQL? from Databases http://ift.tt/1Uw02wx via IFTTT
• 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
• Insert data from table1 to table2 depending on user_id and record_idSo I need to insert some records from table1 to table2 depending on their user_id (PVKEY) and recor
• 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