example

Code MySQL:
 
CREATE TABLE sample_table (
  field_one VARCHAR DEFAULT NULL,
  field_two INT UNSIGNED DEFAULT NULL,
  .
  .
  .
  . )TYPE=MyISAM

I want 'field_two' to order by ASC/DESC

instead of alter table order AFTER creating the table in phpMyAdmin,



how to explicitly order any field ASC/DESC while creating table?

CREATE TABLE sample_table (
field_one VARCHAR DEFAULT NULL,
field_two INT UNSIGNED DEFAULT NULL ORDER BY ASC,
.
.
.
. )TYPE=MyISAM

??

of course not like this...