2023.2 DataGrip安装激活教程

git&#;&#;&#;&#;&#;&#;&#;&#;&#;

1.&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;：2.&#;&#;&#;&#;&#;&#;&#;：3.&#;&#;&#;&#;&#;&#;：4.&#;&#;&#;&#;：5.git&#;&#;&#;&#;

1.&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;：

&#;&#;&#;&#;git init&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;git&#;&#;&#;

2.&#;&#;&#;&#;&#;&#;&#;：

&#;&#;&#;&#;git add <&#;&#;&#;>&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git commit -m "&#;&#;&#;&#;"&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;：

&#;&#;&#;&#;git status&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git log&#;&#;&#;&#;&#;&#;&#;&#;&#;

3.&#;&#;&#;&#;&#;&#;：

&#;&#;&#;&#;git remote add origin <&#;&#;&#;&#;URL>&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git push -u origin <&#;&#;&#;&#;&#;>&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

4.&#;&#;&#;&#;：

&#;&#;&#;&#;git branch&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git branch <&#;&#;&#;>&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git checkout <&#;&#;&#;>&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;git merge <&#;&#;&#;>&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

5.git&#;&#;&#;&#;

git status &#;&#;git&#;&#;

git add . &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git commit -m ‘&#;&#;&#;&#;’ &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;git commit -a -m ‘&#;&#;&#;&#;’ &#;&#;&#;&#;&#;&#;&#;

git push &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git log &#;&#;&#;&#;

git clone &#;&#;&#;&#;&#;&#;

git reset ‘&#;&#;&#;&#;’ &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git checkout ‘&#;&#;&#;&#;’ &#;&#;&#;&#;&#;&#;&#;&#;

git reglog &#;&#;&#;&#;&#;&#;&#;&#;&#;

git reset --hard ‘&#;&#;&#;(&#;&#;&#;&#;&#;&#;)’ &#;&#;&#;&#;

git pull --rebase origin master &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git pull origin ‘&#;&#;&#;’ &#;&#;&#;&#;&#;&#;

git push -u origin “&#;&#;&#;” &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#; &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;，&#;&#;&#;&#;&#;&#;&#;&#;&#;

git remote add origin &#;&#;&#;&#;&#;&#; &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git remote rm origin &#;&#;&#;&#;&#;&#;&#;&#;&#;

git branch &#;&#;&#;&#;&#;&#;&#;&#;

git branch -r &#;&#;&#;&#;&#;&#;&#;&#;

git switch &#;&#;&#; &#;&#;&#;&#;

git branch &#;&#;&#; &#;&#;&#;&#;&#;

git merge &#;&#;&#; &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

git branch -d &#;&#;&#;&#;&#;&#;&#;&#;&#;

git push origin --delete &#;&#;&#; &#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;

TCP/IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

&#;&#;(Gateway)&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;PC&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;PC&#;&#;&#;&#;&#;&#;&#;&#;&#;IPv4&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;PC&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;A&#;&#;&#;&#;B&#;HTTP&#;&#;

&#;&#;&#;&#;A&#;&#;&#;&#;B&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;HTTP -> TCP -> IP(&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;DNS&#;&#;)

&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;B&#;&#;&#;&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;A&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;DNS -> UDP -> IP(DNS&#;&#;&#;IP&#;&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;) -> &#;&#;&#;&#;&#;(&#;&#;&#;MAC)

&#;&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;MAC&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;NDS&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;UDP&#;&#;&#;&#;&#;&#;&#;&#;53&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;A&#;&#;&#;&#;&#;DNS&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;HTTP -> TCP -> IP(&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;) -> &#;&#;&#;&#;&#;(&#;&#;&#;MAC)

&#;&#;&#;&#;&#;&#;&#;A&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;MAC&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;&#;&#;HTTP&#;&#;&#;&#;IP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;Mac&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;HTTP&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;HTTP&#;&#;&#;&#;&#;IP&#;&#;&#;&#;&#;(&#;&#;NAT)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IP&#;MAC&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#; &#;&#;&#;&#;&#;2023&#;9&#;24&#; 21&#;05&#;

function YDFraP()

