load data local infile problems

2001-11-17 Thread Saqib Shaikh
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 PROTECTED] Web site: http

loading data into a table and 1-many relations

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

currency: which data type?

2001-11-12 Thread Saqib Shaikh
and 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.saqibshaikh.com

Re: how to get a script to run/work

2001-11-11 Thread Saqib Shaikh
with: c:\mysql\scripts mysql -t -vvv pets.mysql pets.out I have only started using MySQL and only run it on a stand-alone system. 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

Create Table

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