Posts by Reverend Jim

I thought it would be as simple as

DROP INDEX index_name ON table_name;

As for removing only unused indexes, I don't know how MySql would be able to determine if an index is used, or not. You'd have to decide. Since indexes are used to find things quickly I would imagine that if you delete an index and then take a performance hit it's likely not an unused one.

Yes. People continue to ask about VB6. They shouldn't. And you likely won't see anyone answering questions about, for example, COBOL or QuickBASIC, except in a historical context. The only VB6 question that should be asked is "why are you still using it?"

Aside from that being really god-awful code, this thread is many years old and not worth reviving.

So what you are asking is for someone here to do the research for you and post the results?

How to explode data array using MYSQL and using NOT IN

What does that mean?

I'm guessing he meant "IT" as opposed to "it". Communicating clearly is a skill I would expect someone with huge experience to have.

Copying and pasting your homework and expecting someone to do it for you is not going to earn you the education you need. Please read the Daniweb Posting Rules and Suggestions For Posting Questions.

Please read the Daniweb Posting Rules and Suggestions For Posting Questions.

What have you done so far, and where are you stuck?

What parts are unclear? I think I've pretty much done everything but show you the complete correct code which is almost line for line what is given in the pseudo-code.

I heard about this thing called Google. You might try that. I find the phrase "where can I download pip for linux" works pretty well.

the US Gov is unwilling to take the actions required

The people who know what they are doing have either been fired or muzzled and the agencies have been gutted to pay for the tax cuts. Of course, when the prez lies on the average 16 times per day the media no longer calls him on and new lies (like they ever really did) so it's far easier for him to just say "it's contained" than to actually take action. The White House recently prevented government health officials from recommending that elderly people be advised against flying on commercial airlines. It's more important for Trump to keep the economy going than to protect people, at least until after the election.

For any karaoke freaks out there, There is an experimental package available for free from MIT called spleeter. This is a simple (in terms of use) AI which is quite remarkable in its ability to separate an audio file into component sounds. In its simplest form it can take a song and split it into separate instrumental and vocal files. Great for those of us who want to see how we would sound in place of the original artist. If you already have python 3.x installed you can get the package by

pip install spleeter

although it is always a good idea to make sure pip is current by first doing

pip install --upgrade pip

As an example, if you have a file, Mad World.mp3 you can split it up by

spleeter separate -i "Mad Worls.mp3" -o audio_out -n filename

The first time you run it will be a tad slow as it must first download the training files into the folder pretrained_models. Subsequent runs are much faster. Output is in

.\audio_out\Mad World\accompaniment.wav
.\audio_out\Mad World\vocals.wav

I found that the easiest way to plug myself in was to run Audacity (free audio software), drop in the accompaniment and vocals as separate stereo tracks, then add a new stereo track. Plug in the headphones, hit record and sing along. Then you can mute or delete the original vocal track and voila.

Adding command line parameters allows you to separate out instrumental tracks as separate drum, piano, etc.

If you have errors then fix them. If you wan't more help then tell us what errors you are getting. I can see several but I think you could go to the trouble of adding more information.

There is a big difference between

Could somebody help me out with programming a Tic Tac Toe game?

and

I would love to have to have the code

The first is "I'm stuck here" and the second is "I don't want to bother to learn anything. Please do it for me." At least you admit that it is for an assignment.

Please read the Daniweb Posting Rules. Pay particular attention to the sections about posting in old threads and posting in all caps.

Unfortunately, it still results in the UAC prompt.