1. 论坛系统升级为Xenforo,欢迎大家测试!
    排除公告

会程序的麻烦进来一下,帮一下忙!(WC,不要齐头并进一半就走啊,帮忙)

本帖由 Kevin2006-03-31 发布。版面名称:源码讨论

  1. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    我想在phpmyadmin中批量增加某个表的记录,不知怎么写执行语句,有谁帮想一下?谢谢了!

    我只会写单句的:
    INSERT INTO `表名` (`id`, `email`) VALUES ('1', '[email protected]');

    现在要实现的效果是录入N条记录,ID从1到100
    请问要怎么写?:ft:
     
    #1 Kevin, 2006-03-31
    最后编辑: 2006-03-31
  2. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    那就一个语句一行
     
  3. 相当

    相当 New Member

    注册:
    2006-03-28
    帖子:
    9,431
    赞:
    42
    用存储过程吧
     
  4. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    :sweat:
    几千条记录啊!
    我知道你会的,帮一下吧!
     
  5. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    :confused: 不会啊,老大!
     
  6. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    你这东东有啥规律?如果没有,当然只能手工加
     
  7. 相当

    相当 New Member

    注册:
    2006-03-28
    帖子:
    9,431
    赞:
    42
    loop 之类的
     
  8. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    有啊,就是ID从1到1000之类的啊!
     
  9. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    :eek: 程序只会看,然后会改一点,不会写!:cry:
     
  10. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    其中就是ID变化而已,比如从1-----1000
     
  11. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    那邮箱也有规律?
     
  12. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    :eek: 老大你想复杂了,那个邮箱是固定的,不用理的!

    呵呵,看到这里不要笑啦,笨人笨办法!
     
  13. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    WC不要走啊!:cry:
     
  14. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    真的走了~~~~:(
     
  15. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    编辑错了!
     
  16. Kevin

    Kevin New Member

    注册:
    2005-10-23
    帖子:
    12,728
    赞:
    55
    狂查手册,终于知道怎么弄了!