OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Recreate Table With Sorted Data

From: Chris Boget (chris.bogetwild.net)
Date: Thu Aug 16 2007 - 04:51:22 CDT


> The solution was CREATE TABLE copyname SELECT * FROM originalname
> I was having problem with a PHP command that's not pulling what I want
> from the table Ruling out random order for the rows was narrowing the
> focus on the PHP problem.

Why not just create a VIEW and leave your original table alone?

thnx,
Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql