Jump to content

chickenyd

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by chickenyd

  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.