Problem mit date-feld,left outer join und is null

[Jochen Metzger]

Hallo Sabine,
jepp, sorry, hier noch einmal komplett...
> der Aufbau von st_log_page_impressions fehlt!
>
> Sabine
> > Also:
> > Folgendes SQL soll durchgeführt werden (index als beispiel)
> > (* nur zum testen)
> > select * from st_log_pagenames left outer join st_log_page_impressions
on
> > st_log_pagenames.id=st_log_page_impressions.st_log_pagenames_id where
> > st_log_page_impressions.date IS NULL and st_log_pagenames.name='index';
> ---
#
# Tabellenstruktur für Tabelle `st_log_page_impressions`
#

CREATE TABLE st_log_page_impressions (
  id int(9) NOT NULL auto_increment,
  st_log_pagenames_id int(9) NOT NULL default '0',
  pi_total int(9) NOT NULL default '0',
  date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Struktur#
CREATE TABLE st_log_pagenames (
  id int(5) NOT NULL auto_increment,
  name varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Daten für Tabelle `st_log_pagenames`
#

INSERT INTO st_log_pagenames VALUES (1, 'index');
INSERT INTO st_log_pagenames VALUES (2, 'schnellsuche');
INSERT INTO st_log_pagenames VALUES (3, 'shop');
INSERT INTO st_log_pagenames VALUES (4, 'chain');
INSERT INTO st_log_pagenames VALUES (5, 'einkaufscenter');
INSERT INTO st_log_pagenames VALUES (6, 'archiv');
INSERT INTO st_log_pagenames VALUES (7, 'shopsuche');
INSERT INTO st_log_pagenames VALUES (8, 'handel');
INSERT INTO st_log_pagenames VALUES (9, 'newsletter');
INSERT INTO st_log_pagenames VALUES (10, 'ekzsuche');
INSERT INTO st_log_pagenames VALUES (11, 'offen');
INSERT INTO st_log_pagenames VALUES (12, 'profi');
INSERT INTO st_log_pagenames VALUES (13, 'shopliste');
INSERT INTO st_log_pagenames VALUES (14, 'ausgabe_generic');
INSERT INTO st_log_pagenames VALUES (15, 'infoseite');
INSERT INTO st_log_pagenames VALUES (16, 'linkliste');
INSERT INTO st_log_pagenames VALUES (17, 'feedbackmail');
INSERT INTO st_log_pagenames VALUES (18, 'partner');
INSERT INTO st_log_pagenames VALUES (19, 'silvester');
INSERT INTO st_log_pagenames VALUES (20, 'eurorechner');
INSERT INTO st_log_pagenames VALUES (21, 'service');
INSERT INTO st_log_pagenames VALUES (22, 'category');


Grüße

Jochen


---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql