load data local infile problems

2001-11-17 Thread Saqib Shaikh
affected (0.00 sec) Records: 29 deleted: 0 Skipped: 29 warnings: 0 I cannot seem to find any consistancy in MySQL's behaviour. This is an extremely annoying problem! If anyone out there can help then please do contact me. Thanks in advance. Regards, Saqib Shaikh Email: [EMAIL PROTE

loading data into a table and 1->many relations

2001-11-13 Thread Saqib Shaikh
now 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

currency: which data type?

2001-11-12 Thread Saqib Shaikh
that decimal or numeric would be more appropriate. I only used double(4,2) because this is what is used in the MySQL tutorial (I think it's chapter 3 of the manual). Any thoughts on this matter appreciated. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqib

Re: how to get a script to run/work

2001-11-11 Thread Saqib Shaikh
em. If you are designing a database for a web site etc then you may need to provide extra parameters like the hostname. Hope this helps. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ - Original Message - From: "Barbara Ferrell" <[EMAIL

Create Table

2001-11-10 Thread Saqib Shaikh
l having difficulties getting other tables to work. Hopefully the answer to this question may shed some light on my difficulties. Thanks very much in advance. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ -