Advertisement
Guest User

Untitled

a guest
Aug 6th, 2024
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.83 KB | None | 0 0
  1. alex@alex-work-laptop:~/code/api$ sail images
  2. CONTAINER REPOSITORY TAG IMAGE ID SIZE
  3. api sail-8.2/app latest 7a75674aed43 1.75GB
  4. influxdb influxdb alpine 197b9f7cf87e 211MB
  5. mailpit axllent/mailpit latest f8d682b8e1f9 28.3MB
  6. mysql mysql/mysql-server 8.0 1d9c2219ff69 496MB
  7. redis redis alpine da7b3f96549f 41.2MB
  8. alex@alex-work-laptop:~/code/api$ docker ps
  9. CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
  10. 4f168e03f7a1 sail-8.2/app "/bin/bash -c '/usr/…" 7 hours ago Up 7 hours 8000/tcp, 0.0.0.0:8007->80/tcp, :::8007->80/tcp api
  11. fe4be62ccbc6 influxdb:alpine "/entrypoint.sh infl…" 7 hours ago Up 7 hours (unhealthy) 0.0.0.0:8086->8086/tcp, :::8086->8086/tcp influxdb
  12. 95a5bb23e21b redis:alpine "docker-entrypoint.s…" 7 hours ago Up 7 hours (healthy) 0.0.0.0:6379->6379/tcp, :::6379->6379/tcp redis
  13. b5928155b287 mysql/mysql-server:8.0 "/entrypoint.sh mysq…" 7 hours ago Up 7 hours (healthy) 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060-33061/tcp mysql
  14. 2ad9f6047b00 axllent/mailpit:latest "/mailpit" 7 hours ago Up 7 hours (healthy) 0.0.0.0:1025->1025/tcp, :::1025->1025/tcp, 0.0.0.0:8025->8025/tcp, :::8025->8025/tcp, 1110/tcp mailpit
  15. alex@alex-work-laptop:~/code/api$ sail mysql
  16. Reading table information for completion of table and column names
  17. You can turn off this feature to get a quicker startup with -A
  18.  
  19. Welcome to the MySQL monitor. Commands end with ; or \g.
  20. Your MySQL connection id is 1684
  21. Server version: 8.0.32 MySQL Community Server - GPL
  22.  
  23. Copyright (c) 2000, 2023, Oracle and/or its affiliates.
  24.  
  25. Oracle is a registered trademark of Oracle Corporation and/or its
  26. affiliates. Other names may be trademarks of their respective
  27. owners.
  28.  
  29. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  30.  
  31. mysql> update customers c inner join installations i on i.customer_id=c.id inner join assets a on a.installation_id=i.id set c.source_id="TEST-SOURCE-ID" where a.serial_no="TEST123" limit 1;
  32. Query OK, 0 rows affected (0.00 sec)
  33. Rows matched: 0 Changed: 0 Warnings: 0
  34.  
  35. mysql> select version();
  36. +-----------+
  37. | version() |
  38. +-----------+
  39. | 8.0.32 |
  40. +-----------+
  41. 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement