| Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung |
| mysql [2024/11/13 16:31] – [Die Nachbestellnummern eines Auftrages wurden erstellt/reserviert, sollen aber wieder weg] gerald | mysql [2025/03/23 19:22] (aktuell) – [mySQL] gerald |
|---|
| [[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html|STRING-functions of mySQL]] | [[http://dev.mysql.com/doc/refman/5.0/en/string-functions.html|STRING-functions of mySQL]] |
| |
| | |
| | {{::sql.jpg?600|}} |
| ===== Interne Variable zum Sortieren von Listen ===== | ===== Interne Variable zum Sortieren von Listen ===== |
| |
| SELECT liste.id, liste.jobnumber, liste.class, liste.name, liste.order_number, liste.value_payed, liste.order_number FROM qf_classlist as liste INNER JOIN (SELECT jobnumber, class, name, order_number, value_payed FROM qf_classlist GROUP BY jobnumber, class, name, order_number HAVING COUNT(id) > 1) dup ON (liste.jobnumber = dup.jobnumber && liste.name = dup.name && liste.class = dup.class && liste.order_number = dup.order_number && liste.value_payed = dup.value_payed) WHERE liste.value_payed > 0 AND liste.order_number != '' ORDER by jobnumber, class, name | SELECT liste.id, liste.jobnumber, liste.class, liste.name, liste.order_number, liste.value_payed, liste.order_number FROM qf_classlist as liste INNER JOIN (SELECT jobnumber, class, name, order_number, value_payed FROM qf_classlist GROUP BY jobnumber, class, name, order_number HAVING COUNT(id) > 1) dup ON (liste.jobnumber = dup.jobnumber && liste.name = dup.name && liste.class = dup.class && liste.order_number = dup.order_number && liste.value_payed = dup.value_payed) WHERE liste.value_payed > 0 AND liste.order_number != '' ORDER by jobnumber, class, name |
| </code> | </code> |
| | |
| | |
| | ==== Fotokation: Ein Angebot (oder mehrere) an das Ende des Offerstrings anhängen ==== |
| | |
| | <code> |
| | UPDATE `fotoaction_pics` SET offer = CONCAT(offer, ',163') WHERE `valid_to` > '2025-11-20' AND offer NOT LIKE '%,163' LIMIT 25000 |
| | </code> |
| | |
| |
| ==== Alle Bestellnummern der Fotoaktion eines Auftrags (z.B. für Excel) ==== | ==== Alle Bestellnummern der Fotoaktion eines Auftrags (z.B. für Excel) ==== |
| <code>ALTER TABLE tabelle MODIFY spalte VARCHAR(255) COLLATE utf8_bin;</code> | <code>ALTER TABLE tabelle MODIFY spalte VARCHAR(255) COLLATE utf8_bin;</code> |
| |
| | ==== PHP: Einfach dt. Datum in SQL-Format umwandeln ==== |
| |
| | |
| | PHP: |
| | <code> |
| | $date_de = '24.03.2025'; |
| | $date_sql = DateTime::createFromFormat('d.m.Y', $date_de)->format('Y-m-d'); |
| | echo $date_sql; // Gibt "2025-03-24" aus |
| | |
| | </code> |
| |
