How to Upload CSV file in phpMyAdmin of cPanel ?
How to upload CSV file in PHP, my admin?
steps : -
1) open excel file.
2) save as UnicodeText(.txt) format
3) open .txt file and change delimiter ( )tab to any you want.
->we use ||.
Like, pipe(||),comma(,,),etc.
"Note which delimiter you apply that can't be the value of the any field."
4) the first column is a name of the columns
5)in server phpmyadmin open import tab.
File to import:
6)browse that .csv file
-> Character set of the file:utf-16
->Skip this number of queries (for SQL) starting from the first one:1(if u have first columns as a field name) otherwise 0.
Format:
7) CSV
->select if u want to update same data
->Columns separated with: value which u set as delemeter.(in our case ||)
->Columns enclosed with:"
->Columns escaped with:"
->Lines terminated with:auto
Column names: id,sub_category_name,sub_category_details,catId,typeId(our field names)
steps : -
1) open excel file.
2) save as UnicodeText(.txt) format
3) open .txt file and change delimiter ( )tab to any you want.
->we use ||.
Like, pipe(||),comma(,,),etc.
"Note which delimiter you apply that can't be the value of the any field."
4) the first column is a name of the columns
5)in server phpmyadmin open import tab.
File to import:
6)browse that .csv file
-> Character set of the file:utf-16
->Skip this number of queries (for SQL) starting from the first one:1(if u have first columns as a field name) otherwise 0.
Format:
7) CSV
->select if u want to update same data
->Columns separated with: value which u set as delemeter.(in our case ||)
->Columns enclosed with:"
->Columns escaped with:"
->Lines terminated with:auto
Column names: id,sub_category_name,sub_category_details,catId,typeId(our field names)
Comments
Post a Comment