Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alex@alex-work-laptop:~/code/api$ sail images
- CONTAINER REPOSITORY TAG IMAGE ID SIZE
- api sail-8.2/app latest 7a75674aed43 1.75GB
- influxdb influxdb alpine 197b9f7cf87e 211MB
- mailpit axllent/mailpit latest f8d682b8e1f9 28.3MB
- mysql mysql/mysql-server 8.0 1d9c2219ff69 496MB
- redis redis alpine da7b3f96549f 41.2MB
- alex@alex-work-laptop:~/code/api$ docker ps
- CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
- 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
- fe4be62ccbc6 influxdb:alpine "/entrypoint.sh infl…" 7 hours ago Up 7 hours (unhealthy) 0.0.0.0:8086->8086/tcp, :::8086->8086/tcp influxdb
- 95a5bb23e21b redis:alpine "docker-entrypoint.s…" 7 hours ago Up 7 hours (healthy) 0.0.0.0:6379->6379/tcp, :::6379->6379/tcp redis
- 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
- 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
- alex@alex-work-laptop:~/code/api$ sail mysql
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 1684
- Server version: 8.0.32 MySQL Community Server - GPL
- Copyright (c) 2000, 2023, Oracle and/or its affiliates.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- 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;
- Query OK, 0 rows affected (0.00 sec)
- Rows matched: 0 Changed: 0 Warnings: 0
- mysql> select version();
- +-----------+
- | version() |
- +-----------+
- | 8.0.32 |
- +-----------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement