On Sep 23, 4:13 pm, "Luuk" <l...@invalid.lan> wrote:
> "JimJx" <webmas...@valleywebnet.com> schreef in berichtnews:1190576047.676633.152430@r29g2000hsg.g ooglegroups.com...
>
>
>
> >> What's your CREATE TABLE look like?
>
> >> --
> >> ==================
> >> Remove the "x" from my email address
> >> Jerry Stuckle
> >> JDS Computer Training Corp.
> >> jstuck...@attglobal.net
> >> ==================
>
> > CREATE TABLE valley (
> > `Category` VARCHAR(25) not null ,
> > `Name` VARCHAR(50) not null ,
> > `Description` TEXT ,
> > `Contact` VARCHAR(20) not null ,
> > `Phone` TEXT(10) not null ,
> > `Fax` TEXT(10) ,
> > `Address` VARCHAR(25) ,
> > `City` VARCHAR(25) ,
> > `State` VARCHAR(2) ,
> > `ZipCode` MEDIUMINT ,
> > `Email` VARCHAR(50) ,
> > `URL` VARCHAR(50) ,
> > `Keywords` VARCHAR(100),
> > 'ID' MEDIUMINT AUTOINCREMENT
> > }
>
> maybe a "show full columns from valley" give more related info....

Field Type Collation Null Key Default Extra Privileges
Comment
Category varchar(25) latin1_swedish_ci
select,insert,update,references
Name varchar(50) latin1_swedish_ci
select,insert,update,references
Description text latin1_swedish_ci YES NULL
select,insert,update,references
Contact varchar(20) latin1_swedish_ci
select,insert,update,references
Phone tinytext latin1_swedish_ci
select,insert,update,references
Fax tinytext latin1_swedish_ci YES NULL
select,insert,update,references
Address varchar(25) latin1_swedish_ci YES NULL
select,insert,update,references
City varchar(25) latin1_swedish_ci YES NULL
select,insert,update,references
State char(2) latin1_swedish_ci YES NULL
select,insert,update,references
ZipCode mediumint(9) NULL YES NULL
select,insert,update,references
Email varchar(50) latin1_swedish_ci YES NULL
select,insert,update,references
URL varchar(50) latin1_swedish_ci YES NULL
select,insert,update,references
Keywords varchar(100) latin1_swedish_ci YES NULL
select,insert,update,references
ID int(11) NULL PRI NULL auto_increment
select,insert,update,references