Sure, just don't include it in the list of columns to bring back. SELECT column1, column2 FROM ...
instead of SELECT * FROM... or SELECT columnIDoNotWant, column1, column2 FROM ... On Friday 12 April 2002 3:29 pm, Thi Cao wrote: > Can I hide the auto_increment field? > > -----Original Message----- > From: Gregory Junker [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 5:23 PM > To: MySQL > Subject: RE: MySQL concept question > > > if you are interested in selecting records in the order in which they > were inserted, apply an auto-increment/identity field to your table > schema and when you select, use ORDER BY on that field. This is the only > guaranteed way to retrieve records in the order in which they were > inserted. > > > -----Original Message----- > > From: Thi Cao [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 11, 2002 6:09 PM > > To: MySQL > > Subject: MySQL concept question > > > > > > All, > > > > When I insert records into a database, the records will be > > inserted in the > > order that I have them listed in my insert statement. So my > > question is, > > will the MySQL database always return the records in the > > order of insertion > > when I perform any type of select query in the future? Of course, I'm > > excluding queries that specify an order with the 'ORDER BY' > > clause. Does > > the MySQL database maintain some type of internal ordering ID for each > > record, and if so, can I always rely on the database to give > > me the records > > back as I have given to it? I know I can specify an order by having a > > column with some type of ordering value, but that's not what > > I'm interested > > in, so any answers to the above questions would be much appreciated. > > > > T.I.A. > > > > Thi > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php