in reply to Re: MySQL-pp, Perl and MySQL Triggers
in thread MySQL-pp, Perl and MySQL Triggers

Yes, Both have a field called ID, that is primary. Here is the Table creation code:
    $sql = "create table login (
	id MEDIUMINT NOT NULL AUTO_INCREMENT,
	created DATE,
        tec_id VARCHAR(15),
	type VARCHAR(50),
	password VARCHAR(100),
	stage_name VARCHAR(150),
	last_log DATE,
	last_time TIME,
        active VARCHAR(3),
        banned VARCHAR(3),
	PRIMARY KEY (id),
	INDEX (`tec_id` ASC),
	INDEX (`type` ASC),
	INDEX (`stage_name` ASC),
	INDEX (`last_log` ASC)
	) ENGINE=MyISAM;";

AND

    $sql = "create table user (
	id MEDIUMINT NOT NULL AUTO_INCREMENT,
	tec_id VARCHAR(15) NOT NULL UNIQUE,
        created DATE,
	agent_id VARCHAR(15),
	type VARCHAR(50),
	approved DATE,
	dob DATE,
	age_create VARCHAR(3),
	first_name VARCHAR(100),
	last_name VARCHAR(100),
	address_01 VARCHAR(150),
	address_02 VARCHAR(150),
	country VARCHAR(50),
	state VARCHAR(50),
	city VARCHAR(50),
	zip CHAR(12),
	referring_user VARCHAR(15),
        referring_code VARCHAR(100),
	terms_accept VARCHAR(3),
	terms_initials VARCHAR(5),
	terms_date DATE,
	rate VARCHAR(5),
	PRIMARY KEY (id),
	INDEX (`tec_id` ASC),
	INDEX (`city` ASC),
	INDEX (`type` ASC)
	) ENGINE=MyISAM;";
  • Comment on Re^2: MySQL-pp, Perl and MySQL Triggers