DESC spamdata id;
DESCRIBE syntax is documented in the manual <http://dev.mysql.com/doc/mysql/en/DESCRIBE.html>.
Michael
Beauford wrote:
Duh.....That's what I get for doing this stuff late at night. Funning how some things just don't click in until someone kicks you in the butt....
Thanks
-----Original Message-----
From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: September 16, 2004 8:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem with tables;
You need to do desc spamdata; NOT desc id.
Aman Raheja
Beauford wrote:
Hi,
I'm trying to create a table using the commands below, and everything seems to work and the table is there - I just can's access any of the fields. This happens on both my Windows and Linux versions of MySQL. Any help is appreciated. Note, I have 8 other databases that I created with no problem about 2 months ago (on both platforms) - this is the first time I have tried since then. Any help is appreciated....
Thanks
I am in the proper database when I run the commands below...
CREATE TABLE spamdata ( id bigint(20) NOT NULL, dates varchar(60) NOT NULL, probe varchar(100) NOT NULL, ip varchar(15) NOT NULL, fqdn varchar(100) NOT NULL, reason varchar(100) NOT NULL, port varchar(2) NOT NULL, code varchar(10) NOT NULL, PRIMARY KEY (idm));
Query OK, 0 rows affected (0.08 sec) *** This tells me nothing happened...
When I run 'desc id' (or any of the others) I get the following:
mysql> desc id; ERROR 1146: Table 'spamtool.id' doesn't exist
This shows the table is there though.....
mysql> show tables; +--------------------+ | Tables_in_spamtool | +--------------------+ | spamdata | +--------------------+ 1 rows in set (0.00 sec)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
