Dropdown lists

I need to create a dropdown list in my script I am writing but don't know how to set it up in mysql. I have Mysql> create table tablename -> (now here is what I don¹t know what to put) state varchar(100); Do I use varchar for drop down lists? -

Thank you all.

Hello all, Just wanted to say thank you to all of your responces on how to import .sql file into a database. It helped me a lot. Mysql -u user -p password dbname < filename.sql Thanks, Josiah Wallingford Email = [EMAIL PROTECTED] Mailing lists: PHP General - [EMAIL PROTECTED] BBE

Importing .sql files into database.

I know how to inport a .sql file into mysql by using mysql -u username -p password < filename.mysql(sql) but how do you import one that is made to go into a database you already have created? Would the command by mysql -u username -p password < dbname filename.sql(mysql) Thanks,

Create User

What is the command prompt to create a user in mysql? Thank you, Josiah Wallingford - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To