Apr 25, 2001, 5:58 PM
Post #3 of 4
no, this is not the entire script
and i found the the error at $table_data->execute || die $dbh->errstr with error checking, and the following is $sql_query
the error message is "Incorrect table definition; There can only be one auto column and it must be defined as a key", but i don't know how to fix it
CREATE TABLE phone_book (
id INT NOT NULL AUTO_INCREMENT,
first_name CHAR(20) NOT NULL,
can you please took a look at this and tell me what is wrong with the above?
thanks so much..