↑
Помогите решить проблему.
У меня есть таблица
Table: order_master_admin
[55 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| timestamp | varchar(100) |
| address_1 | varchar(255) |
| address_2 | varchar(255) |
| bank_acc_hold_name | varchar(50) |
| bank_acc_no | varchar(16) |
| bank_cheque_no | varchar(5) |
| bank_name | varchar(50) |
| bank_route_no | varchar(10) |
| cc_cust_name | varchar(50) |
| cce_month | varchar(2) |
| cce_year | varchar(4) |
| ccno | varchar(16) |
| city | varchar(255) |
| comment | blob |
| country | varchar(255) |
| cvv_no | varchar(3) |
| date_modified | datetime |
| dob | varchar(50) |
| email | varchar(100) |
| fingerprint | varchar(255) |
| first_name | varchar(50) |
| invoice_id | varchar(50) |
| ipaddress | varchar(50) |
| language_id | int(11) |
| last_name | varchar(50) |
| mobile | varchar(255) |
| notify | int(2) |
| notify_date | datetime |
| order_id | varchar(50) |
| order_status_id | varchar(100) |
| order_time | datetime |
| password | varchar(50) |
| payment_address_format | blob |
| payment_mode | varchar(50) |
| payment_status | varchar(50) |
| phone | varchar(255) |
| return_code | varchar(10) |
| return_message | varchar(50) |
| ship_amount | varchar(25) |
| ship_type | varchar(100) |
| shipping_address1 | varchar(50) |
| shipping_address2 | varchar(50) |
| shipping_address_format | blob |
| shipping_city | varchar(50) |
| shipping_country | varchar(50) |
| shipping_firstname | varchar(50) |
| shipping_lastname | varchar(50) |
| shipping_pin | varchar(50) |
| shipping_state | varchar(50) |
| state | varchar(255) |
| total_amount | varchar(100) |
| transaction_id | varchar(100) |
| userid | varchar(50) |
| userlevel | varchar(50) |
| zipcode | varchar(255) |
+-------------------------+--------------+
При дампе мне нужно сдампить только эти поля
| ship_amount | varchar(25) |
| ship_type | varchar(100) |
| shipping_address1 | varchar(50) |
| shipping_address2 | varchar(50) |
| shipping_address_format | blob |
| shipping_city | varchar(50) |
| shipping_country | varchar(50) |
| shipping_firstname | varchar(50) |
| shipping_lastname | varchar(50) |
| shipping_pin | varchar(50) |
| shipping_state | varchar(50) |
И нужно что бы дамп был не с начало в конец,а с конца в начало.
Тоесть там 100к строк,мне нужен дамп с 95К строки как это сделать?
Линейный вид
