Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Merging data into a table....

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-09-06, 22:46
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
Merging data into a table....
OK, I created a table with phpmyadmin...

I recently just received an excel database, 50 rows 6 columns (not huge...)
and now I want to be able to import the tab delimated database into the
existing table. I have the column names matching in both...but I can't find
an easy way to just import the database...... please tell me there is an easy
way to do it, without having to input each row by hand...
Reply With Quote
  #2 (permalink)  
Old 05-10-06, 00:26
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
dunno if this is true in all versions of phpmyadmin, but ....

click on the table in the left pane

on the resulting display in the right pane, you see the fields, then the indexes, then the SQL box, then location of textfile (for sql), and at the very bottom, a link that says Insert data from a textfile into table

click on that and fill in the detials
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 05-10-06, 09:16
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
hmmm.... I couldn't find anything like that. Do you kno what version you are looking at? I am running 2.7.0-pl2....
Reply With Quote
  #4 (permalink)  
Old 05-10-06, 09:21
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
i'm on phpMyAdmin 2.6.0-pl3

i doubt they'd've removed that feature in a later release

keep looking, you'll find it
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 05-10-06, 09:23
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
is it possible to take a couple of screen shots? The closest thing that I found didn't give me an option to choose my file...
Reply With Quote
  #6 (permalink)  
Old 05-10-06, 09:34
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
here ya go...
Attached Thumbnails
Merging data into a table....-screenshot.gif  
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #7 (permalink)  
Old 05-10-06, 10:13
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
OK, I found the page closest resembling that...however, there is no bottom section (Or Location of the textfile...doesn't exist, nor anything below that line)... I also doubt that they would have removed it, the site is being hosted on godaddy.com, do you think it would be some type of permissions or something? I have full access to everything else...
Reply With Quote
  #8 (permalink)  
Old 05-10-06, 10:32
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
it'll be there somewhere, keep looking

they wouldn't just remove an option like that

no, it's not a permissions thing, if you can see the table and run queries on it

do you at least have a left pane that lists your tables? show the screenshot of what you get when you click on one of those tables
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #9 (permalink)  
Old 05-10-06, 10:47
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
yes, i have the left pane, and the tabs that you spoke of.... below is a screenshot:

Merging data into a table....-picture-1.png


thoughts?
Last edited by lukeMV; 05-10-06 at 21:17.
Reply With Quote
  #10 (permalink)  
Old 05-11-06, 07:02
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
have a look at the bottom of the Structure tab
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Last edited by r937; 05-11-06 at 07:06.
Reply With Quote
  #11 (permalink)  
Old 05-11-06, 09:49
lukeMV lukeMV is offline
Registered User
  
Join Date: Apr 2005
Posts: 46
Merging data into a table....-picture-2.png

Bottom of structure tab.... no dice.

Does anyone know of actual mySQL code that could be run from here to do this action?
Reply With Quote
  #12 (permalink)  
Old 05-11-06, 10:06
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
sure, LOAD DATA INFILE
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #13 (permalink)  
Old 05-17-06, 06:02
DEkart DEkart is offline
Registered User
  
Join Date: Jun 2003
Posts: 13
You can try to use such tool as Data Import for MySQL.

http://www.sqlmanager.net/products/mysql/dataimport
Last edited by DEkart; 05-17-06 at 06:12.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.