Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsOtherProgramming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 22nd, 2008, 03:47 AM
sudhakararaog sudhakararaog is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2007
Posts: 11 sudhakararaog User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 4 m 30 sec
Reputation Power: 0
Importing file in php myadmin

presently i have a table in which there are records and the fields are slno (this is a primary key auto increment), firstname, lastname, email, date(which inserts as a date format) these records are presenty being inserting from a html form. this works fine.

i have additional data that is on paper and this paper data needs to be added to this table and the are numerous records that have to be inserted so executing an sql query from myphpadmin is not a good option. due to this i would lke to add the paper data first into a text file or csv file and then use the Import feature in phpyadmin so that this new data is added to the existing table along with the data that is already inserted through the form.

please advice
1. if a text file or csv file is preferrable.
2. in what format should the data be entered in the case of
a) text file & ) csv file

should i mention slno, firstname, lastname, email, date
on top of the file and add data accordingly.

also as slno is auto increment do i need to specify the numeric number or is it optional and in case of date do i need to follow the same format as it is for previous records while entering the data manually into the text or csv file.

thanks.

Reply With Quote
Reply

Viewing: ASP Free ForumsOtherProgramming Help > Importing file in php myadmin


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway