Mysql create index fails
up vote
0
down vote
favorite
I am trying to create an index on a mysql table as I have done it before. I am getting an error which says,
Unexpected beginning of statement. (near "badetail" at position 20)
Unexpected beginning of statement. (near "docprofile" at position 30)
Unrecognized statement type. (near "USING" at position 42)
The sql is "CREATE INDEX trd ON badetail (docprofile)"
I am unable to find out the reason for these errors
mysql indexing
edited Nov 8 at 13:02
Cœur
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
add a comment |
up vote
0
down vote
favorite
I am trying to create an index on a mysql table as I have done it before. I am getting an error which says,
Unexpected beginning of statement. (near "badetail" at position 20)
Unexpected beginning of statement. (near "docprofile" at position 30)
Unrecognized statement type. (near "USING" at position 42)
The sql is "CREATE INDEX trd ON badetail (docprofile)"
I am unable to find out the reason for these errors
mysql indexing
edited Nov 8 at 13:02
Cœur
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
2
How aboutALTER TABLE badetail ADD INDEX trd ( docprofile )?
– Raptor
Apr 29 '16 at 6:52
2
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am trying to create an index on a mysql table as I have done it before. I am getting an error which says,
Unexpected beginning of statement. (near "badetail" at position 20)
Unexpected beginning of statement. (near "docprofile" at position 30)
Unrecognized statement type. (near "USING" at position 42)
The sql is "CREATE INDEX trd ON badetail (docprofile)"
I am unable to find out the reason for these errors
mysql indexing
edited Nov 8 at 13:02
Cœur
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
I am trying to create an index on a mysql table as I have done it before. I am getting an error which says,
Unexpected beginning of statement. (near "badetail" at position 20)
Unexpected beginning of statement. (near "docprofile" at position 30)
Unrecognized statement type. (near "USING" at position 42)
The sql is "CREATE INDEX trd ON badetail (docprofile)"
I am unable to find out the reason for these errors
mysql indexing
mysql indexing
edited Nov 8 at 13:02
Cœur
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
edited Nov 8 at 13:02
Cœur
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
edited Nov 8 at 13:02
Cœur
16.8k9101139
edited Nov 8 at 13:02
Cœur
16.8k9101139
edited Nov 8 at 13:02
Cœur
16.8k9101139
16.8k9101139
asked Apr 29 '16 at 6:45
Kallol
63
asked Apr 29 '16 at 6:45
Kallol
63
asked Apr 29 '16 at 6:45
Kallol
63
63
2
How aboutALTER TABLE badetail ADD INDEX trd ( docprofile )?
– Raptor
Apr 29 '16 at 6:52
2
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49
add a comment |
2
How aboutALTER TABLE badetail ADD INDEX trd ( docprofile )?
– Raptor
Apr 29 '16 at 6:52
2
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49
2
2
How about
ALTER TABLE badetail ADD INDEX trd ( docprofile ) ?– Raptor
Apr 29 '16 at 6:52
How about
ALTER TABLE badetail ADD INDEX trd ( docprofile ) ?– Raptor
Apr 29 '16 at 6:52
2
2
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f36931292%2fmysql-create-index-fails%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
2
How about
ALTER TABLE badetail ADD INDEX trd ( docprofile )?– Raptor
Apr 29 '16 at 6:52
2
Is the statement prior to the create index properly terminated? Can you post the full script so that we can see it all - Unrecognized statement type. (near "USING" at position 42) -no using statement appears in Create statement you have posted?
– P.Salmon
Apr 29 '16 at 11:49