query with NULL
am 08.07.2004 00:22:18 von npe-fast-it-net------=_NextPart_000_0003_01C46481.A1840880
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
OS: Windows XP German
=20
"Willkommen bei phpMyAdmin 2.5.6
=20
Verbunden mit MySQL 4.0.18-nt-log auf localhost als root@localhost"
=20
Following query won't be correctly executed, if table alias acf has not =
NULL
(=3D admin_access_special) in the first found row. Unfortunately, all =
rows of
admins' group are deleted in that case even not contenting =
NULL-condition.
If I did not anything wrong, then in my intention all rows of selected
conditions in tables should be deleted. A bug?
=20
German: Folgenden Abfrage wird nicht richtig ausgeführt, wenn die =
Tabelle
mit dem Alias acf keine erste Zeile mit NULL ( =3D
admin_access_special)findet. Leider werden in diesem Fall alle Zeilen =
der
Admingruppe gelöscht auch wenn die NULL-Bedingung nicht erfüllt ist. =
Falls
ich keine Fehler begang, sollten nur Zeilen in beiden Tabellen =
gelöscht
werden, die diesen Bedingungen entsprechen. Ein Bug?
=20
=20
DELETE FROM admin_access_files,
admin USING admin_access_files acf,
admin a WHERE a.admin_id =3D acf.admin_id AND a.admin_groups_id =3D5 AND
acf.admin_access_special IS NULL;
=20
Datenbank vatansesi - Tabelle admin auf localhost
=20
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Erstellungszeit: 07. Juli 2004 um 23:51
# Server Version: 4.0.18
# PHP-Version: 4.3.6
#=20
# Datenbank: `vatansesi`
#=20
=20
# --------------------------------------------------------
=20
#
# Tabellenstruktur für Tabelle `admin`
#
=20
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL auto_increment,
`admin_groups_id` int(11) default NULL,
`admin_firstname` varchar(32) NOT NULL default '',
`admin_lastname` varchar(32) default NULL,
`admin_email_address` varchar(96) NOT NULL default '',
`admin_email_notification_level` tinyint(4) NOT NULL default '0',
`admin_password` varchar(40) NOT NULL default '',
`admin_created` datetime default NULL,
`admin_access_status` tinyint(4) NOT NULL default '1',
`admin_scheduled` datetime default NULL,
`admin_access_until` datetime default NULL,
`admin_modified` datetime default NULL,
`admin_logdate` datetime default NULL,
`admin_lognum` int(11) NOT NULL default '0',
PRIMARY KEY (`admin_id`),
UNIQUE KEY `admin_email_address` (`admin_email_address`),
KEY `admin_stop_email_notification` =
(`admin_email_notification_level`),
KEY `admin_access_until` (`admin_access_until`),
KEY `admin_access_status` (`admin_access_status`),
KEY `admin_sheduled` (`admin_scheduled`)
) TYPE=3DMyISAM AUTO_INCREMENT=3D38 ;
=20
#
# Daten für Tabelle `admin`
#
=20
INSERT INTO `admin` ( `admin_id` , `admin_groups_id` ,
`admin_firstname` , `admin_lastname` , `admin_email_address` ,
`admin_email_notification_level` , `admin_password` , `admin_created` =
,
`admin_access_status` , `admin_scheduled` , `admin_access_until` ,
`admin_modified` , `admin_logdate` , `admin_lognum` )=20
VALUES ( 1, 1, 'N.....', 'E....t', 'admin@ffffft.net', 5,
'7497194c8bed6:d4', '2004-06-14 14:07:00', 1, NULL , '0000-00-00
00:00:00', '0000-00-00 00:00:00', '2004-07-07 11:31:17', 163 ) , ( 3, =
5,
'Ht', 'E...', 'hat@e.de', 1, '064df98b185ff:ed', '2004-06-14 =
19:13:02',
1, NULL , '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL , 0 ) =
, (
4, 5, 'Ht', 'E.dfdfdf..', 'hafft@e.de', 1, '064df98b185ff:ed',
'2004-06-14 19:13:02', 1, NULL , '0000-00-00 00:00:00', '0000-00-00
00:00:00', NULL , 0 );
=20
=20
=20
=20
=20
# --------------------------------------------------------
=20
#
# Tabellenstruktur für Tabelle `admin_access_files`
#
=20
DROP TABLE IF EXISTS `admin_access_files`;
CREATE TABLE `admin_access_files` (
`file_access_id` int(4) NOT NULL auto_increment,
`admin_files_id` int(11) NOT NULL default '0',
`admin_id` int(11) NOT NULL default '1',
`admin_access_values` int(11) NOT NULL default '1',
`admin_access_special` int(1) default NULL,
PRIMARY KEY (`file_access_id`),
UNIQUE KEY `file_access_id` (`file_access_id`),
KEY `admin_access_special` (`admin_access_special`)
) TYPE=3DMyISAM AUTO_INCREMENT=3D393 ;
=20
#
# Daten für Tabelle `admin_access_files`
#
=20
INSERT INTO `admin_access_files` (`file_access_id`, `admin_files_id`,
`admin_id`, `admin_access_values`, `admin_access_special`) VALUES (4, 6, =
1,
2, 1),
(5, 5, 1, 2, NULL),
(6, 4, 1, 2, 1),
(7, 7, 1, 2, NULL),
(8, 8, 1, 2, 1),
(9, 9, 3, 2, 1),
(10, 10, 3, 2, NULL),
(11, 11, 1, 2, 1),
(12, 12, 5, 2, 1),
(13, 13, 6, 2, NULL),
(14, 14, 1, 2, NULL),
(15, 15, 1, 2, 1);
------=_NextPart_000_0003_01C46481.A1840880--