Reply to thread

Message: <blockquote data-quote="Ayeshlive" data-source="post: 19425021" data-attributes="member: 363439">Oka normalize karoth me wage table ekak one wenne:book_author: book_id (int) author_id (int). Indexes: (book_id, author_id) PRIMARY, book_id, author_idMe fields dekama item (book) table ekatai author table ekatai foreign keys daganna.book: book_id (int, serial primary). name (varchar 255)Indexes: nameauthor:  author_id (int serial primary) name (varchar 255). Indexes: name. Dan eka book ekaka authors la ganna one nam: - [CODE]SELECT a.name, a.author_id FROM book_author ba INNER JOIN author a ON ba.author_id = a.author _id WHERE ba.book_id = :book_id[/CODE]<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":-)" title="Smile    :-)" loading="lazy" data-shortname=":-)" />book_id placeholder replace karanna book ID eken). Books by given author ID: - [code]SELECT b.name, b.book_id FROM book b INNER JOIN book_author ba ON b.author_id = ba.author_id WHERE ba.author_id = :author_id[/code]Me queries deken list ekak ganna puluwan (language eka anuwa wenas wenawa). Dan use karala language eken implode karaganna. Database engine eken concat karana baha wenas rows nisa. Ehema karanna puluwan wunath (columns walata wen karala) eka amu gon wadak.</blockquote>

Top Bottom