MySQL− codes (wildcards, formatting)

 0    36 speciālā zīme    sir
lejupielādēt mp3 Drukāt spēlēt pārbaudiet sevi
 
jautājums atbilde
Represents zero or more characters
sākt mācīties
%
bl% finds bl, black, blue, and blob
Represents a single character
sākt mācīties
_
h_t finds hot, hat, and hit
Represents any single character within the brackets
sākt mācīties
[]
h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets
sākt mācīties
^
h[^oa]t finds hit, but not hot and hat
Represents a range of characters
sākt mācīties
-
c[a-b]t finds cat and cbt
Abbreviated weekday name (Sun to Sat)
sākt mācīties
%a
Abbreviated month name (Jan to Dec)
sākt mācīties
%b
Month number (0 to 12)
sākt mācīties
%c
Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...)
sākt mācīties
%D
Day of the month as a numeric value (01 to 31)
sākt mācīties
%d
Day of the month as a numeric value (0 to 31)
sākt mācīties
%e
Microseconds (000000 to 999999)
sākt mācīties
%f
Hour (00 to 23)
sākt mācīties
%H
Hour (00 to 12)
sākt mācīties
%h
Hour (00 to 12)
sākt mācīties
%I
Minutes (00 to 59)
sākt mācīties
%i
Day of the year (001 to 366)
sākt mācīties
%j
Hour (0 to 23)
sākt mācīties
%k
Hour (1 to 12)
sākt mācīties
%l
Month name in full (January to December)
sākt mācīties
%M
Month name as a numeric value (00 to 12)
sākt mācīties
%m
AM or PM
sākt mācīties
%p
Time in 12 hour AM or PM format (hh: mm: ss AM/PM)
sākt mācīties
%r
Seconds (00 to 59)
sākt mācīties
%S
Seconds (00 to 59)
sākt mācīties
%s
Time in 24 hour format (hh: mm: ss)
sākt mācīties
%T
Week where Sunday is the first day of the week (00 to 53)
sākt mācīties
%U
Week where Monday is the first day of the week (00 to 53)
sākt mācīties
%u
Week where Sunday is the first day of the week (01 to 53). Used with %X
sākt mācīties
%V
Week where Monday is the first day of the week (01 to 53). Used with %x
sākt mācīties
%v
Weekday name in full (Sunday to Saturday)
sākt mācīties
%W
Day of the week where Sunday=0 and Saturday=6
sākt mācīties
%w
Year for the week where Sunday is the first day of the week. Used with %V
sākt mācīties
%X
Year for the week where Monday is the first day of the week. Used with %v
sākt mācīties
%x
Year as a numeric, 4-digit value
sākt mācīties
%Y
Year as a numeric, 2-digit value
sākt mācīties
%y

Skatīt līdzīgas flashcards:

MS Access − Wildcards

Lai ievietotu komentāru, jums jāpiesakās.