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
