Results 1 to 6 of 6
Jan 20, 2010, 06:21 #1
- Join Date
- Jul 2008
- 1 Post(s)
- 0 Thread(s)
what is the syntax for ordering field ASC/DESC when creating table?
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,
of course not like this...