Re: This is confusing..?

2003-11-06 Thread Matt W
hursday, November 06, 2003 1:45 PM Subject: RE: This is confusing..? > > Can you send show keys from campaign_t. > > I bet you can solve your problem by runn

RE: This is confusing..?

2003-11-06 Thread Eric Anderson
> Can you send show keys from campaign_t. > I bet you can solve your problem by running analyze table. mysql> show index from campaign_t\g +++---+--+-+---+-+--++-+ | Table | Non_unique | Key_na

Re: This is confusing..?

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 11:08:03AM -0800, Eric Anderson wrote: > > Given the following table: > > CREATE TABLE campaign_t ( > acct_id int(11) unsigned NOT NULL default '0', > site_id tinyint(3) unsigned NOT NULL default '0', > ref_id int(11) unsigned NOT NULL default '0', > datestamp char

Re: This is confusing..?

2003-11-06 Thread Eric Anderson
> Possibly because datestamp and 20041105 have different datatypes. > There's an implicit data conversion required for the comparison, which > in some cases prevents use of an index. Try writing '20041105' rather > than 20041105 and see if that makes a difference. Nope.. :-/ mysql> explain SELECT

Re: This is confusing..?

2003-11-06 Thread Eric Jain
> mysql> explain SELECT * FROM campaign_t WHERE datestamp < 20041105\g Try surrounding the value with quotes, i.e.: explain SELECT * FROM campaign_t WHERE datestamp < '20041105' -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

RE: This is confusing..?

2003-11-06 Thread Eric Anderson
> Can you send show keys from campaign_t. > I bet you can solve your problem by running analyze table. What's the syntax for 'show keys'? -- -- Eric Anderson - ICQ: 3849549 - San Diego, CA [EMAIL PROTECTED] | Mac and Bumbl

Re: This is confusing..?

2003-11-06 Thread Paul DuBois
At 11:08 -0800 11/6/03, Eric Anderson wrote: Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws in

RE: This is confusing..?

2003-11-06 Thread Dathan Vance Pattishall
[EMAIL PROTECTED] -->Sent: Thursday, November 06, 2003 11:08 AM -->To: [EMAIL PROTECTED] -->Subject: This is confusing..? --> --> -->Given the following table: --> -->CREATE TABLE campaign_t ( --> acct_id int(11) unsigned NOT NULL default '0', --> site_id tinyint(3)

RE: This is confusing..?

2003-11-06 Thread Dan Greene
vember 06, 2003 2:08 PM > To: [EMAIL PROTECTED] > Subject: This is confusing..? > > > > Given the following table: > > CREATE TABLE campaign_t ( > acct_id int(11) unsigned NOT NULL default '0', > site_id tinyint(3) unsigned NOT NULL default &#x

This is confusing..?

2003-11-06 Thread Eric Anderson
Given the following table: CREATE TABLE campaign_t ( acct_id int(11) unsigned NOT NULL default '0', site_id tinyint(3) unsigned NOT NULL default '0', ref_id int(11) unsigned NOT NULL default '0', datestamp char(10) NOT NULL default '', raws int(11) unsigned NOT NULL default '0', uniqu