Query Question

2005-10-04 Thread Roy Harrell
10 How do I set up a query whose output would look like this: Tolerance PartA PartB PartC 1 10 12 6 2 11 14 7 3 13 16 7 4 15 16 8 5 18 17 10 Thanks, Roy

RE: Query Question

2005-10-04 Thread Roy Harrell
clearly need more input from Roy. Jacek -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 04, 2005 12:56 PM To: Becla, Jacek Cc: Roy Harrell; mysql@lists.mysql.com Subject: RE: Query Question Jacek, Your method would

Lost Connection to MySQL server during Data Load

2004-10-06 Thread Roy Harrell
I'm trying to import data in a sparsely populated table from a text file. I've attempted this with mysqlimport and the LOAD DATA command. In each case I get an ERROR 2013: Lost connection to MySQL server during query. My tables are InnoDB type and the database is small. I'm running Fedora Linux

Multiple Foreign Keys

2004-07-22 Thread Roy Harrell
Can a child table have multiple foreign key references linking its records to two or more parent tables? Can a parent table also be a child table? That is, can a parent table have a foreign key that links it to another table? I setting up my tables as INNODB types. Thanks, Roy Harrell

Relational Integrity

2004-07-19 Thread Roy Harrell
advice. Sincerely, Roy Harrell Adaptive Equipment 2512 NE 1st Blvd #400 Gainesville, FL 32609 352.372.7821 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]