导出随机数并且解决身份证后面000的sql语句
导出随机数并且解决身份证后面000的sql语句SELECT
t.id AS 'ID',
t.name AS '名称',
t.qymc AS '企业名称',
concat(t.yyzz,'\t') as '营业执照',
concat(t.card,'\t') as '身份证号',
t.dizhi AS '地址',
t.y_card AS '类型',
t.tel AS '联系方式',
t.qm AS '电子签名文件',
t.beizhu AS '备注'
from info t WHERE id<300000 ORDER BY RAND()
页:
[1]