INSERT INTO T_SJDR_DWGXX (
GUID,
WGZXJD,
WGZXWD,
WGLX,
JTXQL,
BBH,
DOUSER,
DODATE
) SELECT
UUID(),
WGZXJD,
WGZXWD,
'dwg',
(
SELECT
FLOOR(7 +(RAND() * 10000))
) jtxql,
'2017-07-28_1',
'721a0a79-73bd-4176-8fdc-229652410882',
now()
FROM
t_sjdr_wgzzxx
WHERE
WGLX = 'dwg'
mysql 向表中插入随机数
最新推荐文章于 2024-07-28 02:51:23 发布