Double entries

2003-08-16 Thread Trevor Morrison
Hi, I am running the latest MySql on a windows 200 machine. I also use the control center gui to do all my work with. I have a Perl program that parses online order data and then using Perl's DBI I write this data to the database. Now, It all works fine except that each order and orders items

MySql Control Center

2003-08-09 Thread Trevor Morrison
Hi, I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a Windows

SQL statement

2003-07-27 Thread Trevor Morrison
HI, I am using the latest MySql on a Windows 2000 platform and connecting to the database using Perl's DBI. All works fine. My question is how best to write a SQL SELECT statement that will extract the data in the format that I want. I have two tables one that contains all the customers informa