[pfyon]

And here's the error reported by the editor:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range, aoerange, pushback, pushup, cast_time, recovery_time, recast_time, buffdu' at line 1

When I put backticks (`) around 'range' from the query you posted earlier in this thread, it works.

edit: also, not exactly sure what you mean by blind inserts, but if I use

mysql> insert into blind values (1,'test','test',1);
Query OK, 1 row affected (0.24 sec)

with table

mysql> show columns in blind;
+-------+------------------+------+-----+---------+----------------+
| Field | Type             | Null | Key | Default | Extra          |
+-------+------------------+------+-----+---------+----------------+
| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| col1  | varchar(45)      | NO   |     | NULL    |                |
| col2  | varchar(45)      | NO   |     | NULL    |                |
| col3  | int(10) unsigned | NO   |     | NULL    |                |
+-------+------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

It works fine.

mysql> select * from blind;
+----+------+------+------+
| id | col1 | col2 | col3 |
+----+------+------+------+
|  1 | test | test |    1 |
+----+------+------+------+
1 row in set (0.00 sec)

There's probably a better way to auto insert the index, though.