• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Day 14

Listing D.20 shows the table structure for tblProduct.

Listing D.20. Table Definition of tblProduct

1 CREATE TABLE tblProduct (
2   prodID varchar(250) NOT NULL default '',
3   prodName varchar(250) default NULL,
4   prodDesc text,
5   prodPrice double default NULL,
6   prodThumbPic varchar(250) default NULL,
7   prodPic varchar(250) default NULL,
8   PRIMARY KEY  (prodID)
9 );
					


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint