I want to create a User Table.

[subkida]

CREATE DATABASE mydatabase;
USE mydatabase;

CREATE TABLE users {
userId SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
userName VARCHAR(30) NOT NULL,
userPass VARCHAR(32) NOT NULL,
PRIMARY KEY (userId),
UNIQUE KEY username (username)
}

Where do I enter this in MySQL to create the table? I can't find it anywhere!

[TTVN]

If you're using phpMyAdmin 2, go to table users and click on SQL then you'll see a text-area that's where u type in the commands.

[subkida]

Where can I get PHPMyAdmin?

I'm not using anything currently. I thought you had to do it through MySQL.

Thanks.

[joon]

I guess Next is the official site for phpMyAdmin.

http://www.phpmyadmin.net/