vb.org Archive - Need More Help Un-Doing Query

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Need More Help Un-Doing Query (https://vborg.vbsupport.ru/showthread.php?t=93506)

Marco van Herwaarden

08-03-2005 07:06 AM

Correct

dieselpowered

08-03-2005 07:08 AM

Hmmm says it cannot drop:

ALTER TABLE user DROP INDEX ratetradetotal;

Nevermind, looks like when I dropped the first one, it dropped the second?? Would it have done that?

Colin F

08-03-2005 07:41 AM

Quote:

Originally Posted by xtremeoff-road

Hmmm says it cannot drop:

ALTER TABLE user DROP INDEX ratetradetotal;

Nevermind, looks like when I dropped the first one, it dropped the second?? Would it have done that?

I don't know MySQL that well, but I'd say that's possible, as it's an index on the table and doesn't make sense to keep that if the table itself isn't around anymore.

Marco van Herwaarden

08-03-2005 08:06 AM

Yes, the index is based on that column, so if you drop the column the index also get dropped.

dieselpowered

08-03-2005 03:23 PM

WOOHOO I am an SQL genious!!! :)

Thanks guys for taking the time to help...have a great one!

All times are GMT. The time now is 08:43 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01631 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: