().
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
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
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
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
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