Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL

MySQL

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
14 cards
()
Section 1

Preview this deck

GROUP_CONCAT(phone ORDERBY phone seperator ';');

Front

1 / 14

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (14)

Section 1

(14 cards)

GROUP_CONCAT(phone ORDERBY phone seperator ';');

Front

group array？

Back

SELECT * IN (SELECT ..

Front

内嵌 JOIN

Back

SUBSTRING(first_name, 1, 2)

Front

提取字符串当中的第一个字母开始 往后一共两个字母

Back

CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition;

Front

don't understand

Back

SET @variable1=5; SELECT ..WHERE xx_id<5

Front

set variables in MYSQL

Back

length（firstname）

Front

返回长度

Back

TRIM(LEADING 'A ' from description) TRIM(TAILING 'y' from description)

Front

修剪字符串，从左或右

Back

#mySQL

Front

commenting out xx

Back

WHERE DATE（lastupdate）='2018-07-09'

Front

datestamp 的特殊查找，和普通数字不同

Back

SELECT * FROM (SELECT ..

Front

内嵌 JOIN

Back

CONCAT(firstname，lastname)

Front

合并两个字符串

Back

LOWER(firstname)

Front

lowercase of the name

Back

microsoft version: declare @variables varchar(30)

Front

Back

select locate（'cora'， firstname）from actor ---mysql select position （'cora' in firstname）form -----postgre

Front

找到字符串起始位置

Back