Consider the ff. table:
++--+--+
| game | rank | date |
++--+--+
| GTA| 11 | 20081001 |
++--+--+
| SPORE | 1 | 20081103 |
++--+--+
| SPORE | 2 | 20091001 |
++--+--+
| SINSOL |
[EMAIL PROTECTED] wrote:
Hi Andy,
Two questions for you:
1) Why store so many repeatable data in the same table?
I mean you needn't to store purchases/previews for all records.
You can choose MySql SET datatype, or you can choose another table to
store the action types and let the original
I have a table that is roughly like the below:
id - PK, autoincremented integer
name - varchar
visit- timestamp
action - char(10)
Now, 'action', while a char(10), is only ever intended
to contain two possible values, purchase and
preview.
The table might end up containing tens
The volume on this list is so big that it desperately
needs to be available as a newsgroup. I was able to
find one on Google groups as mailing.database.mysql but
does anyone know of a publicly available NNTP server
which carries this?
mysql CREATE TABLE X (FLD1 INT UNIQUE);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE X;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| FLD1 | int(11) | YES | MUL | NULL|
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Andy Sy [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 2:45 AM
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
At 2:03 +0800 6/14/02, Andy Sy wrote:
mysql CREATE TABLE X (FLD1 INT UNIQUE
Strange, there shouldn't be any difference between MySQL
query behaviour under Win2K or Linux or BSD or Win98. It
could be more to do with the version of MySQL you are
using.
- Original Message -
From: bob [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 3:18 AM
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.