MySQL query returning with error "You have to choose at least one column to display"

CREATE TABLE users (
user_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
first_name VARCHAR(20) NOT NULL,
When I run the following query within PHPMyAdmin...


last_name VARCHAR(40) NOT NULL,
email VARCHAR(80) NOT NULL,
pass CHAR(40) NOT NULL,
user_level TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
active CHAR(32),
registration_date DATETIME NOT NULL,
PRIMARY KEY (user_id),
UNIQUE KEY (email),
INDEX login (email, pass)
);


I get the following error...

"You have to choose at least one column to display"

Any ideas why it's doing this?what do Ineed to change?
BrighteyesDesignAsked:
Who is Participating?
 
johanntagleCommented:
Can't replicate it.  See attached.
phpmyadmin.png
0
 
Dave BaldwinFixer of ProblemsCommented:
Your question doesn't look right.  Can you repost the query?
0
 
BrighteyesDesignAuthor Commented:
Apologies,I...erm.....entered the code into 'Query" rather than "SQL' : /

Your screenshot made me realise what I was doing wrong so you solved this in a round about way!

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.