Tabel aanmaken (MySQL)

Voorbeeld Mmysqldump

CREATE TABLE IF NOT EXISTS `tbl_ContentSjabloon` (
  `productnaam` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `referentie` varchar(18) CHARACTER SET utf8 DEFAULT NULL,
  `ean` varchar(13) CHARACTER SET utf8 DEFAULT NULL,
  `producttype` varchar(255) DEFAULT NULL,
  `beschrijving` text CHARACTER SET utf8,
  `afbeelding` varchar(55) CHARACTER SET utf8 DEFAULT NULL,
  `merk` varchar(255) DEFAULT NULL,
  `gewicht` varchar(7) CHARACTER SET utf8 DEFAULT NULL,
  `gewichteenheid` varchar(15) DEFAULT NULL,
  `mpn` varchar(11) CHARACTER SET utf8 DEFAULT NULL,
  `aantalstuks` varchar(29) CHARACTER SET utf8 DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Met primary key

create table tbl_main_tool(
	pk varchar(100) character set utf8 not null primary key,
	merk varchar(100)  character set utf8 default null,
	apparaat_type varchar(100) character set utf8 default null,
	apparaat_versie varchar(100) character set utf8 default null,
	soort varchar(100) character set utf8 default null
	-- constraint pk primary key (merk,apparaat_type,apparaat_versie) -- Zou dit handig zijn geweest?
);

Bronnen

• http://dev.mysql.com/doc/refman/5.1/en/create-table.html