Comments - Getting Data from MariaDB
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
"We've thinned out the ongoing SQL statement a bit for clarity. This statement will result in only one row displayed for Crime & Punishment and it will be the first one found." No, it doesn't. You have to delete the isbn from the query in order to show "Crime and Punishment" only once.
How do I populate a db with all these data (different books, etc.)? You could have provided it...
Typo on SELECT FOUND_ROW(); ->> should be FOUND_ROWS() Same with the link to the function.
Thanks, fixed!
"author_last" is wrong string. In statement ... WHERE author_last LIKE 'Dostoevsk\%' ... Dos't need use '\' before '%' wildcard.
DISTINCT dosn't work with SELECT statement.
May be something change in standards?
Good day. Thank you very much for the tutorial, it is very friendly and easy to understand. I would like to know which is the article where "Fyodor Dostoevsky" is inserted into the "authors" table. Thank you very much! Regards!