>> 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... >> > >Try doing 'desc spamdata' > >There is no table named id; hence the error. > >Regards, > >Jim Grill
In addition, when creating a table, we always have the same message when the creation successfull. "Query OK, 0 rows affected..." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]