phpBB.nl

Code: Selecteer alles

-- 
-- Tabel structuur voor tabel `computer_kb_categories`
-- 

CREATE TABLE `computer_kb_categories` (
  `category_id` mediumint(8) unsigned NOT NULL auto_increment,
  `category_name` varchar(255) binary NOT NULL default '',
  `category_details` varchar(255) binary NOT NULL default '',
  `number_articles` mediumint(8) unsigned NOT NULL default '0',
  `parent` mediumint(8) unsigned default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  KEY `category_id` (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `computer_kb_categories`
-- 

INSERT INTO `computer_kb_categories` VALUES (4, 0x6f7672696765, 0x, 0, 0, 20);
INSERT INTO `computer_kb_categories` VALUES (3, 0x77696e646f7773, 0x, 1, 0, 10);
INSERT INTO `computer_kb_categories` VALUES (5, 0x696e7465726e65742f57656264657369676e, 0x, 0, 0, 30);

-- --------------------------------------------------------

Code: Selecteer alles

 SQL-query:

-- 
-- Gegevens worden uitgevoerd voor tabel `computer_kb_categories`
-- 
INSERT INTO `computer_kb_categories`
VALUES ( 4, 0x6f7672696765, 0x, 0, 0, 20 ) 

#1054 - Unknown column '0x' in 'field list' 

Code: Selecteer alles

INSERT INTO `computer_kb_categories` VALUES (4, 0x6f7672696765, '0x', 0, 0, 20);
INSERT INTO `computer_kb_categories` VALUES (3, 0x77696e646f7773, '0x', 1, 0, 10);
INSERT INTO `computer_kb_categories` VALUES (5, 0x696e7465726e65742f57656264657369676e, '0x', 0, 0, 30);

Code: Selecteer alles

INSERT INTO `computer_kb_categories` VALUES (4, 0x6f7672696765, 0x, 0, 0, 20);
INSERT INTO `computer_kb_categories` VALUES (3, 0x77696e646f7773, 0x, 1, 0, 10);
INSERT INTO `computer_kb_categories` VALUES (5, 0x696e7465726e65742f57656264657369676e, 0x, 0, 0, 30);