Dreamweaver TechniqueJAVA Script サンプル | CSS sample | JAVA Applet sample | Flash Sample
HTML4.0 reference | DynamicHTMLXHTML | XML sample | XSLT sample | RIKO's ASP Trial
ASP ADO リファレンス | PHP関数リファレンス | MySQL関数リファレンス

MySQL関数リファレンス

■ 文字列関数

CONCAT

LENGTY / OCAT_LENGTH

CHAR_LENGTH / CHARACTER_LENGTH

LOCATE / POSITION

INSTR

LEFT

RIGHT

SUBSTRING / SUBSTRING / MID

SUBSTRING / SUBSTRING

SUBSTRING_INDEX

REPLACE

INSERT

LCASE / LOWER

UCASE / UPPER

REVERSE

LTRIM

RTRIM

TRIM

LPAD

RPAD

SPACE

REPEAT

LOAD_FILE

ASCII

ORD

CHAR

CONV

BIN

OCT

HEX

■ 日付関数

CURDATE / CURRENT_DATE

CURTIME / CURRENT_TIME

NOW / SYSDATE / CURRENT_TIMESTAMP

UNIX_TIMESTAMP

DATE_FORMAT

FROM_UNIXTIME

SEC_TO_TIME

TIME_TO_SCALE

YEAR

MONTH

DAYOFMONTH

HOUR

MINUTE

SECOND

DAYOFWEEK

WEEKDAY

QUARTER

DAYOFYEAR

WEEK

DAYNAME

MONTHNAME

EXTRACT

DATE_ADD / DATE_SUB / ADDDATE / SUBDATE

PERIOD_ADD

TO_DAYS

FROM_DAYS

■ 数学関数

FORMAT

ROUND

ROUND

FLOOR

CEILING

TRUNCATE

ABS

MOD

POW / POWER

RAND

SIGN

COS

SIN

TAN

ACOS

ASIN

ASIN

ATAN

ATAN2

COT

EXP

LOG

LOG10

SQRT

PI

DEGRESS

RADIANS

■ 制御関数

IF

CASE

IFNULL

ISNULL

COALCASE

GREATEST

ELT

FIELD

INTERVAL

FIND_IN_SET

MAKE_SET

■ その他の関数

DATABASE

USER / SYSTEM_USER / SESSION_USER

VERSION

PASSWORD

ENCODE

DECODE

GETR_LOCK

RELEASE_LOCK

R HOUSE | RIKO's Trial Page | Shirley's Pettit Case | Shirley's i-box | Shirley's little box