cancel
Showing results for 
Search instead for 
Did you mean: 

Failure to upload data file to mysql admin

MikeM9856
Newbie
Posts: 5
Registered: ‎26-01-2008

Failure to upload data file to mysql admin

Hi!, I'm new to mysql via PlusNet (about a week) and everything is good
using mySQL AB tutorials except I have'nt managed to upload a file to mysql admin yet. Unfortunately I've ended up using many permutations and seem to have got in a mess and I can't see why I've failed to upload
the data file (I saved the file as ANSI should it be UTF-8?).
This is the basic data, please spell out the answer please as I've lost myself on this bit,
Fluffy Harold cat f 1993-02-04 Null
Claws Gwen cat m 1994-03-17 Null
Buffy Harold dog 1989-05-13 Null
Fang Benny dog m 1990-08-27 Null
Bowser Diane dog m 1979-08-31 1995-07-29
Chirpy Gwen bird f 1998-12-09 Null
Whistler Gwen bird 1997-12-09 Null
Slim Benny snake m 1996-04-29 Null
I simply want to upload as a data file using notepad via mysql admin.
Any future queries will be shorter!. Thanks, Best regards MikeM9856
2 REPLIES 2
Peter_Vaughan
Grafter
Posts: 14,469
Registered: ‎30-07-2007

Re: Failure to upload data file to mysql admin

Use this format replacing <tablename> with the name of the rable,  fieldname with actual field names and text with the data you want to insert into the relevant field:
insert into <tablename> ('fieldname1', 'fieldname2', 'fieldname3') VALUES
('text1','text2','text3'),
('text1', 'text2', 'text3')
;
Or if it is just a few lines, use the MySQL Admin to add the necessary info manually. Just select the table then use the insert tab.
MikeM9856
Newbie
Posts: 5
Registered: ‎26-01-2008

Re: Failure to upload data file to mysql admin

Peter
Thanks for the pointers, particularly insert.
Thanks, Mike