mysql question

[illfuuptn]

I want to do a typical

Update table x insert values(1,2,3...)

but I want the 1st value in parentheses to be put in the 30th field column. Then the second in the 31st and so on. It obviously usually defaults to putting the first value in the first column, 2nd in 2nd column, etc.

[MonkeyF0cker]

Is this a serious question?

Uhh. You just answered your own question.

[bink]

UPDATE and INSERT INTO are two different SQL statements. You can't have them in the same query.

So if you're just updating existing rows use UPDATE (ex. UPDATE table SET column=value WHERE otherColumn = someValue) or if you're adding new rows use INSERT INTO (ex. INSERT INTO table (columns) VALUES (values)).

If you're trying to add new columns into an existing table then you'll need to use the ALTER statement (ex. ALTER TABLE table ADD column AFTER column) and then UPDATE the values of the new columns.

[MonkeyF0cker]

Are you incapable of using a search engine?

That's a serious question.

There's no possible way that you could have found that update syntax if you actually bothered looking.

[illfuuptn]

Are you incapable of using a search engine?

That's a serious question.

There's no possible way that you could have found that update syntax if you actually bothered looking.

I actually googled the shit out of it and nothing came up, baby doll.

[MonkeyF0cker]

I actually googled the shit out of it and nothing came up, baby doll.

Nothing came up for "sql update"???

You're kidding, right?

I only get 161,000,000 hits.

[MonkeyF0cker]

How about SQL tutorial??

SQL syntax?

SQL commands?

What on Earth were you searching for?

[illfuuptn]

Maybe you should actually read the whole op, fuhkface.

[MonkeyF0cker]

Maybe you should actually read the whole op, fuhkface.

Uhh. I read your nonsensical post.

So you decided to google imaginary SQL statements instead of trying to read a tutorial and find the actual commands and syntax? Is that what you're saying?

Brilliant.

[strixee]

All right, illfuuptn it's good you have a sense for humor, but better post in PT.

[mikeanite]

atleast you know how it feels to be a newbie and no one wants to help you. been feeling this for awhile

[Maverick22]

I don't see where you read that noone was trying to help him

[mikeanite]

feed him enough cheese to keep him going. if this was in the early 2000's ppl were more willing to share their methods openly cuz they were still trying to learn like the rest of us.

[Maverick22]

Help and hand holding are two different things