My DB Is skipping a few entries

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Do a

Code: Select all

SHOW CREATE TABLE `tablename`;
on your table and post back the output.
User avatar
legend986
Forum Contributor
Posts: 258
Joined: Sun Jul 15, 2007 2:45 pm

Post by legend986 »

Sure... Here's the output:

Code: Select all

CREATE TABLE `tep_roboveda` (
  `team_id` mediumint(9) NOT NULL auto_increment,
  `team_name` varchar(150) NOT NULL default '',
  `events` varchar(150) NOT NULL default '',
  `team_leader_name` varchar(50) NOT NULL default '',
  `member_id` mediumint(9) NOT NULL default '0',
  `team_leader_email` varchar(50) NOT NULL default '',
  `team_leader_number` varchar(20) NOT NULL default '',
  `college` varchar(150) NOT NULL default '',
  `bryr` varchar(20) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `state` varchar(20) NOT NULL default '',
  `member_1` varchar(50) NOT NULL default '',
  `email_1` varchar(50) NOT NULL default '',
  `member_id_1` mediumint(9) NOT NULL default '0',
  `member_2` varchar(50) NOT NULL default '',
  `email_2` varchar(50) NOT NULL default '',
  `member_id_2` mediumint(9) NOT NULL default '0',
  `member_3` varchar(50) NOT NULL default '',
  `email_3` varchar(50) NOT NULL default '',
  `member_id_3` mediumint(9) NOT NULL default '0',
  `member_4` varchar(50) NOT NULL default '',
  `email_4` varchar(50) NOT NULL default '',
  `member_id_4` mediumint(9) NOT NULL default '0',
  `comments` text NOT NULL,
  `col_1` varchar(80) NOT NULL default '',
  `col_2` varchar(80) NOT NULL default '',
  `col_3` varchar(80) NOT NULL default '',
  `col_4` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`team_id`),
  UNIQUE KEY `team_leader_name` (`team_leader_name`)
) ENGINE=MyISAM AUTO_INCREMENT=414 DEFAULT CHARSET=latin1
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

legend986 wrote:But Team Name is a unique field...
According to your table definition team_leader_name is unique, but team_name is not.
User avatar
legend986
Forum Contributor
Posts: 258
Joined: Sun Jul 15, 2007 2:45 pm

Post by legend986 »

Oh then I'm sorry... I must've overlooked that thing. In that case, well, REPLACE shouldn't be giving me any problem at all in the first place isn't it? I mean, somebody's name cannot be so name to the extent of initials and second name. And that too, I've lost so many entries. I mean, my logic was wrong I agree, but there has to be something else because I lost so many records and that is just random... Please correct me if I'm wrong.
Post Reply