Jump to content

chickenyd

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

chickenyd's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. hi i am trying to create a database table for a shopping basket : CREATE TABLE `customers` ( `customerid` int(10) unsigned NOT NULL auto_increment, `customerusername` varchar(35) NOT NULL default '', `customerfname` varchar(35) NOT NULL default '', `customerlname` varchar(35) default NULL, `customeraddress1` varchar(60) NOT NULL default '', `customeraddress2` varchar(60) default NULL, `customercity` varchar(50) NOT NULL default '', `country` varchar(50) NOT NULL default '', `customerpostcode` varchar(30) NOT NULL default '', `customerphone` varchar(25) default NULL, `customeremail` varchar(40) NOT NULL default '', PRIMARY KEY (`customerid`) ) TYPE=InnoDB; CREATE TABLE `tblcart` ( `ct_id` int(10) unsigned NOT NULL auto_increment, `pd_id` int(10) unsigned NOT NULL default '0', `ct_qty` mediumint(8) unsigned NOT NULL default '1', `ct_session_id` char(32) NOT NULL default '', `ct_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ct_id`), KEY `pd_id` (`pd_id`), KEY `ct_session_id` (`ct_session_id`) ) TYPE=MyISAM AUTO_INCREMENT=58 ; my question are: 1. i dont understand this line: TYPE=MyISAM AUTO_INCREMENT=58 ; 2. wots the difference between MyISAM and InnoDB and which 1 is best to use.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.