Embarrassingly simple answer to the question why I didn't just use a View ...
I haven't gotten to that chapter in the manual yet.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
John,
> 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.
Have you not been reading what everyone said?
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.
--
MySQL General Mailing List
For list archives: http://lists
> > >Question 2: If not, what would the Insert/Select statement look like
that
> > would copy the records over in sorted order?
> >
> >
> > Tables aren't sorted. Period.
> >
> >
> >
> > Only result-sets can be sorted.
>
> While that is true, strictly speaking, packing data into the same
> physic
> >Question 2: If not, what would the Insert/Select statement look like that
> would copy the records over in sorted order?
>
>
> Tables aren't sorted. Period.
>
>
>
> Only result-sets can be sorted.
While that is true, strictly speaking, packing data into the same
physical order as you expect to
In the last episode (Aug 15), Martijn Tonies said:
> >I have a table with 1600 student locks in random order. I would like
> >them permanently sorted by the locker number they are assigned to. I
> >assumed that ...
> >
> >~ I would copy the table under a different name
> >~ Delete all records from
John,
>I have a table with 1600 student locks in random order. I would like them
permanently sorted by the locker number they are >assigned to. I assumed
that ...
>
>~ I would copy the table under a different name
>~ Delete all records from this copy
>~ Write a statement that would copy the recor
On Wed, August 15, 2007 13:09, Kebbel, John said:
> I have a table with 1600 student locks in random order. I would like them
> permanently sorted by the locker number they are assigned to. I assumed
> that ...
>
> ~ I would copy the table under a different name
> ~ Delete all records from this co
