Chub74
commented
3 years ago 2.1 INSERT INTO user (Vorname, Nachname, E-Mail, Keymember, Benutzername, Password, iButtonID) VALUES ();
2.3 SELECT UserID, Vorname, Nachname, iButtonID FROM user WHERE Keymember='0'
2.5 UPDATE zuweisung SET MaschinenID='pl4sbs' WHERE iButtonID='A4D2E21900EAA100' UPDATE zuweisung SET MaschinenID='pl4sbs' WHERE (SELECT Benutzername, iButtonID from user, zuweisung WHERE zuweisung.iButtonID=user.iButtonID AND user.Benutzername='zdan')
DELETE FROM zuweisung WHERE iButtonID='A4D2E21900EAA100'
DELETE FROM zuweisung WHERE (SELECT Benutzername, iButtonID from user, zuweisung WHERE zuweisung.iButtonID=user.iButtonID AND user.Benutzername='zdan')2.7 SELECT count(zuweisung.iButtonID) as Wert, user.Benutzername, zuweisung.MaschinenID FROM zuweisung, user WHERE (SELECT count(zuweisung.iButtonID) from zuweisung) > 1 AND user.iButtonID=zuweisung.iButtonID GROUP BY zuweisung.iButtonID
2.8 SELECT count(zuweisung.iButtonID) as Wert, Vorname, Nachname from zuweisung, user WHERE user.iButtonID=zuweisung.iButtonID GROUP BY zuweisung.iButtonID ORDER BY Wert desc LIMIT 1
2.2 update user set nachname="Zdanowicz" where nachname="Zdanowitsch"
2.4 select userid, vorname, nachname, user.iButtonID, Bezeichnung from maschine, user, zuweisung where user.iButtonID=zuweisung.iButtonID AND zuweisung.MaschinenID=maschine.MaschinenID order BY nachname;
2.6 select * from log where Starttime like "%-02-%";