Path: news.netfront.net!news.unit0.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Peter H. Coffin" Newsgroups: comp.databases.mysql Subject: Re: Complicated query Date: Fri, 12 Dec 2014 11:04:44 -0600 Lines: 37 Message-ID: References: <1vfpx8req13ag.a3n36ahpsxl3.dlg@40tude.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: individual.net PYXeE9OHNVScON10sowg8QikkRB1Oj4jW1rxbgiRYJcXtjWQ8P X-Orig-Path: nibelheim.ninehells.com!not-for-mail Cancel-Lock: sha1:0yY7cCTbtGhzFiWfTCDKZ/2xerQ= User-Agent: slrn/0.9.9p1 (OpenBSD) Xref: news.netfront.net comp.databases.mysql:2297 On Fri, 12 Dec 2014 11:26:18 -0500, Shelly wrote: > On 12/12/2014 10:11 AM, Jerry Stuckle wrote: >> They are different answers to the question in that row. Each ROW has a >> different question - not each COLUMN. You don't have 18 columns - one >> for each question. You have 18 rows. Each row has the question and >> five possible answers. > > ...and you don't know what you are talking about. There is ONE row for > each instance and 18 columns, ONE column for ONE answer to each of the > 18 DIFFERENT questions for THAT instance --- in the design that the > person (philosopher??) suggested as a single table, NOT the actual > design that I was working with. > > So much like you, that you insist that you are right even when you are > clearly wrong -- and have been corrected, what, four times now. Here is the DDL richard posted that you said you'd use. ----------- Columns would be ID Question Achoice Bchoice Cchoice Dchoice Correct ----------- One question, four answers, which one's correct. You are misremembering what you agreed to or you're misrepresenting it. Either way, Jerry's assessment of what richard posted is true. -- 4. Shooting is not too good for my enemies. --Peter Anspach's list of things to do as an Evil Overlord