UBB.Developers Forums Announcements Announcements Anyone running 6.4

  mysql> SHOW KEYS FROM w3t_Last;<br />+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+<br />| Table    | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment |<br />+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+<br />| w3t_Last |          1 | Last_indx |            1 | L_Board     | A         |           6 |     NULL | NULL   |         |<br />| w3t_Last |          1 | Luid_ndx  |            1 | L_Uid       | A         |           6 |     NULL | NULL   |         |<br />+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+---------+<br />2 rows in set (0.00 sec)<br />

mysql> DELETE FROM w3t_Last<br />    -> ALTER TABLE w3t_Last<br />    -> ADD PRIMARY KEY Last_index(L_Uid,L_Board);<br />ERROR 1064: You have an error in your SQL syntax near 'ALTER TABLE w3t_Last<br />ADD PRIMARY KEY Last_index(L_Uid,L_Board)' at line 2<br />