Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
J
J
Jackson7502018-09-30 11:16:58
MySQL
Jackson750, 2018-09-30 11:16:58

How to display a person who is listed in several tables and records from the database?

Tables
Books (id, name, published, genre, rating)
Authors (id, name, gender, born)
how to display an author who has written several books?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
D
Dimonchik, 2018-09-30
@dimonchik2013 

SELECT RAND() from Authors where authors.id = RAND(MAX(authors.id))

Similar questions
R
Rooly2021-03-23 11:40:40
How to properly organize apiResource Laravel? 2Reply
A
Anton2021-03-27 12:39:53
Getting the selected radio item and passing it to the email body, how to display the selected item? 2Reply
N
nerwind932021-04-07 15:31:56
How to substitute copied text in js? 3Reply
R
Roma Kotolup2021-04-28 13:25:11
How to remove shortcut in windows? 4Reply
#
#FFFFFF2019-11-19 14:39:34
What is better to use for e2e testing Vue? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question