近期访问
`klinikapril`.`tokopembelian`
`klinikapril`.`utd_medis_rusak`
`sikklinik`.`beri_bhp_radiologi`
`sikklinik`.`inacbg_klaim_baru2`
`klinikapril`.`alzily_inventaris_jenis`
`sikpt`.`audit_cuci_tangan_medis`
`sikpt`.`alzily_farmasi_mapping_depo`
`klinikapril`.`checklist_kriteria_masuk_icu`
`sikklinik`.`pcare_pendaftaran`
`klinikapril`.`alzily_pacs_files`
表收藏夹
表收藏夹为空。
新建
information_schema
klinikapril
mysql
performance_schema
phpmyadmin
sikklinik
sikpt
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: klinikapril
表: tokopembelian
浏览
结构
SQL
搜索
插入
(当前的)
导出
导入
权限
操作
追踪
触发器
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
information_schema
查询时间 :
在当前会话期间
SELECT * FROM `INNODB_FT_DEFAULT_STOPWORD`
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
sikklinik
查询时间 :
在当前会话期间
SELECT * FROM `antriapotek2`
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
sikklinik
查询时间 :
在当前会话期间
SELECT * FROM `data_triase_igddetail_skala3`
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
sikpt
查询时间 :
在当前会话期间
SELECT * FROM `balasan_pengaduan`
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
编辑模式
文本字段
编辑模式
自定义编辑模式。
保护二进制字段
禁止编辑 BLOB 和 BINARY 类型字段。
否
blob
noblob
all
显示函数列
在编辑/插入模式中显示函数列.
显示字段类型
定义在编辑/插入模式中是否默认显示字段类型一列。
插入的行数
一次可以插入的行数。
外键下拉框顺序
外键下拉框中选项的排序顺序,
content
为关联内容,
id
为键值。
content-id id-content
外键限制
下拉框将在选项少时使用。
文本字段
自定义文本输入框。
编辑 CHAR 类型字段
当编辑 CHAR 和 VARCHAR 类型字段时所使用的控件;
输入框(input)
- 可以限制输入长度,
文本框(textarea)
- 可以输入多行数据。
input
textarea
输入框最小大小
定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最小大小。
输入框最大大小
定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最大大小。
CHAR 文本框列
CHAR/VARCHAR 文本框的列数。
CHAR 文本框行
CHAR/VARCHAR 文本框的行数。
文本框列
编辑模式的文本区大小 (列数),此值将用于 SQL 查询文本区 (*2)。
文本框行
编辑模式的文本区大小 (行数),此值将用于 SQL 查询文本区 (*2) 。
放大 LONGTEXT 的文本框
将 LONGTEXT 字段的文本框放大一倍。
字段
类型
函数
空
值
no_faktur
varchar(20)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
kode_suplier
char(5)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
S0001 - S0001
S0001 - S0001
nip
varchar(20)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
- - -
001 - 001
002 - 002
00005 - 00005
007 - 007
008 - 008
009 - 009
010 - 010
012 - 012
015 - 015
016 - 016
242.02.2024 - 242.02.2024
24855 - 24855
140624 - 140624
150624 - 150624
160624 - 160624
180624 - 180624
190624 - 190624
2024001 - 2024001
4062024 - 4062024
14062024 - 14062024
20171031 - 20171031
20210801 - 20210801
20221101 - 20221101
20240315 - 20240315
20241308 - 20241308
23052025 - 23052025
28022024 - 28022024
202305020 - 202305020
D0000018 - D0000018
D0000032 - D0000032
D001 - D001
- - -
001 - 001
002 - 002
00005 - 00005
007 - 007
008 - 008
009 - 009
010 - 010
012 - 012
015 - 015
016 - 016
242.02.2024 - 242.02.2024
24855 - 24855
140624 - 140624
150624 - 150624
160624 - 160624
180624 - 180624
190624 - 190624
2024001 - 2024001
4062024 - 4062024
14062024 - 14062024
20171031 - 20171031
20210801 - 20210801
20221101 - 20221101
20240315 - 20240315
20241308 - 20241308
23052025 - 23052025
28022024 - 28022024
202305020 - 202305020
D0000018 - D0000018
D0000032 - D0000032
D001 - D001
tgl_beli
date
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
subtotal
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
potongan
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
total
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
ppn
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
meterai
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
tagihan
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
kd_rek
varchar(15)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
1. Bayar Cash - 111010
2. Bayar Via BRI Syariah - 112060
3. Bayar Via Debit BCa - 112020
4. Bayar VIa Bank BNI - 112090
5. Kas Kecil - 111030
6. BANK DKI - 112070
7. Bank BCA - 112080
8. Transfer Mandiri Via EDC - 112010
9. Titipan Uang Muka - 111020
111010 - 1. Bayar Cash
111020 - 9. Titipan Uang Muka
111030 - 5. Kas Kecil
112010 - 8. Transfer Mandiri Via EDC
112020 - 3. Bayar Via Debit BCa
112060 - 2. Bayar Via BRI Syariah
112070 - 6. BANK DKI
112080 - 7. Bank BCA
112090 - 4. Bayar VIa Bank BNI
忽略
字段
类型
函数
空
值
no_faktur
varchar(20)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
kode_suplier
char(5)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
S0001 - S0001
S0001 - S0001
nip
varchar(20)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
- - -
001 - 001
002 - 002
00005 - 00005
007 - 007
008 - 008
009 - 009
010 - 010
012 - 012
015 - 015
016 - 016
242.02.2024 - 242.02.2024
24855 - 24855
140624 - 140624
150624 - 150624
160624 - 160624
180624 - 180624
190624 - 190624
2024001 - 2024001
4062024 - 4062024
14062024 - 14062024
20171031 - 20171031
20210801 - 20210801
20221101 - 20221101
20240315 - 20240315
20241308 - 20241308
23052025 - 23052025
28022024 - 28022024
202305020 - 202305020
D0000018 - D0000018
D0000032 - D0000032
D001 - D001
- - -
001 - 001
002 - 002
00005 - 00005
007 - 007
008 - 008
009 - 009
010 - 010
012 - 012
015 - 015
016 - 016
242.02.2024 - 242.02.2024
24855 - 24855
140624 - 140624
150624 - 150624
160624 - 160624
180624 - 180624
190624 - 190624
2024001 - 2024001
4062024 - 4062024
14062024 - 14062024
20171031 - 20171031
20210801 - 20210801
20221101 - 20221101
20240315 - 20240315
20241308 - 20241308
23052025 - 23052025
28022024 - 28022024
202305020 - 202305020
D0000018 - D0000018
D0000032 - D0000032
D001 - D001
tgl_beli
date
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
subtotal
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
potongan
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
total
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
ppn
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
meterai
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
tagihan
double
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
kd_rek
varchar(15)
ABS
ACOS
AES_DECRYPT
AES_ENCRYPT
ASCII
ASIN
ATAN
BIN
BIT_COUNT
BIT_LENGTH
CEILING
CHAR
CHAR_LENGTH
COMPRESS
CONNECTION_ID
COS
COT
CRC32
CURRENT_DATE
CURRENT_TIME
CURRENT_USER
DATABASE
DATE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DEGREES
DES_DECRYPT
DES_ENCRYPT
ENCRYPT
EXP
FLOOR
FROM_DAYS
FROM_UNIXTIME
HEX
HOUR
INET6_ATON
INET6_NTOA
INET_ATON
INET_NTOA
LAST_DAY
LENGTH
LN
LOAD_FILE
LOG
LOG10
LOG2
LOWER
LTRIM
MD5
MICROSECOND
MINUTE
MONTH
MONTHNAME
NOW
OCT
OLD_PASSWORD
ORD
PASSWORD
PI
QUARTER
QUOTE
RADIANS
RAND
REVERSE
ROUND
RTRIM
SECOND
SEC_TO_TIME
SHA1
SIGN
SIN
SOUNDEX
SPACE
SQRT
SYSDATE
TAN
TIME
TIMESTAMP
TIME_TO_SEC
TO_DAYS
TO_SECONDS
TRIM
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNHEX
UNIX_TIMESTAMP
UPPER
USER
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
UUID
UUID_SHORT
VERSION
WEEK
WEEKDAY
WEEKOFYEAR
YEAR
YEARWEEK
password_hash() PHP函数
1. Bayar Cash - 111010
2. Bayar Via BRI Syariah - 112060
3. Bayar Via Debit BCa - 112020
4. Bayar VIa Bank BNI - 112090
5. Kas Kecil - 111030
6. BANK DKI - 112070
7. Bank BCA - 112080
8. Transfer Mandiri Via EDC - 112010
9. Titipan Uang Muka - 111020
111010 - 1. Bayar Cash
111020 - 9. Titipan Uang Muka
111030 - 5. Kas Kecil
112010 - 8. Transfer Mandiri Via EDC
112020 - 3. Bayar Via Debit BCa
112060 - 2. Bayar Via BRI Syariah
112070 - 6. BANK DKI
112080 - 7. Bank BCA
112090 - 4. Bayar VIa Bank BNI
以新行插入
(忽略错误)以新行插入
显示插入语句
然后
返回上一页
插入新数据
按 TAB 键跳到下一个数值,或 CTRL+方向键 作随意移动.
继续插入
行