P
P
plan_ept2018-11-19 12:31:46
PHP
plan_ept, 2018-11-19 12:31:46

What does PLAN(NATURAL) output mean?

There is a base with a specific name SORT_ARCHIV_GAZ, it has a DATE field, in which CHAR is specified by type. The date is in the format dd:mm:yyyy. There is a task - to remove the fields with the year 2014. When I try to destroy them with the
delete from sort_archiv_gaz where sort_archiv_gaz.date < '01/01/2015' command,
I get the following output:
Plan
PLAN (SORT_ARCHIV_GAZ NATURAL)
Adapted Plan
PLAN (SORT_ARCHIV_GAZ NATURAL)
Well, nothing on the exhaust. What that conclusion is, I don't know. I work in IBExpert, Firebird 2.0, built-in SQL Editor.
If you try to delete one line by changing the command to:
delete from sort_archiv_gaz where sort_archiv_gaz.date = '07/01/2014
The output is the same.

Answer the question

In order to leave comments, you need to log in

5 answer(s)
M
Mikhail Osher, 2015-11-12
@SuperDoker

Regulators are not needed here.

$urls = [
    'https://steamcommunity.com/tradeoffer/new/?foo=bar&token=35b902385b90238509b23b52',
    'https://steamcommunity.com/tradeoffer/new/?foo=bar&pew=1&token=v8d90awv5a985va85aw',
];

function extract_token($url)
{
    parse_str(parse_url($url, PHP_URL_QUERY), $queryString);

    return isset($queryString['token']) ? $queryString['token'] : null;
}

var_dump(extract_token($urls[0]));
var_dump(extract_token($urls[1]));

string(24) "35b902385b90238509b23b52"
string(19) "v8d90awv5a985va85aw"

W
wol_fi, 2015-11-12
@wol_fi

$matches = array();
preg_match('/token=(.*)$/', "https://steamcommunity.com/tradeoffer/new/?partner... символы&token=любые символы", $matches);
echo $matches[1];//любые символы

I
Ivanq, 2015-11-12
@Ivanq

preg_replace("&token=.*$", "", "http://abc/cde/?abc=def&token=tghjkldfghjklfghjk,");

V
Vitaliy Orlov, 2015-11-12
@orlov0562

It's not entirely clear what you need to do, if you just remove characters, it will be something like this:
preg_replace(''~=.+(&|$)~, '=$1', $url);
those.
all characters that come after "=" and end with "&" or "end of line"
should be replaced with
"=" + "&" or "end of line"

K
Konstantin Tsvetkov, 2018-11-19
@tsklab

delete from sort_archiv_gaz where right(sort_archiv_gaz.date,4) < '2015'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question