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]
