Início / user-245597

user3508766's questions

Martin Hope
user3508766
Asked: 2018-04-11 10:22:58 +0800 CST
  • 0

Quando eu executo este script

mysql -e "use sentry;
select   DISTINCT
concat(
'CREATE ROLE \`',
r.ROLE_NAME,
'\`;')
from
SENTRY_ROLE r
join SENTRY_ROLE_DB_PRIVILEGE_MAP rp on rp.ROLE_ID = r.ROLE_ID
join SENTRY_DB_PRIVILEGE p on p.DB_PRIVILEGE_ID = rp.DB_PRIVILEGE_ID
;" -u mysql_sel -p$Pass

eu recebo saída de

+---------------------------------------------------------+
| concat(
'CREATE ROLE `',
r.ROLE_NAME,
'`;') |
+---------------------------------------------------------+
| CREATE ROLE `admin_role`;                               |

Como posso obter a saída de apenas

+---------------------------------------------------------+
| CREATE ROLE `admin_role`;                               |
linux bash
Martin Hope
user3508766
Asked: 2018-03-06 13:00:54 +0800 CST
  • 1

Eu tenho um arquivo de texto que se parece com isso:

Start find in flight queries
2018-03-05 15:50:02,069:INFO:######################################
Start find completed queries
2018-03-05 15:50:02,070:INFO:Starting new HTTPS connection (1): server060
2018-03-05 15:50:02,083:DEBUG:"GET /queries?json HTTP/1.1" 401 0
2018-03-05 15:50:02,084:INFO:Resetting dropped connection: server060
2018-03-05 15:50:02,095:DEBUG:"GET /queries?json HTTP/1.1" 200 19059
2018-03-05 15:50:02,099:INFO:######################################
Start find in flight queries

A data e a hora mudam a cada 5 minutos. Preciso copiar a última data e hora para outro arquivo. Neste exemplo, é 2018-03-05 15:50:02. Todas as sugestões são apreciadas. Eu usei um pouco de regex no passado, mas não era bom nisso.

linux rhel