Cheat Sheet aktualisieren authored by Daniel Kazior's avatar Daniel Kazior
...@@ -2,3 +2,8 @@ ...@@ -2,3 +2,8 @@
```sql ```sql
UPDATE `customer_entity` SET `password_hash` = CONCAT(SHA2('xxxxxxxxPASSWORD', 256), ':xxxxxxxx:1') WHERE `email` = 'example@crefopay.de'; UPDATE `customer_entity` SET `password_hash` = CONCAT(SHA2('xxxxxxxxPASSWORD', 256), ':xxxxxxxx:1') WHERE `email` = 'example@crefopay.de';
``` ```
## Update incrementID (sequential order number) to a new value`
```sql
ALTER TABLE `sequence_invoice_1` AUTO_INCREMENT={$newValue};
```