hpvic03
Technical User
- Aug 2, 2006
- 89
Whenever I run this SQL I get the error: A table must have at least one column. What is wrong with it?
CREATE TABLE infoTable {
infoID Integer not null auto_increment,
urlprefix varchar(100),
name varchar(100),
fullurl varchar(100),
email varchar(100),
picdes Text,
direc Text,
dirlen varchar(100),
primary key (infoID)
}
Any help would be greatly appreciated!
CREATE TABLE infoTable {
infoID Integer not null auto_increment,
urlprefix varchar(100),
name varchar(100),
fullurl varchar(100),
email varchar(100),
picdes Text,
direc Text,
dirlen varchar(100),
primary key (infoID)
}
Any help would be greatly appreciated!