select str_to_date
( '2018-04-14 00:00:00', '%Y-%m-%d %H:%i:%s' )
date from dual
select date_format
( now(), '%Y-%m-%d %H:%i:%s' )
date from dual
select concat
('a','b','c') from dual
select concat
('a','b',null) from dual
select concat_ws
(',','a','b',null,'c') from dual
select
name
,
group_concat
(id
order by
id
desc separator
'_')as ids
from
(
select '小明' name
, 2 id
from dual
union all
select '小芳' name
, 3 id
from dual
union all
select '小明' name
, 3 id
from dual
union all
select '小明' name
, 3 id
from dual
union all
select '小芳' name
, 1 id
from dual
union all
select '小芳' name
, 2 id
from dual
)AS B
group by
name
select replace('mysql测试','测试','test') as column1
from dual
SELECT INSTR
("abcd",'s') from dual
;
SELECT INSTR
("abcd",'b') from dual
;
select
*
from
(
select '小明' name
, 1 as id
from dual
union all
select '小芳' name
, 2 as id
from dual
) As A
left join
(
select
*
from
(
select 1 name
, 1 as id
from dual
union all
select '小芳' name
, 2 as id
from dual
) As C
)As B
on
A
.id
=B
.name
select
count(*)
from
(
select '小明' name
, 1 as id
from dual
union all
select '小芳' name
, 2 as id
from dual
)As A
select
if(id
>1,'>','<=') as ids
,
id
from
(
select 1 as id
from dual
union
select 2 as id
from dual
)As A
select
case
when id
<1
then '<'
when id
>1
then '>'
else '=' end as compare
,
id
from
(
select 1 as id
from dual
union
select 2 as id
from dual
)As A
= 1
> 2
SELECT
cast
( 1.3666 AS DECIMAL ( 10, 2 ) )
FROM
DUAL
select IFNULL
(null,2) from dual
select distinct id
from (select 1 as id
from dual
union all select 1 as id
from dual
) A
select id
from (select 'AB' as id
from dual
union all
select 'ABC' as id
from dual
) A
where id
like 'A_'
select id
from (select 'A' as id
from dual
union all
select 'ABC' as id
from dual
) A
where id
like 'A%'
SELECT
id
FROM
(
SELECT 1 AS id
FROM DUAL
UNION
SELECT 2 AS id
FROM DUAL
UNION
SELECT 4 AS id
FROM DUAL
UNION
SELECT 3 AS id
FROM DUAL
) AS A
WHERE
id
BETWEEN 1 AND 3
SELECT
id
FROM
(
SELECT 1 AS id
FROM DUAL
UNION
SELECT 2 AS id
FROM DUAL
UNION
SELECT 4 AS id
FROM DUAL
UNION
SELECT 3 AS id
FROM DUAL
) AS A
WHERE
id
in(1,3)
select date_add
(now(),interval -30 minute) from dual
SELECT DATEDIFF
('2008-12-30','2008-12-31') AS DiffDate
select TIMESTAMPDIFF
(DAY, '2018-03-20 09:00:00', '2018-03-22 08:00:00');
select TIMESTAMPDIFF
(HOUR, '2018-03-20 09:00:00', '2018-03-22 10:00:00');
limit a
,b
;
select * from table limit 5,10
select * from table limit 5
SELECT 'He2n' REGEXP '[0-9]';
SELECT 'Hecn' REGEXP '[0-9]';
转载请注明原文地址: https://mac.8miu.com/read-500835.html