help po mga master, urgent lang po

• cthulhuman on November 07, 2009 08:22 PM

  may problem po ako sa mysql... may naka experience na po ba sa inyo na hindi gumagana yung AUTO_INCREMENT and yung PRIMARY KEY... medyo nasabaw nako kakaisip eh... everytime mag insert ako ng data sa table laging naka index to #1 yung AUTO_INCREMENT... then kahit pareho yung data na insert ko dun sa PRIMARY KEY, nag iinsert parin... :(
  
  eto yung code ko sa pag create nung table
  
  CREATE TABLE `uta_products` (
  `pro_id` INT NOT NULL auto_increment,
  `pro_type` VARCHAR(120) NOT NULL,
  `pro_title` VARCHAR(200) NOT NULL,
  `pro_description` TEXT NULL DEFAULT NULL,
  `pro_priority` TINYINT NOT NULL DEFAULT 0,
  `pro_rank` INT NOT NULL DEFAULT 0,
  `pro_urlcode` VARCHAR(250) NOT NULL,
  `pro_origin` VARCHAR(200) NULL,
  `pro_maker` VARCHAR(200) NULL DEFAULT NULL,
  `pro_subtype` VARCHAR(200) NULL DEFAULT NULL,
  `pro_classification` VARCHAR(200) NULL DEFAULT NULL,
  `pro_vintage` VARCHAR(200) NULL DEFAULT NULL,
  `pro_regular_price` FLOAT(11,2) NOT NULL,
  `pro_discount_price` FLOAT(11,2) NULL,
  `pro_discount_active` BOOLEAN DEFAULT FALSE,
  `pro_active` BOOLEAN NOT NULL DEFAULT TRUE,
  `pro_photo` VARCHAR(120) NULL default NULL,
  `pro_cdate` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `pro_mdate` TIMESTAMP NULL,
  `pro_size` VARCHAR(30) NULL default NULL,
  `pro_feature` BOOLEAN DEFAULT FALSE,
  `pro_code` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`pro_code`, `pro_id`)
  );
  
  patulong naman po oh medyo masakit na sa ulo eh di ko alam kung bakit yung index nung auto_increment eh lagi nasa 1 :(

• unreal_warrior on November 08, 2009 01:45 PM

  initiate mo yung table without the quote marks, di yun required, kahit yung NOT NULL sa primary keys mo, tanggalin mo na rin kasi kung mag iinsert ka, kahit NULL ilagay, dapat automatic na lalagyan nito ng correct integer
  
  CREATE TABLE uta_products(
  pro_id INT AUTO_INCREMENT,
  ...
  ...
  ...
  pro_code VARCHAR(20),
  PRIMARY KEY (pro_id, pro_code));
  
  INSERT uta_products VALUES(NULL, .........., your_value_here);

• aeon91 on November 08, 2009 01:48 PM

  Nose bleed..

646 active users within the last 5 minutes, 400 members, 246 guests.
Our newest member is erra18
Click here to see online members.