1
2
3
4
5
6
7
8
9
| mysql --auto-rehash -u root //set up tab completion
select <column_name> from <table_name>;
select <column_name> from <table_name> order by <column_name> ASC/DESC;
(use databases //first) Describe orders; // to show table's columns/fields
// sort data based on statuse
select <column_name> status from <table_name>
order by field(status, <'statuses'>); (in process, on hold, canceled, resolved, disputed, shipped)
// search rows
select <column_name> from <table_name> where <search_condition>;
|