Search DaniWeb - delete

Re: Delete unused MySQL indexes 27 Minutes Ago by Reverend Jim … to find things quickly I would imagine that if you delete an index and then take a performance hit it's… Re: Delete unused MySQL indexes 15 Minutes Ago by Dani As some general background, that's the syntax to delete an index, of course, but MySQL knows if an index is used because, well, it's the one that uses it, and it tracks that stuff internally. Now on to my question ... ;) Delete unused MySQL indexes 4 Hours Ago by Dani How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. Re: Delete unused MySQL indexes 4 Hours Ago by Dani OK, so I found [this blog post](https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/) by the one and only Percona, that says that I can simply do `select * from sys.schema_unused_indexes;` which does give me a list of indexes. However, it says it's based on having: update performance_schema.setup_consumers set enabled = 'yes' … Re: Are we being played by AI? Let's Discuss! 4 Weeks Ago by Dani …, and I always want to exercise extreme caution and not delete or infract a post unless I'm 100% confident. I… Re: WooCommerce Duplicate Categories 2 Months Ago by simplixi …you want to keep **Merge or Delete Duplicate Categories:** * You can manually delete duplicate categories from the list by… selecting them and choosing "Delete" from the bulk actions dropdown * If you… If you are comfortable with SQL, you can manually delete duplicate entries from these tables. Be cautious with this … Re: A reliable way of detecting AI content? 2 Months Ago by Dani AI generated content is very obvious to me, as well. However, DaniWeb gets a ton of AI generated submissions every day and I am looking for a reliable way of blocking it without having to delete the posts after-the-fact, and also without having to stick all new posts into a moderation queue. Re: Editor crashes browser 1 Month Ago by Salem @Mr.M, @Dani - you might want to delete/censor the IMEI shown in the screenshots at some point. Re: Why my iPhone runs so slow recently? 2 Months Ago by Ja sa bong This usually happens when the RAM of your iPhone is almost exhausted. It is one of the reason why any smartphone will start being very slow and lagging when you're trying to use it for anything. Also, you should try and upgrade your phone after using it for 2 years as it behaving this way. Re: Why my iPhone runs so slow recently? 2 Months Ago by Dani I think you're referring to physical memory (hard drive space) and not random access memory (RAM). Using up all your hdd space can make your phone go slower. RAM is transient and is just the memory the apps you currently have open at the time are using. The amount of RAM you use goes down when you close out of apps or restart your phone. Re: I built a kafka GUI client for operating kafka, welcome to use 1 Month Ago by elary It is a nice project.Is there any notification function? Delete install.php file for security reason please! 11 Years Ago by kidcameo Delete install.php file for security reason please! How can I delete this and how to find it..I keep seeing this message when I go to a site I usually visit. only saw it first time today Delete checked item from listview 9 Years Ago by abu taher Delete checked item (one or more) from listview I write this … -1 If LVEmp.ListItems(x).Checked Then con.Execute "DELETE FROM stock WHERE [SrNo] = '" & LVEmp.ListItems(x).SubItems… Delete Row on Buuton Click in C# through coding 14 Years Ago by abhi10kumar Delete selected record on Button click. I am using MS Access as a Database in C#. How it can be done ?? Delete the highlighted row 14 Years Ago by Shodow delete the highlighted row ADODC DATAGRID MYSQL Re: Delete keyword question? 16 Years Ago by Ancient Dragon … data you stored at that location is still there, but delete invalidated the pointer you had. Its always a good rule…-of-thumb to reset pointers to NULL after calling delete or delete[] so that the program doesn't mistakenly attempt to…;<" "<<t[1]<<endl; delete[] t; [color=red]t = NULL;[/color] cout<<t… Re: Delete Record But Have an err0r 14 Years Ago by smantscheff DELETE the record before you SELECT it, otherwise it will appear in the result list of the select (line 4) before your delete in line 42 kills it. Re: Delete row using ms access 12 Years Ago by JorgeM > DELETE FROM Employees WHERE Employee ID If your SQL field has a space between two words, you need to wrap the name within brackets. For example, `DELETE FROM Employees WHERE [Employee ID] = " & TextBox1.Text & " ` Re: Delete an Item from listview 12 Years Ago by Dili1234 Delete command is only not working.............. Re: delete data, then shift its number.... 17 Years Ago by cfAllie --- delete selected question delete from Questions where SurveyID = 140 and QuestionNum = 3 --- decrease subsequent numbers update Questions set QuestionNum = QuestionNum -1 where SurveyID = 140 and QuestionNum > 3 Re: Delete duplicate rows in MySQL 2 Years Ago by stazeclop04 Delete Duplicate Record Using Delete Join. We can use the DELETE JOIN statement in MySQL that allows us to remove duplicate records quickly. ... Delete Duplicate Record Using the ROW_NUMBER() Function. ... DELETE Duplicate Rows Using Intermediate Table. Re: delete record not working 9 Years Ago by pritaeas > delete record not working What is not working exactly? Re: Delete from multiple tables 19 Years Ago by Troy "DELETE FROM table1 WHERE $localTime > Time; DELETE FROM table2 WHERE $localTime > Time"; Re: Delete keyword question? 16 Years Ago by Narue delete frees the memory up for other uses. Just because that memory isn't immediately used after deleting doesn't mean you can safely access it. Re: Delete rows from sql database 15 Years Ago by ds2r DELETE FROM table_name WHERE checkbox = checked? Re: Delete Everything After 48 hours has elapsed ? 13 Years Ago by Biiim DELETE FROM users WHERE user_status = 0 AND date_signed_up < DATE_SUB(NOW(), INTERVAL 2 DAY); or UPDATE users SET `deleted` = 1 WHERE user_status = 0 AND date_signed_up < DATE_SUB(NOW(), INTERVAL 2 DAY); Re: !!! Delete & Format ? 9 Years Ago by mack1 Delete : - Deleting is a process in which a user deletes data … be done temporarily or permanently. If a user uses the Delete button from the keyboard to erase some file, it moves… delete 13 Years Ago by davy_yg …']; echo $kategori; } elseif(!$_POST['mode'] == 'delete'){ $output = mysql_query("DELETE * FROM produk WHERE id=".$_POST['id']) or …php echo $data['id_produk'];?>&mode=delete">Delete</a> </td>…me to product_edit form, if I press delete it remains in product_preview.php The form … delete 13 Years Ago by davy_yg …echo $kategori; } elseif(!$_POST['mode'] == 'delete'){ $output = mysql_query("DELETE * FROM produk WHERE id=".$_POST['id'])…;Data has been deleted" : "Fail to delete data"; } } ?> <h2>…echo $data['id_produk'];?>&mode=delete">Delete</a> </td… delete 10 Years Ago by twtw …->link; // current points to current next next. delete garbage; // Delete node. garbage = 0; // To prevent a dangling …garbage = current->link; // Assign current next to garbage. delete garbage; // delete node. garbage = 0; // To prevent a dangling pointer and…