主页 / user-3970561

elbarna's questions

Martin Hope
elbarna
Asked: 2025-03-08 14:35:15 +0800 CST
  • 6

情况就是这样

select calldate,src,dst,clid,nome from cdr limit 255 offset 1015;
+---------------------+------------+--------------+------------------------------------+------+
| calldate            | src        | dst          | clid                               | name |
+---------------------+------------+--------------+------------------------------------+------+
| 2025-03-04 04:49:59 | 1234567891 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 04:49:59 | 1234567891 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 04:49:59 | 1234567891 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 11:02:07 | 9812737374 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 11:02:05 | 9812737374 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 11:02:05 | 9812737374 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 11:31:53 | 9812737374 | +11123456789 | NONE                               | CKTC |
| 2025-03-04 16:22:08 | 3233333    | 9182374747   | NONE                               | CKTC |
| 2025-03-04 18:41:46 | 3233333    | 9182374747   | NONE                               | CKTC |
| 2025-03-08 01:11:27 | 3233333    | 9182374747   | NONE                               | CKTC |
+---------------------+------------+--------------+------------------------------------+------+

我想用空值替换 +11，简而言之：我想将其剪切掉但只替换 +11，而不触及其他值。

如果我用这行

select calldate,src,substr(dst,4,11) as dst,clid,nome from cdr limit 255 offset 1015;

它削减了所有值，而不仅仅是 +11

如果我用这个

select calldate,src,(select substr(dst,4,11) where dst='+11123456789') as dst,clid,nome from cdr limit 255 offset 1015;

工作正常，但其他数字的“dst”值变为NULL我的想法是这样的

select calldate,src,dst,clid,nome from cdr limit 255 offset 1015;
    +---------------------+------------+--------------+------------------------------------+------+
    | calldate            | src        | dst          | clid                               | name |
    +---------------------+------------+--------------+------------------------------------+------+
    | 2025-03-04 04:49:59 | 1234567891 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 04:49:59 | 1234567891 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 04:49:59 | 1234567891 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 11:02:07 | 9812737374 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 11:02:05 | 9812737374 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 11:02:05 | 9812737374 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 11:31:53 | 9812737374 | 123456789    | NONE                               | CKTC |
    | 2025-03-04 16:22:08 | 3233333    | 9182374747   | NONE                               | CKTC |
    | 2025-03-04 18:41:46 | 3233333    | 9182374747   | NONE                               | CKTC |
    | 2025-03-08 01:11:27 | 3233333    | 9182374747   | NONE                               | CKTC |
    +---------------------+------------+--------------+------------------------------------+------+

，怎么办？可能吗？

mysql
Martin Hope
elbarna
Asked: 2025-02-28 04:09:00 +0800 CST
  • 6

我已经创建了这个表

CREATE TABLE mytable (
    ID bigint NOT NULL AUTO_INCREMENT,
    Caller varchar(255) NOT NULL,
    Name varchar(255) NOT NULL,
    PRIMARY KEY (ID));

ALTER TABLE `mytable` ADD UNIQUE `unique_index`(`Name`, `Caller`);

问题：

如果我插入

insert into mytable values ('value1','12929393');

进而

insert into mytable values ('value1','12929393');

由于重复而阻止它（没问题）

但如果我插入

insert into mytable values ('value1','12929344');

或者

insert into mytable values ('value2','12929393');

它接受并且我更愿意阻止它因为值 12929393 是重复的，可以在 mysql 或 mariadb 中做到这一点吗？

mysql
Martin Hope
elbarna
Asked: 2024-12-15 09:24:36 +0800 CST
  • 7

看看那些正则表达式

