That's correct. You successfully created the table (you didn't get an error message did you?) and neither wrote any records to nor changed any records on the new table: "Query OK, 0 rows affected ..."
This format is more useful when you use the compound form of "CREATE TABLE" that allows you to populate it as you create it. (read: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html) CREATE TABLE tmpTest SELECT * From spamdata; Assuming you have the correct rights and that there are 876 rows of data in spamdata, you should see: "Query OK, 876 rows affected..." Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] wrote on 09/16/2004 06:11:47 AM: > > >> 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] >