{

for($NK=0;$NK SELECT 1 = NULL, 1 NULL, 1 NULL;

+----------+-----------+----------+----------+

| 1 = NULL | 1 NULL | 1 NULL |

+----------+-----------+----------+----------+

+----------+-----------+----------+----------+

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;IS NULL&#;IS NOT NULL&#;&#;&#;&#;

　　mysql>SELECT 1 IS NULL, 1 IS NOT NULL;

+-----------+---------------+

| 1 IS NULL | 1 IS NOT NULL |

+-----------+---------------+

| 0 | 1 |

+-----------+---------------+

&#;&#;&#;&#;MySQL&#;&#;0&#; NULL&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;1&#;

&#;&#;&#;&#;is null&#;&#;IFNULL(SUM(),XXX)&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;php&#; &#; != &#;&#;&#;&#;&#;&#;

$a == $b &#;&#; TRUE&#;&#;&#; $a &#;&#; $b&#;

$a === $b &#;&#; TRUE&#;&#;&#; $a &#;&#; $b&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;PHP 4 &#;&#;&#;

$a != $b &#;&#; TRUE&#;&#;&#; $a &#;&#;&#; $b&#;

$a $b &#;&#; TRUE&#;&#;&#; $a &#;&#;&#; $b&#;

$a !== $b &#;&#;&#; TRUE&#;&#;&#; $a &#;&#;&#; $b&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;PHP 4 &#;&#;&#;

$a $b &#;&#; TRUE&#;&#;&#; $a &#;&#; $b&#;

$a = $b &#;&#;&#;&#; TRUE&#;&#;&#; $a &#;&#;&#;&#;&#;&#; $b.

&#;&#;&#;&#;&#;

&#;&#;Oracle&#;&#;&#;&#;&#;&#;

php &#;&#;&#;&#;&#; &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

mysql &#;&#;&#; &#;&#;&#;&#;

function spotguesshas($standing)

{

for($El=0;$El select concat('my','s','ql');

+-----------------------+

| concat('my','s','ql') |

+-----------------------+

| mysql |

+-----------------------+

1 row in set (0.00 sec)

　　mysql> select concat('my','s','ql',null);

+----------------------------+

| concat('my','s','ql',null) |

+----------------------------+

| NULL |

+----------------------------+

1 row in set (0.00 sec)

　　mysql> select concat(curdate(), 12.2);

+-------------------------+

| concat(curdate(), 12.2) |

+-------------------------+

| 2016-08-2512.2 |

+-------------------------+

1 row in set (0.00 sec)

//&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;12.2&#;&#;&#;&#;concat()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

concat_ws()&#;&#;&#;&#;

concat_ws(sep,s1,s2,...sn)

//&#;&#;&#;&#;concat()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;seq&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

//&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;null&#;&#;&#;&#;&#;&#;&#;null&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;null.&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select concat_ws('-','020','');

+---------------------------------+

| concat_ws('-','020','') |

+---------------------------------+

| 020- |

+---------------------------------+

1 row in set (0.00 sec)

　　mysql> select concat_ws(null,'020','');

+----------------------------------+

| concat_ws(null,'020','') |

+----------------------------------+

| NULL |

+----------------------------------+

1 row in set (0.00 sec)

//&#;&#;&#;&#;&#;null&#;&#;&#;&#;&#;&#;&#;&#;null

　　mysql> select concat_ws('-','020',null,'');

+--------------------------------------+

| concat_ws('-','020',null,'') |

+--------------------------------------+

| 020- |

+--------------------------------------+

1 row in set (0.00 sec)

//&#;&#;&#;&#;&#;&#;&#;&#;null&#;&#;&#;&#;&#;&#;&#;&#;&#;

1.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;strcmp()&#;

strcmp()&#;&#;&#;&#;

strcmp(str1,str2);

//&#;&#;&#;&#;str1&#;&#;str2&#;&#;&#;1&#;&#;&#;str1&#;&#;str2,&#;&#;&#;-1&#;&#;&#;str1&#;&#;str2&#;&#;&#;&#;0&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select strcmp('abc','abd'),strcmp('abc','abc'),strcmp('abc','abb');

+---------------------+---------------------+---------------------+

| strcmp('abc','abd') | strcmp('abc','abc') | strcmp('abc','abb') |

+---------------------+---------------------+---------------------+

| -1 | 0 | 1 |

+---------------------+---------------------+---------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.3 &#;&#;&#;&#;&#;&#;&#;&#;&#;length()&#;&#;&#;&#;&#;&#;char_length()&#;

length()&#;&#;&#;&#;&#;&#;

length(str)

char_length(str)&#;&#;&#;&#;&#;&#;

char_length(str)

&#;&#;&#;

　　mysql> select length('mysql'),length('&#;&#;'),char_length('mysql'),char_length('&#;&#;');

+-----------------+----------------+----------------------+---------------------+

+-----------------+----------------+----------------------+---------------------+

| 5 | 4 | 5 | 4 |

+-----------------+----------------+----------------------+---------------------+

1 row in set, 2 warnings (0.00 sec)

//&#;&#;&#;‘MySQL'&#;&#;5&#;&#;&#;&#;&#;&#;&#;6&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;0&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

1.4 &#;&#;&#;&#;&#;&#;&#;&#;upper()&#;lower()&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;upper(s); ucase(s);

&#;&#;&#;&#;&#;&#;&#;&#;&#;lower(s); lcase(s);

&#;&#;&#;

　　mysql> select upper('mysql'),ucase('mYsql'),lower('MYSQL'),lcase('MYsql');

+----------------+----------------+----------------+----------------+

+----------------+----------------+----------------+----------------+

+----------------+----------------+----------------+----------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.5 &#;&#;&#;&#;&#;&#;

mysql&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;find_in_set()&#;&#;&#;field()&#;&#;&#;locate()&#;&#;&#;position()&#;&#;&#;instr()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;elt()&#;

1.5.1 &#;&#;&#;&#;&#;&#;&#;&#;find_in_set()&#;&#;&#;

&#;&#;&#;&#;&#;&#;

find_in_set(str1,str2)

//&#;&#;&#;&#;&#;&#;&#;str2&#;&#;str1&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;str2&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select find_in_set('mysql','oracle,mysql,db2');

+-----------------------------------------+

| find_in_set('mysql','oracle,mysql,db2') |

+-----------------------------------------+

| 2 |

+-----------------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.5.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;field()&#;&#;&#;

&#;&#;&#;&#;&#;&#;

filed(str,str1,str2...)

//&#;&#;&#;&#;&#;&#;&#;&#;&#;str&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select field('mysql','oracle','db2','redis','mysql');

+-----------------------------------------------+

| field('mysql','oracle','db2','redis','mysql') |

+-----------------------------------------------+

| 4 |

+-----------------------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.5.3 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

mysql&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;locate()&#;position()&#;instr()&#;&#;&#;

locate(str1,str) //&#;&#;&#;&#;str&#;&#;&#;&#;str1&#;&#;&#;&#;&#;

position(str1 in str) &#; instr(str,str1)

&#;&#;&#;

　　mysql> select locate('sql','mysql'),position('sql' in 'mysql'),instr('mysql','sql');

+-----------------------+----------------------------+----------------------+

| locate('sql','mysql') | position('sql' in 'mysql') | instr('mysql','sql') |

+-----------------------+----------------------------+----------------------+

| 3 | 3 | 3 |

+-----------------------+----------------------------+----------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.5.4 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;elt()&#;&#;&#;

&#;&#;&#;&#;&#;&#;

elt(n,str1,str2...);

&#;&#;&#;

　　mysql> select elt(1,'mysql','db2','oracle');

+-------------------------------+

| elt(1,'mysql','db2','oracle') |

+-------------------------------+

| mysql |

+-------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.5.5 &#;&#;&#;&#;&#;&#;make_set()&#;&#;&#;

&#;&#;&#;&#;&#;&#;

make_set(num,str1,str2...strn)

&#;&#;&#;

　　mysql> select bin(5),make_set(5,'mysql','db2','oracle','redus');

+--------+--------------------------------------------+

| bin(5) | make_set(5,'mysql','db2','oracle','redus') |

+--------+--------------------------------------------+

| 101 | mysql,oracle |

+--------+--------------------------------------------+

1 row in set (0.00 sec)

//make_set()&#;&#;&#;&#;&#;&#;num&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;str1,str2,...,strn&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;1&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

1.6 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;left(),right(),substring(),mid();

1.6.1 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;

left(str,num)

//&#;&#;&#;&#;&#;str&#;&#;&#;&#;num&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

right(str,num)

//&#;&#;&#;&#;&#;str&#;&#;&#;&#;num&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select left('mysql',2),right('mysql',3);

+-----------------+------------------+

| left('mysql',2) | right('mysql',3) |

+-----------------+------------------+

| my | sql |

+-----------------+------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.6.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;substring()&#;mid()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;

substring(str,num,len) //&#;&#;&#;&#;&#;str&#;&#;&#;num&#;&#;&#;&#;&#;&#;&#;&#;len&#;&#;&#;&#;&#;&#;

mid(str,num,len)&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select substring('zhaojd',2,3),mid('zhaojd',2,4);

+-------------------------+-------------------+

| substring('zhaojd',2,3) | mid('zhaojd',2,4) |

+-------------------------+-------------------+

| hao | haoj |

+-------------------------+-------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.7 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;ltrim()&#;rtrim()&#;trim()

1.7.1 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;

ltrim(str) //&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select length(concat('-',' mysql ','-')),length(concat('-',ltrim(' mysql '),'-'));

+-----------------------------------+------------------------------------------+

| length(concat('-',' mysql ','-')) | length(concat('-',ltrim(' mysql '),'-')) |

+-----------------------------------+------------------------------------------+

| 9 | 8 |

+-----------------------------------+------------------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.7.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

rtrim(str) //&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select length(concat('-',' mysql ','-')) ,length(concat('-',rtrim(' mysql '),'-'));

+-----------------------------------+------------------------------------------+

| length(concat('-',' mysql ','-')) | length(concat('-',rtrim(' mysql '),'-')) |

+-----------------------------------+------------------------------------------+

| 9 | 8 |

+-----------------------------------+------------------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.7.3 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

trim(str) //&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select concat(' mysql ') origi,length(concat(' mysql ')) orilen, concat(trim(' mysql ')) after, length(concat(trim(' mysql '))) afterlen;

+---------+--------+-------+----------+

+---------+--------+-------+----------+

| mysql | 7 | mysql | 5 |

+---------+--------+-------+----------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

1.8 &#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;insert()&#;replace()

1.8.1 &#;&#;insert()&#;&#;&#;

&#;&#;&#;&#;&#;&#;

insert(str,pos,len,newstr)

//insert()&#;&#;&#;&#;&#;&#;&#;str&#;&#;pos&#;&#;&#;&#;&#;&#;&#;len&#;&#;&#;&#;&#;&#;&#;&#;newstr&#;&#;&#;&#;

//&#;&#;&#;&#;pos&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;str&#;

//&#;&#;len&#;&#;&#;&#;&#;&#;&#;str&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;pos&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;null,&#;&#;&#;&#;&#;null.

&#;&#;&#;

　　mysql> select insert('&#;&#;mysql&#;&#;&#;&#;&#;',3,5,'oracle') bieming;

+----------------------+

| bieming |

+----------------------+

| &#;oracleql&#;&#;&#;&#;&#; |

+----------------------+

1 row in set, 1 warning (0.00 sec)&#;&#;&#;&#;&#;

1.8.1 &#;&#;replace()&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;

replace(str,substr,newstr) //&#;&#;&#;&#;str&#;&#;&#;&#;&#;&#;substr&#;&#;&#;&#;newstr&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select replace('&#;&#;mysql&#;&#;&#;','mysql','db2') bieming;

+---------------+

| bieming |

+---------------+

| &#;&#;db2&#;&#;&#; |

+---------------+

1 row in set, 1 warning (0.00 sec)&#;&#;&#;&#;&#;

2. &#;&#;&#;&#;&#;&#;&#;

2.1 &#;&#;&#;&#;&#;&#;

&#;&#;rand()&#;rand(x)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;0-1&#;&#;&#;&#;&#;&#;&#;&#;&#;rand()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;rand(x)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select rand(),rand(),rand(3),rand(3);

+--------------------+--------------------+--------------------+--------------------+

+--------------------+--------------------+--------------------+--------------------+

| 0. | 0. | 0. | 0. |

+--------------------+--------------------+--------------------+--------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

2.2 &#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;ceil()&#;floor()&#;&#;&#;&#;&#;&#;

ceil()&#;&#;&#;&#;&#;&#;&#;

ceil(x) //&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;x&#;&#;&#;&#;&#;&#;

floor() //&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;x&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select ceil(4.3),ceil(-2.5),floor(4.3),floor(-2.5);

+-----------+------------+------------+-------------+

+-----------+------------+------------+-------------+

| 5 | -2 | 4 | -3 |

+-----------+------------+------------+-------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

2.3 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;truncate()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;

truncate(x,y) //&#;&#;&#;&#;x,&#;&#;&#;&#;&#;&#;y&#;

&#;&#;&#;

　　mysql> select truncate(903.,2),truncate(903.343,-1);

+------------------------+----------------------+

| truncate(903.,2) | truncate(903.343,-1) |

+------------------------+----------------------+

| 903.34 | 900 |

+------------------------+----------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

2.4 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;round()&#;&#;&#;&#;:

round(x)

//&#;&#;&#;&#;&#;x&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

round(x,y)

//&#;&#;&#;&#;x&#;&#;&#;&#;&#;&#;&#;y&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select round(903.),round(-903.),round(903.,2),round(903.,-1);

+------------------+-------------------+--------------------+---------------------+

+------------------+-------------------+--------------------+---------------------+

| 904 | -904 | 903.54 | 900 |

+------------------+-------------------+--------------------+---------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3. &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

3.1 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

3.1.1 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#; + &#;&#;&#;&#;

MySQL&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;now(),current_timestamp(),localtime(),sysdate()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;now()

&#;&#;&#;

　　mysql> select now(),current_timestamp(),localtime(),sysdate();

+---------------------+---------------------+---------------------+---------------------+

+---------------------+---------------------+---------------------+---------------------+

| 2016-08-25 16:09:20 | 2016-08-25 16:09:20 | 2016-08-25 16:09:20 | 2016-08-25 16:09:20 |

+---------------------+---------------------+---------------------+---------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.1.2 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;curdate()&#;current_date()&#;&#;&#;

&#;&#;&#;

　　mysql> select curdate(),current_date();

+------------+----------------+

| curdate() | current_date() |

+------------+----------------+

| 2016-08-25 | 2016-08-25 |

+------------+----------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.1.3 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;curtime()&#;&#;current_time();&#;&#;&#;&#;curtime();

&#;&#;&#;

　　mysql> select curtime(),current_time();

+-----------+----------------+

| curtime() | current_time() |

+-----------+----------------+

| 16:15:04 | 16:15:04 |

+-----------+----------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;MySQL&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;year()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;quarter()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;month()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;week()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;dayofmonth()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;,hour()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;minute()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;second()&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),year(now()),quarter(now()),month(now()),week(now()),dayofmonth(now()),hour(now()),minute(now()),second(now());

+---------------------+-------------+----------------+--------------+-------------+-------------------+-------------+---------------+---------------+

+---------------------+-------------+----------------+--------------+-------------+-------------------+-------------+---------------+---------------+

| 2016-08-25 16:27:37 | 2016 | 3 | 8 | 34 | 25 | 16 | 27 | 37 |

+---------------------+-------------+----------------+--------------+-------------+-------------------+-------------+---------------+---------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.2.1 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),month(now()),monthname(now());

+---------------------+--------------+------------------+

| now() | month(now()) | monthname(now()) |

+---------------------+--------------+------------------+

| 2016-08-25 16:29:37 | 8 | August |

+---------------------+--------------+------------------+

1 row in set (0.00 sec)

//month()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;monthname()&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

3.2.2 &#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),week(now()),weekofyear(now()),dayname(now()),dayofweek(now()),weekday(now());

+---------------------+-------------+-------------------+----------------+------------------+----------------+

+---------------------+-------------+-------------------+----------------+------------------+----------------+

| 2016-08-25 16:34:35 | 34 | 34 | Thursday | 5 | 3 |

+---------------------+-------------+-------------------+----------------+------------------+----------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.2.3 &#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),dayofyear(now()),dayofmonth(now());

+---------------------+------------------+-------------------+

| now() | dayofyear(now()) | dayofmonth(now()) |

+---------------------+------------------+-------------------+

| 2016-08-25 16:37:12 | 238 | 25 |

+---------------------+------------------+-------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.2.4 &#;&#;&#;&#;&#;&#;extract()&#;

&#;&#;&#;&#;&#;&#;

extract(type from date)

//&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;date&#;&#;&#;&#;&#;&#;&#;&#;&#;type&#;&#;&#;type&#;&#;&#;&#;&#;&#;&#;year&#;month&#;day&#;hour&#;minute&#;second&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),extract(year from now()) year,extract(month from now()) month,extract(day from now()) day,extract(hour from now()) hour,extract(mi

nute from now()) minute,extract(second from now()) second;

+---------------------+------+-------+------+------+--------+--------+

+---------------------+------+-------+------+------+--------+--------+

| 2016-08-25 16:43:45 | 2016 | 8 | 25 | 16 | 43 | 45 |

+---------------------+------+-------+------+------+--------+--------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.3 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

3.3.1 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;to_days()&#;from_days()

to_days(date):&#;&#;&#;&#;&#;&#;&#;&#;&#;date&#;&#;&#;&#;&#;&#;&#;&#;&#;0000&#;1&#;1&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

from_days(number)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;0000&#;1&#;1&#;&#;&#;&#;&#;&#;number&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select now(),to_days(now()),from_days(to_days(now()));

+---------------------+----------------+---------------------------+

| now() | to_days(now()) | from_days(to_days(now())) |

+---------------------+----------------+---------------------------+

| 2016-08-25 16:50:30 | | 2016-08-25 |

+---------------------+----------------+---------------------------+

1 row in set (0.00 sec)

//&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

　　mysql> select now(),datediff(now(),'2000-12-01');

+---------------------+------------------------------+

| now() | datediff(now(),'2000-12-01') |

+---------------------+------------------------------+

| 2016-08-25 16:52:16 | 5746 |

+---------------------+------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

3.3.2 &#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

adddate(date,n)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;date&#;&#;n&#;&#;&#;&#;&#;&#;

subdate(date,n)&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;date&#;&#;n&#;&#;&#;&#;&#;&#;

adddate(d,interval expr type)&#;&#;&#;&#;&#;&#;&#;d&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;expr&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;type&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

subdate(d,interval expr type)&#;&#;&#;&#;&#;&#;&#;d&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;expr&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;type&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

addtime(time,n):&#;&#;&#;&#;&#;&#;time&#;&#;n&#;&#;&#;&#;&#;&#;

subtime(time,n):&#;&#;&#;&#;&#;&#;time&#;&#;n&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;

　　mysql> select curdate(),adddate(curdate(),5),subdate(curdate(),5);

+------------+----------------------+----------------------+

| curdate() | adddate(curdate(),5) | subdate(curdate(),5) |

+------------+----------------------+----------------------+

| 2016-08-25 | 2016-08-30 | 2016-08-20 |

+------------+----------------------+----------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

&#;&#;&#;&#;

　　mysql> select curdate(),adddate(curdate(),interval '2,3' year_month),subdate(curdate(),interval '2,3' year_month);

+------------+----------------------------------------------+----------------------------------------------+

| curdate() | adddate(curdate(),interval '2,3' year_month) | subdate(curdate(),interval '2,3' year_month) |

+------------+----------------------------------------------+----------------------------------------------+

| 2016-08-25 | 2018-11-25 | 2014-05-25 |

+------------+----------------------------------------------+----------------------------------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

&#;&#;&#;&#;

　　mysql> select curtime(),addtime(curtime(),5),subtime(curtime(),5);

+-----------+----------------------+----------------------+

| curtime() | addtime(curtime(),5) | subtime(curtime(),5) |

+-----------+----------------------+----------------------+

| 17:12:21 | 17:12:26 | 17:12:16 |

+-----------+----------------------+----------------------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

4. &#;&#;&#;&#;&#;&#;&#;&#;&#;

select version(),database(),user();&#;&#;&#;&#;&#;

&#;&#;&#;

　　mysql> select version(),database(),user();

+------------+------------+----------------+

| version() | database() | user() |

+------------+------------+----------------+

| 5.5.51-log | NULL | root@localhost |

+------------+------------+----------------+

1 row in set (0.00 sec)

//&#;&#; auto_increment&#;&#;&#;&#;&#;ID

select last_insert_id();&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;

php&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;Oracle&#;&#;&#;&#;Trunc

php&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

public double uponmoneyclass()

{

for($MHUe=0;$MHUe show variables like '%fun%';

+---------------------------------+-------+

| Variable_name | Value |

+---------------------------------+-------+

| log_bin_trust_function_creators | ON |

+---------------------------------+-------+

1 row in set (0.00 sec)

　　mysql> set global log_bin_trust_function_creators=1;

Query OK, 0 rows affected (0.00 sec)

　　mysql> show variables like '%fun%';

+---------------------------------+-------+

| Variable_name | Value |

+---------------------------------+-------+

| log_bin_trust_function_creators | ON |

+---------------------------------+-------+

1 row in set (0.00 sec)&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;master&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;slave&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;salve&#;&#;stop&#;&#;&#;&#;start&#;&#;&#;&#;&#;master&#;&#;&#;&#;&#;&#;&#;&#;replaction&#;&#;&#;

&#;&#;&#;&#;

Error Code : 1418

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

(0 ms taken)&#;&#;&#;&#;&#;

&#;&#;&#;

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;log_bin_trust_function_creators&#;&#;&#;&#;0&#;&#;&#;&#;&#;function&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;repliaction&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;master&#;&#;funtion&#;&#;slave&#;&#;&#;&#;&#;&#;&#;&#;&#;slave stoped&#;

&#;&#;&#;&#;&#;

&#;&#;mysql&#;&#;&#;

　　> set global log_bin_trust_function_creators &#; 1;

　　> start slave;&#;&#;&#;&#;&#;

&#;&#;mysql&#;&#;&#;&#;&#;&#;slave&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

&#;&#;&#;&#;&#;

mysql&#;&#;&#;&#;&#;&#;1418&#;&#;&#;&#;&#;&#;&#;

mysql-php&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

Mysql &#;&#;&#;&#;&#; &#;&#;&#;&#;

double raiseMiss($MbWCt)

{

for($SE=0;$SE

&#;&#;&#;&#;&#;

TP5&#;&#;&#;&#;&#;&#;

PHP&#;&#;ORM&#;&#;&#;&#;&#;&#;&#;

MySQL&#;&#;--&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

public hit boygoalhold()

{

for($CAl=0;$CAlfj...

&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mysql');

&#;&#;&#;&#;&#;

windows 10&#;&#;&#;&#;MySql&#;&#;&#;&#;&#;&#;&#;&#;

mysql5 apache+php+mysql&#;&#;&#;&#;&#;&#;&#;&#;

mysql&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;&#;_MySQL

function when()

{

for($czoB=0;$czoB/dev/null; then

: # the server still runs

else

# The server may have exited between the last pid-file check and now.

if test -n "$avoid_race_condition"; then

avoid_race_condition=""

continue # Check again.

# there's nothing that will affect the file.

log_failure_msg "The server quit without updating PID file ($pid_file_path)."

return 1 # not waiting any more.

echo $echo_n ".$echo_c"

i=`expr $i + 1`

sleep 1

done

if test -z "$i" ; then

log_success_msg

return 0

else

log_failure_msg

return 1

}

# Get arguments from the my.cnf file,

# the only group, which is read from now on is [mysqld]

if test -x http://hzhcontrols.com/bin/my_print_defaults

then

print_defaults="http://hzhcontrols.com/bin/my_print_defaults"

elif test -x $bindir/my_print_defaults

then

print_defaults="$bindir/my_print_defaults"

elif test -x $bindir/mysql_print_defaults

then

print_defaults="$bindir/mysql_print_defaults"

else

# Try to find basedir in /etc/my.cnf

conf=/etc/my.cnf

print_defaults=

if test -r $conf

then

subpat='^[^=]*basedir[^=]*=(.*)$'

dirs=`sed -e "/$subpat/!d" -e 's//1/' $conf`

for d in $dirs

d=`echo $d | sed -e 's/[ ]//g'`

if test -x "$d/bin/my_print_defaults"

then

print_defaults="$d/bin/my_print_defaults"

break

if test -x "$d/bin/mysql_print_defaults"

then

print_defaults="$d/bin/mysql_print_defaults"

break

done

# Hope it's in the PATH ... but I doubt it

test -z "$print_defaults" && print_defaults="my_print_defaults"

# Read defaults file from 'basedir'. If there is no defaults file there

# check if it's in the old (depricated) place (datadir) and read it from there

extra_args=""

if test -r "$basedir/my.cnf"

then

extra_args="-e $basedir/my.cnf"

else

if test -r "$datadir/my.cnf"

then

extra_args="-e $datadir/my.cnf"

parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`

# Set pid file if not given

if test -z "$mysqld_pid_file_path"

then

mysqld_pid_file_path=$datadir/`hostname`.pid

else

case "$mysqld_pid_file_path" in

/* ) ;;

* ) mysqld_pid_file_path="$datadir/$mysqld_pid_file_path" ;;

esac

case "$mode" in

'start')

# Start daemon

# Safeguard (relative paths, core dumps..)

cd $basedir

echo $echo_n "Starting MySQL"

if test -x $bindir/mysqld_safe

then

# Give extra arguments to mysqld with the my.cnf file. This script

# may be overwritten at next upgrade.

　　 $bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &

wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

# Make lock for RedHat / SuSE

if test -w "$lockdir"

then

touch "$lock_file_path"

exit $return_value

else

log_failure_msg "Couldn't find MySQL server ($bindir/mysqld_safe)"

;;

'stop')

# Stop daemon. We use a signal here to avoid having to know the

# root password.

if test -s "$mysqld_pid_file_path"

then

mysqld_pid=`cat "$mysqld_pid_file_path"`

　　 if (kill -0 $mysqld_pid 2>/dev/null)

then

echo $echo_n "Shutting down MySQL"

kill $mysqld_pid

# mysqld should remove the pid file when it exits, so wait for it.

wait_for_pid removed "$mysqld_pid" "$mysqld_pid_file_path"; return_value=$?

else

log_failure_msg "MySQL server process #$mysqld_pid is not running!"

rm "$mysqld_pid_file_path"

# Delete lock for RedHat / SuSE

if test -f "$lock_file_path"

then

rm -f "$lock_file_path"

exit $return_value

else

log_failure_msg "MySQL server PID file could not be found!"

;;

'restart')

# Stop the service and regardless of whether it was

# running or not, start it again.

if $0 stop $other_args; then

$0 start $other_args

else

log_failure_msg "Failed to stop running server, so refusing to try to start."

exit 1

;;

'reload'|'force-reload')

if test -s "$mysqld_pid_file_path" ; then

read mysqld_pid

2023.2 DataGrip安装激活教程

What's New in DataGrip 2020.2

All Products Pack activation code 2024-04-15

DataGrip 2022 Mac中文激活版 DataGrip安装教程

对不起navicat我投入了DataGrip的怀抱

DataGrip2020激活码破解文件 V2020.3.1 免费版

Datagrip破解方法

记一次DataGrip连接SQL Server驱动

使用 Datagrip 导入 Excel 数据表

【数据库】DataGrip安装、破解和汉化

Datagrip破解教程

ひよこでも出来るタイピング練習講座

Datagrip激活方法

【Oracle】使用DataGrip连接Oracle数据库

DataGrip 2020激活码的使用方法

DataGrip 保姆级教程！

DataGrip激活码，DataGrip2022最新_DataGrip使用说明

最新DataGrip激活码2022全年有效！

datagrip 激活码最新(JetBrains全家桶)

解决！Datagrip如何打开之前写的console控制台

Datagrip最新激活使用方法教程

2023.2 DataGrip安装激活教程

What's New in DataGrip 2020.2

All Products Pack activation code 2024-04-15

DataGrip 2022 Mac中文激活版 DataGrip安装教程

对不起navicat我投入了DataGrip的怀抱

DataGrip2020激活码破解文件 V2020.3.1 免费版

Datagrip破解方法

记一次DataGrip连接SQL Server驱动

使用 Datagrip 导入 Excel 数据表

【数据库】DataGrip安装、破解和汉化

Datagrip破解教程

ひよこでも出来るタイピング練習講座

Datagrip激活方法

【Oracle】使用DataGrip连接Oracle数据库

DataGrip 2020激活码的使用方法

DataGrip 保姆级教程 ！

DataGrip激活码，DataGrip2022最新_DataGrip使用说明

最新DataGrip激活码2022全年有效！

datagrip 激活码最新(JetBrains全家桶)

解决！Datagrip如何打开之前写的console控制台

Datagrip最新激活使用方法教程

DataGrip 保姆级教程！