Re: SQL Q's.

[Micah Yoder <LYoder@cyberis.net>]

Jason Pincin wrote:
> 
> > > 3) How do I insert a row in a table for which the primary key is
> > > auto-incrementing or not auto-inc?
> > When it auto-incs, I believe you can  just leave that field out of your list.
> 
> In some DB's you can leavie it out of the list, but in MySQL you have to
> insert a '' for that field, symbolizing a NULL.

Hmm.  In Postgres, '' is *NOT* the same as NULL.  Are you sure it is in MySQL?


-- 
"But whatever was to my profit I now consider loss for the sake of Christ.
What is more, I consider everything a loss compared to the surpassing
greatness of knowing Christ Jesus my Lord, for whose sake I have lost all
things.  I consider them rubbish, that I may gain Christ." Philippians 3:7-8