simple question on WHERE SELECT query

There is a particular form of SQL query you can use I believe when you are adding data to a table and want to include an ID number from another lookup table but you only know the name reference and not the ID eg it might be an "author" table with an author_id and author_name and you want to enter

files stored in fields

Please excuse a very simple inquiry from a near beginner If I wish to store a complete Word file or similar (Open Office perhaps) or an archive file - is that possible and what kind of field do I need for it? How do you insert a file into a table if so? I know that you can store pictures - what

Re: ERROR ON INSERT DATA FROM FILE

Thanks for the answer - but I am already the root user and have phpMyAdmin using the root also (because this is just a single computer for testing work and there are not any bit security issues). - Original Message - From: "Remi Mikalsen" <[EMAIL PROTECTED]> To:

ERROR ON INSERT DATA FROM FILE

I just tried to load edited data from a text file separated by | characters into a table in a simple data base I was using PhpMyAdmin version 2.5.6 and MySQL 4.0.18 running on Windows XP - I thought it was all set up right and configured properly - and earlier was able to populate the table with

Problem with data import from text file

see that I am doing anything different. I have MySQL 4.0.12 on Windows ME PC with a local Apache server and PHP. Any ideas please? Regards Adrian Greeman PS I sent a long message about this and a connection problem yesterday which was not succint enough. Apologies -- MySQL General Mailing Li

Subject: Re: Problem with data import from text file (part two) Thanks

those more knowledgeable. Regards Adrian Greeman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with data import from text file (part two)

gards Adrian Greeman please also send a separate smaller message to tell me the other one is coming. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with data import from text file

file? I do not know how to do that. Can someone explain what is probably a very simple matter or is something still not happening correctly? Or should I revert to version 3 for my fairly simple training purposes? I am puzzled because previously this did work. Thank you. Regards Adrian

Can't start up - access denied to root

I am fairly much a beginner and have probably done something wrong but version 4.0.12 will not let me in. I have been using MySQL (via MySQL Front and PHPMyAdmin as interfaces usually) on a Windows ME PC with Apache, all just for learning databases, SQL and PHP. I learn slowly since I have to do a

winSQLadmin stopped on Beta

son why > WinSQLadmin will not pull running information out of the beta version > > > > > Thanks > > > > > Regards > > > Adrian Greeman > > - Before posting, please check: http://www.mysq

winadmin stopped on Beta

elp - what might I have done wrong? Or is theresome reason why WinSQLadmin will not pull running information out of the beta version Thanks Regards Adrian Greeman Telephone +44 20 8672 9661 Mobile +44 780 329 7447 e-mail:- [EMAIL PROTECTED] or [EMAIL