group_ID not accepted

2002-02-12 Thread David S. Jackson
I try to create a table called group. I get an error saying: 'You have an error in your SQL syntax near 'Group (Group_ID TINYINT(3) NOT NULL AUTO_INCREMENT PRIMARY KEY)' at line 1. What's wrong with this? TIA -- David S. Jackson

Re: how do you increment a field on the fly?

2002-02-14 Thread David S. Jackson
ID order by i.Category_ID; My intention was to have the Number field simple be a number that increments by one for each line that prints out. But, of course, the documentation says that's not what the "count" function is for. How can I add a simple little old line count

Premature end of script

2002-01-19 Thread David S. Jackson
his is from the /var/log/apache/error.log file. Any ideas what might be going wrong? TIA. -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Nirvana? That's the place where the powers that be and their friends hang ou

foreign key?

2002-01-25 Thread David S. Jackson
en when I select * in Contributors where Name = "Somebody Lastname"; The values haven't been updated. They remain 0 and 0. What gives? Is this a foreign key problem? TIA. PS. Oh yeah, I'm using mysql 3.22 on debian 2.2.

Re: foreign key?

2002-01-25 Thread David S. Jackson
guous So, looking again at my definitions for Contributor_ID in both tables, I see they aren't exactly alike. Is there a way I can make Contributor_ID in Item refer back to the Index (Contributor_ID) in Contributors? I gather that just making the data types the same is not enough

MySQL undo?

2002-01-27 Thread David S. Jackson
d. Is there any easy way to recover that information? Is there an undo command? -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= You can't have everything. Where would you

printing camera-ready mysql report

2002-01-28 Thread David S. Jackson
Hi, I'm just starting my first MySQL db, and I'm going to want to print out reports from it and produce a camera-ready document. Has anyone done this before, using, say, Star Office or AbiWord or something? TIA. -- David S. Jackson[EMAIL

MySQL and 3NF

2002-01-30 Thread David S. Jackson
ibutors' table handle more than Contact_ID and more than one Volunteer_ID. Don't I want each Contact_ID field for each record to be a single discrete ID number? How would you guys handle this? TIA! -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=