MOSSCon in Louisville in May! Submit your proposal this week!

2013-03-27 Thread John List
You are invited to be a speaker/presenter at MOSSCon. Preparations are in full swing for the very first Midwest Open Source Software Conference (MOSSCon), to be held in Louisville on May 18-19. Your help in spreading the word and helping us fill out our schedule of presentations and workshops

Re: Need Help Writing Simple Query

2010-07-25 Thread John List
On 07/25/2010 09:29 PM, Mark Phillips wrote: I have been away from sql for awhile, and can't seem to figure out how to write a simple query for two tables. Table 1 has many columns, two of which are hID and vID. Table 2 has two columns, ID and name. The hID and vID in table 1 correspond to the

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

2010-02-01 Thread John List
On 02/01/2010 06:38 PM, kebede teferi wrote: Hi, I'm very new to this and I need help. What I want to do is to execute a source command statement from cmd to create tables and populate them on a data base that I created in Mysql. Here is what I did at CMD: *I changed the directory from c:\

Re: Is there a better way than this?

2009-12-27 Thread John List
On 12/27/2009 06:04 PM, Tim Molter wrote: I'm new to MySQL and I'm looking for some guidance. I have a table A, with two columns X and Y with the following data: | X|Y| 1 24 1 25 2 25 2 26 3 27 I want my SQL query

Re: Temp file issues on Ubuntu 9.10

2009-11-08 Thread John List
Sebastiaan van Erk wrote: Hi all, I just recently upgraded to Ubuntu 9.10, but now I'm having all sorts of temp file problems. For example, when I try to delete a row and violate a contraint I get: ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails