Hi, I'm having a problem as follows:
In my database (which just needs to work rather than be of commercial quality) I have an orders table. Each order contains an order number and a reference to ordered_items. Ordered_items table contains things like the name of the product and the price. Now obviously the orders->ordered_items link is a 1-to-many relationship since in any one order I should be able to order 5 different items. At the moment I am using: load data local infile "orders.txt" into table orders; to load the data. However, using this method I don't know how to enter say 10 ordered_item IDs into the tab-separated table contained in orders.txt. I'm sure that people on this list must make similar databases every day, and some basic help would be much appreciated. Regards, Saqib Shaikh --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
