phil speakman Posted October 27, 2003 Share Posted October 27, 2003 Is there any easy way of importing quite alot of data into a mySql database using myPhpAdmin - as it appears i have to type it all in, and i really hope i don\'t have to.. Phil Quote Link to comment Share on other sites More sharing options...
shivabharat Posted October 27, 2003 Share Posted October 27, 2003 If you are using windows you can get yourself SQLYOG a GUI based toolw hich can help you a lot. See this http://www.phpfreaks.com/sqlyog/ But this tool isnt a freeware. ------------ To import data Go to the structure TAB click on Insert data from a textfile into table choose whihcever is appopriate. If you are using CSV (comma separted values) Fields terminated will be : , Fields enclosed by: \" (if applicable( Lines terminated by: n Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.