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 '-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