find /tmp/MG/virt-manager-5.0.0/ -maxdepth 1 -type f |grep -v  [^a-z]+\.[^a-z]+
/tmp/MG/virt-manager-5.0.0/.mailmap
/tmp/MG/virt-manager-5.0.0/virt-manager
/tmp/MG/virt-manager-5.0.0/DESIGN.md
/tmp/MG/virt-manager-5.0.0/meson.build
/tmp/MG/virt-manager-5.0.0/NEWS.md
/tmp/MG/virt-manager-5.0.0/.gitignore
/tmp/MG/virt-manager-5.0.0/README.md
/tmp/MG/virt-manager-5.0.0/.pylintrc
/tmp/MG/virt-manager-5.0.0/.coveragerc
/tmp/MG/virt-manager-5.0.0/virt-install
/tmp/MG/virt-manager-5.0.0/.packit.yaml
/tmp/MG/virt-manager-5.0.0/COPYING
/tmp/MG/virt-manager-5.0.0/virt-xml
/tmp/MG/virt-manager-5.0.0/virt-manager.spec.in
/tmp/MG/virt-manager-5.0.0/INSTALL.md
/tmp/MG/virt-manager-5.0.0/meson_options.txt
/tmp/MG/virt-manager-5.0.0/virt-manager.spec
/tmp/MG/virt-manager-5.0.0/virt-clone
/tmp/MG/virt-manager-5.0.0/CONTRIBUTING.md
/tmp/MG/virt-manager-5.0.0/setup.cfg

我想获取包含大写字母的字符串，包括 .md .txt 但只有单词至少包含一个大写字母才能更好地解释

CONTRIBUTING.MD OK
CONTRIBUTING.txt OK
CONTRIBUTING.TXT OK
Contributing.txt OK (has one capital letter)
hello.TXT OK (contain some capital letters)
contributing.txt NO (only lowercase)

我想获得这个

  find /tmp/MG/virt-manager-5.0.0/ -maxdepth 1 -type f |grep -v REGEXWORKS

    /tmp/MG/virt-manager-5.0.0/DESIGN.md
    /tmp/MG/virt-manager-5.0.0/NEWS.md
    /tmp/MG/virt-manager-5.0.0/README.md
    /tmp/MG/virt-manager-5.0.0/COPYING
    /tmp/MG/virt-manager-5.0.0/INSTALL.md
    /tmp/MG/virt-manager-5.0.0/CONTRIBUTING.md

怎么办？谢谢

regex
Martin Hope
elbarna
Asked: 2023-11-14 05:46:12 +0800 CST
  • 1

我想增加一个变量，所以 c 是 4，d 是 c ++ （所以是 5）

这段代码有效

#include <stdio.h>

int main()
{
int c = 4;
int d = ++c ;
printf("Value of c is: %d \n", c);
printf("Value of d is: %d \n", d);
}

问题是 c 和 d 返回 5。

Value of c is: 5 
Value of d is: 5

我想获得这个：

Value of c is: 4
Value of d is: 5

我的想法是声明一个var(c)将4赋值给c，然后声明d并将c++的值赋给d。bash 上有类似的东西，但使用 ++ 而不是 +1 （太简单了）

#!/bin/bash
c=4

echo "C is now $c"

d=$((++c))

echo "D is now $d"

有什么建议吗？

c
Martin Hope
elbarna
Asked: 2023-09-03 07:05:22 +0800 CST
  • 5

我的 Oracle 实例无法启动

Total System Global Area|1608409464|bytes
Fixed Size              |  10043768|bytes
Variable Size           |1107296256|bytes
Database Buffers        | 486539264|bytes
Redo Buffers            |   4530176|bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1341
Session ID: 4 Serial number: 23966

我已经知道问题所在了.. FRA 已满吗

du -sh /opt/oracle/oraflash
30G /opt/oracle/oraflash

我已经知道如何解决这个问题

SQL> startup mount;
ORACLE instance started.

Total System Global Area|1608409464|bytes
Fixed Size              |  10043768|bytes
Variable Size           |1107296256|bytes
Database Buffers        | 486539264|bytes
Redo Buffers            |   4530176|bytes
SQL>

然后我运行 rman

RMAN> crosscheck archivelog all;
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
delete noprompt archivelog all;

终于可以运行oracle了

sqlplus / as sysdba

shutdown immediate
startup

我的问题是：如何配置 Oracle 以避免 FRA 如此快地变满而不扩展 FRA 大小？谢谢

oracle