Hi, all, I recently posted this query and it doesn't seem to be getting any responses. Is there something important that I left unsaid, making this one tough to answer or is it, perhaps, not addressed to the right list?
I would like to redo my CREATE TABLE very much to allow me to do more efficient queries. Now it is pretty coumbersome but a guru told me that with a change in CREATE TABLE I could do more efficient queries of the sort I describe below. So please let me know if there is someplace else that I should be writing. Thanks, Gloria McMillan "Gloria L. McMillan" wrote: > Greetings and happy holidays! > > This is a query about how to better structure an existing mysql table. > > I want to make a rather complex SELECT off an opinion poll. > > Thus: > > SELECT Those who answered Q3 as "1" > SELECT these people's answers for Q4, Q5, Q6… > > (Any size array of the rest of the questions. This is to compare how > different demographic groups answer the other questions.) > > The CREATE TABLE as that works in MySQL but is cumbersome for the > query above: > > CREATE TABLE ADJ04survey ( > id int(10) unsigned DEFAULT '0' NOT NULL auto_increment, > added datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, > > The CREATE TABLE in SQL that won't compile at MyCC but can handle > a moe complex style of SELECT query: > > CREATE TABLE ADJsurvey ( > id int identity(1,1), > added datetime DEFAULT getdate() NOT NULL, > > The person who helped me doesn't know MySQL, only SQL and says > that his syntax may be off. > > Can somebody help? > > Thank you, > > Gloria Mcmillan > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php