雅安论坛

标题: 导出随机数并且解决身份证后面000的sql语句 [打印本页]

---

作者: 匿名    时间: 2022-1-5 11:29
标题: 导出随机数并且解决身份证后面000的sql语句
导出随机数并且解决身份证后面000的sql语句

1. SELECT
   
2. t.id AS 'ID',
   
3. t.name AS '名称',
   
4. t.qymc AS '企业名称',
   
5. concat(t.yyzz,'\t') as '营业执照',
   
6. concat(t.card,'\t') as '身份证号',
   
7. t.dizhi AS '地址',
   
8. t.y_card AS '类型',
   
9. t.tel AS '联系方式',
   
10. t.qm AS '电子签名文件',
    
11. t.beizhu AS '备注'
    
12. from info t WHERE id<300000 ORDER BY RAND()

复制代码

---

欢迎光临 雅安论坛 (https://www.yaanbbs.net/)

Powered by Discuz! X3.4