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 t
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 t
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
- 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
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|
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?
---
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.
T
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.
