MySQL query returning with error "You have to choose at least one column to display"
Posted on 2011-09-14
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,
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?