[SOLVED] INSERT, WHERE?

[Michdd]

Is there a proper MySql function that is INSERT WHERE? If so, can someone please give me the syntax?

[PFMaBiSmAd]

These are the available INSERT statements -

 

12.2.4. INSERT Syntax

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [iGNORE]

    [iNTO] tbl_name [(col_name,...)]

    {VALUES | VALUE} ({expr | DEFAULT},...),(...),...

    [ ON DUPLICATE KEY UPDATE

      col_name=expr

        [, col_name=expr] ... ]

 

Or:

 

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [iGNORE]

    [iNTO] tbl_name

    SET col_name={expr | DEFAULT}, ...

    [ ON DUPLICATE KEY UPDATE

      col_name=expr

        [, col_name=expr] ... ]

 

Or:

 

INSERT [LOW_PRIORITY | HIGH_PRIORITY] [iGNORE]

    [iNTO] tbl_name [(col_name,...)]

    SELECT ...

    [ ON DUPLICATE KEY UPDATE

      col_name=expr

        [, col_name=expr] ... ]

 

INSERT inserts new rows into an existing table. There is no WHERE clause. What exactly are you trying to accomplish?

 

 

[Michdd]

Nevermind, I'm using the UPDATE function, I thought that UPDATE wouldn't work at first because I tried it and it wasn't working, but I noticed I was using a null variable, on accident. Thanks for your help