INSERT record like FETCH_ASSOC?

#11

On 9/17/2011 10:36 AM, Erick T. Barkhuis wrote:

Quote:

Jerry Stuckle:

On 9/17/2011 3:24 AM, Erick T. Barkhuis wrote:
Mike:

On Fri, 16 Sep 2011 09:07:20 -0400, Mike<no_please (AT) not (DOT) com
wrote:

I need a way to insert a "registered" user's information in a
database by field name? ... I want to insert by knowing field
names but not order.

My version is 5.0.92-community. Which manual would I download?

Hi Mike,
You would probably want the INSERT...SET...-syntax
http://dev.mysql.com/doc/refman/5.0/en/insert.html

Which is not standard SQL and not a good thing to use.

I like to use the good things MySql has to offer. This is one of them.

You can do it with standard SQL, though.

...but you don't want to tell anyone how that works. You'd rather wait
for the thread to escalate, then throw in some valuable insults.

Nope. I told him how to find it.

Tell the person an answer and he'll be back next time he has a question.
Teach him to be able to find it for himself and he'll be productive.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#12

On 9/17/2011 11:23 AM, The Natural Philosopher wrote:

Quote:

Erick T. Barkhuis wrote:
Jerry Stuckle:

On 9/17/2011 3:24 AM, Erick T. Barkhuis wrote:
Mike:

On Fri, 16 Sep 2011 09:07:20 -0400, Mike<no_please (AT) not (DOT) com
wrote:

I need a way to insert a "registered" user's information in a
database by field name? ... I want to insert by knowing field
names but not order.

My version is 5.0.92-community. Which manual would I download?
Hi Mike,
You would probably want the INSERT...SET...-syntax
http://dev.mysql.com/doc/refman/5.0/en/insert.html

Which is not standard SQL and not a good thing to use.

I like to use the good things MySql has to offer. This is one of them.

You can do it with standard SQL, though.

...but you don't want to tell anyone how that works. You'd rather wait
for the thread to escalate, then throw in some valuable insults.

Natch. Jerry doesn't actually KNOW anything. Except how to turn on error
reporting and how to turn off people.

So says the stoopid troll who never has contributed anything useful to
this or any other usenet group. That's because he's not a programmer
(or the engineer he claims to be) - just an out of work ditch digger who
got fired because he couldn't figure out which end of the shovel to use.

But that's why he tries to hide behind a 'nym - he's terrified to have
anyone find out just how stoopid he really is.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#13

On 17-09-2011 20:06, Jerry Stuckle wrote:

Quote:

On 9/17/2011 11:23 AM, The Natural Philosopher wrote:

So says the stoopid troll who never has contributed anything useful to
this or any other usenet group. That's because he's not a programmer (or
the engineer he claims to be) - just an out of work ditch digger who got
fired because he couldn't figure out which end of the shovel to use.

But that's why he tries to hide behind a 'nym - he's terrified to have
anyone find out just how stoopid he really is.

why are you making the previous statement of TNP become true?

Quote:

Jerry doesn't actually KNOW anything. Except....how to turn off people.

Jerry,
If you really think/know/feel that there is some ignorance in the words
of anyone who is replying to you, than i would suggest to you that you
do not reply. This will save a lot of useless posts in this group

After all, YOU are the guy with the most experience! i Hope this also
takes into account life-experiance, and not yust some RDBMS-stuff....

--
Luuk

#14

On 9/17/2011 2:17 PM, Luuk wrote:

Quote:

On 17-09-2011 20:06, Jerry Stuckle wrote:
On 9/17/2011 11:23 AM, The Natural Philosopher wrote:

So says the stoopid troll who never has contributed anything useful to
this or any other usenet group. That's because he's not a programmer (or
the engineer he claims to be) - just an out of work ditch digger who got
fired because he couldn't figure out which end of the shovel to use.

But that's why he tries to hide behind a 'nym - he's terrified to have
anyone find out just how stoopid he really is.

why are you making the previous statement of TNP become true?

Jerry doesn't actually KNOW anything. Except....how to turn off people.

Jerry,
If you really think/know/feel that there is some ignorance in the words
of anyone who is replying to you, than i would suggest to you that you
do not reply. This will save a lot of useless posts in this group

After all, YOU are the guy with the most experience! i Hope this also
takes into account life-experiance, and not yust some RDBMS-stuff....

Just calling a stoopid troll exactly what he is.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#15

Luuk wrote:

Quote:

On 17-09-2011 20:06, Jerry Stuckle wrote:
On 9/17/2011 11:23 AM, The Natural Philosopher wrote:

So says the stoopid troll who never has contributed anything useful to
this or any other usenet group. That's because he's not a programmer (or
the engineer he claims to be) - just an out of work ditch digger who got
fired because he couldn't figure out which end of the shovel to use.

But that's why he tries to hide behind a 'nym - he's terrified to have
anyone find out just how stoopid he really is.

why are you making the previous statement of TNP become true?

Because he is Soo stoopid, and utterly predictable.
And making Stuckle traps is at least as much fun as MySQL.

Quote:

Jerry doesn't actually KNOW anything. Except....how to turn off people.

Jerry,
If you really think/know/feel that there is some ignorance in the words
of anyone who is replying to you, than i would suggest to you that you
do not reply. This will save a lot of useless posts in this group

After all, YOU are the guy with the most experience!

Bwahaha.

i Hope this also

Quote:

takes into account life-experiance, and not yust some RDBMS-stuff....

Not much evidence of either..
He MIGHT have been a common (or garden) coder a long time ago before he
set up his failed training company.

>