DROPPING NO-NAME INDEXes

hi everyone, I made a mistake of not giving a name to an index. alter table sometable add index ( field1, field2 ) I would like to remove this index but I can't figure it out. I tried: alter table sometable drop index (field1,field2) How do I fix this? Thank you. -gohaku -- MySQL General Ma

Replicating Table Schema

Hi everyone, I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. >create table new_table ( select * from table); >delete from new_table; Thanks in advance, -gohaku -- MySQL General Mailing Li

LOAD DATA INFILE from any directory

txt' not found (Errcode: 2) I also started MySQL as follows: mysql --local-infile --user=username databasename Thanks in advance, -gohaku

MySQL Existing with other DBMSes

ome across require experience with Oracle or Sybase. Thank you. -Gohaku -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]