Re: group by help?

2002-04-19 Thread Richard Emery
(). If you need to know the internal machinations of mysql, I can only suggest that you study the source code. - Original Message - From: Mick Watson <[EMAIL PROTECTED]> To: Richard Emery <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 7:34 AM Sub

Re: Max 127 records

2002-04-19 Thread Richard Emery
Are you saying that you want a table with a maximum of 127 records ? Or, that due to your TINYINT, you are RESTRICTED to 127 records? If you are restricted to records, change TINYINT to INT. If you want to have ONLY 128 records, change TINYINT to TINYINT UNSIGNED, which will permit records 1 thro

Re: group by help?

2002-04-19 Thread Richard Emery
mysql is acting correctly. GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your SELECT statement makes not such request. You have simply requested the value of a specific field. Data are stored in mysql databases randomly. Therefore, when you request a field's data, you are ge

Re: beginners question

2002-04-15 Thread Richard Emery
show your table structures show us your data show us the commands you used to export the data show us the commands you used to import the data can't read your mind... - Original Message - From: Marcia Clover <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 12:11 PM

Re: Is there a sql query to Copying tables

2002-04-15 Thread Richard Emery
CREATE TABLE new_table SELECT * FROM old_table LIMIT 0; - Original Message - From: Jason <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 10:44 AM Subject: Is there a sql query to Copying tables Is there an easy way to copy/use the structure (not data) of a skele