Sql help

[Anon]

Ok i have just started learning SQL, and i am stumped, I have created my database, now i want to add tables, for this i have created a .sql with the relevent sql commands and table structure

Create table news
( newsid int unsigned not null auto_increment primary key,
newsitem text,
poster char(50),
poster_e-mailchar(50),
poster_image char(50),
poster_date date
);

I have powered up mysql to its command prompt, how can i get the table into the database, were does this .sql have to be in order to use say

mysql> source mydb.sql

I am using IIS/ Windows2000

Please help
-ali

[bastien]

if you are jus tin the db design stage, go get phpmyadmin, it is a great tool for helping you admin the db...

Bastien

[mikesgt2]

If you mean how do you run the sql file from the command prompt then you do this:

mysql> . filename here

Or am I getting the wrong end of the stick?