Populating new custom user fields

Author: mike     03 14th, 2010 in sbbbs.com     edit

  • vB2 added custom user fields as a new table.

    How can I import my old custom user fields (created in the user table) into the user fields table?


  • I probably was too breif, or not sure if MySQL works in rows, but not in columns? I'm green in SQL.

    Here's what I had in vb1, my user table had 3 columns for start weight, current weight anf goal weight (diet forum).

    After upgrading to vb2, the columns are still there in the user table, but now vb2 reads such information from userfields table fields1 to filed4, and you can add from control panel customized fields.

    Is there an SQL statement I can use from phpMyAdmin, to copy the 3 columns from the user table, to new columns in the userfields table as fields 5-7?


  • After several trials with MySQL queries, I think I found why I can't do it.

    Unlike ORacle MySQL does not allow SELECT inside an UPDATE statement like this:


    update userfield set userfield.field5, userfield.field6, userfield.field7 (select user.wgtstart, user.wgtcurrent, user.wgtgoal from user where userfield.userid = user.userid);


    Can MySQL gurus confirm this, and are there any work-arounds to do this?







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Populating new custom user fields , Please add it free.

    Characteristics of Adult Bully Targets China Portfolio Insurance