Howdy,

What does "MUL" mean in MySQL for the key?

How does it get created when the create procedure doesn't state this?

I see that it has something to do with it being "indexed", but what does it mean/do?

I'm guessing maybe "multiple" instances?

Any insight would be appreciated...

Thanks, Bill

Where is it you are finding that "MUL"??

I don't find that in the online docs anywhere??

Edit: This explains it

Regards,

Brett Harris
Infopop Corporation

It's not from the documentation...this is a question from which I see in the actual MySQL table structure.

Here is a snipped of the w3t_Posts table to show you:

<pre>
[PRE]

mysql> describe w3t_Posts ;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| B_Board | varchar(100) | | MUL | | |
| B_Number | int(11) unsigned | | PRI | NULL | auto_increment |
| B_Parent | int(11) unsigned | | MUL | 0 | |
| B_Main | int(11) unsigned | | MUL | 0 | |
| B_Posted | int(11) unsigned | | MUL | 0 | |
| B_Last_Post | int(11) unsigned | | | 0 | |
| B_Username | varchar(30) | | MUL | | |
| B_IP | varchar(60) | YES | | NULL | |
| B_Subject | text | YES | | NULL | |
| B_Body | text | YES | | NULL | |
| B_Mail | int(1) unsigned | YES | | NULL | |
| B_File | varchar(100) | YES | | NULL | |
| B_Kept | char(1) | | | | |
| B_Status | char(1) | | MUL | | |
| B_Approved | char(3) | | MUL | yes | |
| B_Picture | varchar(100) | YES | | NULL | |
| B_Icon | varchar(30) | YES | | NULL | |
| B_Color | varchar(10) | YES | | NULL | |
| B_Reged | char(1) | YES | | y | |
| B_UTitle | varchar(50) | YES | | NULL | |
| B_Counter | int(9) unsigned | YES | | 0 | |
| B_Sticky | int(11) unsigned | YES | | NULL | |
| B_Replies | int(4) unsigned | YES | | 0 | |
| B_Poll | varchar(200) | YES | | NULL | |
| B_ParentUser | varchar(20) | YES | | NULL | |
| B_UStatus | char(1) | YES | | NULL | |
| B_Topic | int(1) unsigned | | | 0 | |
| B_Convert | varchar(10) | YES | | markup | |
| B_Signature | text | YES | | NULL | |
| B_LastEdit | int(9) unsigned | YES | | NULL | |
| B_LastEditBy | varchar(64) | YES | | NULL | |
| B_PosterId | int(9) unsigned | | MUL | 0 | |
| B_Rating | varchar(5) | YES | | 0 | |
| B_Rates | int(4) | YES | | 0 | |
| B_RealRating | int(1) | YES | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
35 rows in set (0.00 sec)
[/PRE]
</pre>

I used this table as the example because it has the most instances of the "MUL" key in it, although others do too.

Cheers, Bill

My best guess is that these are the indicies created by the configuration scripts as they look like this:

quote:

---

// The Posts Table ###################

$index1 = "w3t_Posts"."index1";
$index2 = "w3t_Posts"."index2";
$index3 = "w3t_Posts"."index3";
$index4 = "w3t_Posts"."index4";
$index5 = "w3t_Posts"."index5";
$index6 = "w3t_Posts"."index6";
$index7 = "w3t_Posts"."index7";
$index8 = "w3t_Posts"."index8";
$index9 = "w3t_Posts"."index9";
$index10= "w3t_Posts"."index10";
$indexes = "";
if ($config['dbtype'] == "mysql") {
$indexes = ", INDEX $index1 (B_Parent,B_Board),
INDEX $index2 (B_Number, B_Board), INDEX $index3 (B_Main, B_Board),
INDEX $index4 (B_Status,B_Board),
INDEX $index6 (B_Board),
INDEX $index7 (B_Approved,B_Board),
INDEX $index8 (B_Posted, B_Board),
INDEX $index10 (B_Board(10),B_Topic),
INDEX ID_ndx(B_PosterId),
INDEX poster_ndx(B_Username)
";

---

So - I presume that MUL is for Multiple columns - if this were version 6.0.2 I suspect that the Key you would see on the B_username column would be called poster_ndx

Does that help? Again, I am not 100% certain and I am dredging MySQL books for the answers.

Regards,

Brett Harris
Infopop Corporation

FWIW, I would agree with Brett.

However, all I could find was:
http://www.mysql.com/doc/M/u/Multiple-column_indexes.html

Graeme

Moderator: UBB6 How Do I?

NOTE: Any email requests for support will be ignored.

"The ships hung in the sky in much the same way that bricks don't." --Douglas Adams

Thanks for the insight...

I will have a look at the URL too

Also, I figured out that the Quote is what I was looking for , I was trying to use PRE

Cheers, Bill