I have a MySQL table who I would like to have on my ·G 16GB I-phone. The table has almost 3 million records ( about 600 MB) with about 15 fields.
I want to have a full search of the table ( an open search )or any particular field, if some records match the search I would like to browse the records and select the exact record who I want and this search need to take me to the screen with all the information of the record.
I have an "MySQL table" with almost 3 million records and a total size of aprox 600MB.I would like to have this DATABASE on my Iphone 16GB 3G. The table has 15 fields. ( name , age, sex, address, phone1, phone2, income, job, ID, State, City, County, etc.)
I also wants to have a "full search" capabilities of the table ( an open search )on any particular field. If some records match the criteria, I would like to browse the records by name , address and age.
When I found the exact match record. I would like to have an screen with all the information available.