Correct format for inserting data using phpMyAdmin?
| From: | Bob Stone | Date: | Wed, 16 Aug 2000 23:16:02 +0000 |
| Subject: | Correct format for inserting data using phpMyAdmin? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-12124@lists.php.net to get a copy of this message | ||
Dear PHP Helpers:
I cannot figure out the proper formatting to insert
data from a text file into a MySQL database using the
phpMyAdmin shell.
I am using php3 running on a remote virtual webserver.
I have a properly function MySQL database and table.
The table is called "employees." It has five fields:
id, first, last, address, position.
I have tried to create a text file that I can insert.
Here is my best guess as to what it should look like,
but I get errors with this and every variation I have
tried:
"6" ; "Molly" ; "Atkinson" ; "6112 Westgate" ;
"Receptionist" ; \n
What am I doing wrong?
TIA
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/