Well, if this is zdnets's MySQL tutor, I would suggest you find another
one, or get
the book "MySQL" by Paul DuBois ( New Riders ).
This command will not work, even if you are in the MySQL monitor.
You can start right now by reading the manual that comes with the MySQL
Once you have read the instructions and examples, you will be better
post questions here.
To answer your question; you need to be in the monitor.
I don't run windows, but it should be something like cmysql.exe or
Ben Butler wrote:
> Dear sir/madam,
> I am new to MySQL and downloaded it last night. I now have it running on my Windows
> 2000 Server but have a rather large problem. This may sound stupid but everywhere in the
> manual etc there are commands for me to enter, eq I an learning from zdnet.com how to use
> MySQL and it has told be to use the following statemt to create a table:
> CREATE TABLE TipsTable (tipID INT IDENTITY,
> subDate DATETIME DEFAULT GETDATE(),
> author VARCHAR(50), journal VARCHAR(3),
> title VARCHAR(255), tip TEXT)
> but the problem is I dont know where to type this statement. There are also other
> commands in the manual but I just dont know
> where to enter them.
> PLEASE HELP ME
> Ben Butler
|• Re: Commands||Ben Butler||8 Apr|
| • Re: Commands||Gerald Clark||9 Apr|