Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import txt-file to mysql DB
It sounds like a permissions thing. For the import, try adding a few more permissions to that user. You can do this through phpmyadmin under privileges. Otherwise try doing it as root. It may also have something to do with file permissions on sql.txt. Try placing the file in / and change... -
Import txt-file to mysql DB
A Newbie? Welcome to the wonderful world of MySQL. There are several ways of importing text into MySQL. The LOAD DATE INFILE mentioned above is a great way to do it. However, if you're new, you are may be wondering how to give SQL commands to the database. There's a couple of ways. First... -
Linked Tables Quicky
I've never seen this done. Were you going to try to link an Access table? The function of linking external data is usually done in the programming language. Microsoft Access has Visual Basic built into it, however mysql is not a programming language by most standards. If you want to use... -
Running multiple queries in Query Browser
QueryBrowser can do more than one statement at a time only in a script. Try File>>New Script Tab.
