Wordpress Very advance question for coder

Discussion in 'WordPress' started by ironmankho, Jun 25, 2010.

  1. #1
    Wordpress Very advance question for coder/developer

    i am try to update a post from sql query ..

    below query generated form wordpress

    INSERT INTO `wp_posts` VALUES(5, 1, '2010-06-25 23:31:40', '2010-06-25 23:31:40', '', 'game title ', '', 'publish', 'open', 'open', '', 'game-title', '', '', '2010-06-25 23:31:40', '2010-06-25 23:31:40', '', 0, 'http://localhost/wp/?p=5', 0, 'post', '', 0);
    Code (markup):
    now i simple change 5 into 6(it is auto increment )

    INSERT INTO `wp_posts` VALUES(6, 1, '2010-06-25 23:31:40', '2010-06-25 23:31:40', '', 'game title ', '', 'publish', 'open', 'open', '', 'game-title', '', '', '2010-06-25 23:31:40', '2010-06-25 23:31:40', '', 0, 'http://localhost/wp/?p=6', 0, 'post', '', 0);
    Code (markup):
    nothing happened :confused:

    i have 5 million record of article to update . i am developing a tool that code sql query for updating wordpress from back end database no mess with wordpress !!!
    i am expert in joomla doing same job successfully but failed in wordpress

    please no advice for me using CSV impoter (i already know that)
     
    Last edited: Jun 25, 2010
    ironmankho, Jun 25, 2010 IP
  2. bhuthecoder

    bhuthecoder Member

    Messages:
    245
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    43
    #2
    use SQL UPDATE for incrementing id value
     
    Last edited: Jun 26, 2010
    bhuthecoder, Jun 26, 2010 IP