Search DaniWeb - table

Re: Delete unused MySQL indexes 31 Minutes Ago 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 … Re: Delete unused MySQL indexes 19 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 …'; update performance_schema.setup_instruments set enabled = 'yes' where name = 'wait/io/table/sql/handler'; The second one was already set to yes… Re: Is the Vision Pro worth it? 2 Days Ago by Reverend Jim I usually put a square tile in the middle of the floor to stand on when playing Beat Saber. Eleven Table Tennis doesn't need it because I orient myself to the VR table. I play In Death Unchained seated because there are too many vertigo-inducing places in the middle world where I could easily fall over. Some of them make my feet tingle. Re: SAP db - how to get the time update statistics was performed on a table? 2 Months Ago by peol To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead! Need currency pound symbol before amount calculation 2 Months Ago by ianhaneybs …; function calc(){ var grand_total = 0; $('table#list tbody input[name="total[]"]').each(…function(){ grand_total += parseFloat($(this).val()) }) $('table#list tfoot .grand-total').text(parseFloat(grand_total).toLocaleString('… Re: Need currency pound symbol before amount calculation 2 Months Ago by Dani Yes, but you might want to also add `currency: 'GBP'`, as so: $('table#list tfoot .grand-total').text(parseFloat(grand_total).toLocaleString('en-gb', { style:'currency', currency: 'GBP', maximumFractionDigit:2 })) Re: Need currency pound symbol before amount calculation 1 Month Ago by Biiim … standard-correct answer I will do the botch-job answer: $('table#list tfoot .grand-total').text('£'+parseFloat(grand_total).toLocaleString('en-gb… Re: Ensuring data consistency and integrity 2 Months Ago by Dani … database so you could essentially put different records of a table on different servers, but I personally have no experience with… Re: Multiple MySQL connections + transactions 1 Month Ago by toneewa … same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection… Re: Multiple MySQL connections + transactions 1 Month Ago by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. Re: Where Can I Find Test Data (Names, Emails, etc.) for My Testing? 1 Month Ago by gediminas.bukauskas.7 Look at Customers table in NorthWind database (https://en.wikiversity.org/wiki/Database_Examples/Northwind). Re: Question/Answering over SQL Data Using LangGraph Framework 1 Month Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: Need currency pound symbol before amount calculation 2 Months Ago by Salem https://stackoverflow.com/questions/44969852/javascript-number-tolocalestring-currency-without-currency-sign Maybe use style 'currency' rather than style 'decimal' ? Re: Need currency pound symbol before amount calculation 1 Month Ago by gediminas.bukauskas.7 JS has a function for the formatting currencies. Read the 'https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Intl/NumberFormat/NumberFormat' article. You will find code samples there. Re: Need currency pound symbol before amount calculation 1 Month Ago by gottaloveit [Currency.js](https://currency.js.org/) also works very well for this table column min in current date 13 Years Ago by jabeen123 table name:student enroll id name date_of_admission 1 kiran 2008-11-11 how to minus date of admission column in current date in phpmysql? i want year difference and month difference separately Re: table problem 16 Years Ago by Aneesh_Argent …;> This is to align the content/data inside the table One way to achieve your requirement is to put your… table inside a div and align the div to center. Here…;width:100%; height: 100%; text-align: center"> <table > <thead> <tr> <td>… Re: Table problems 18 Years Ago by stymiee Table cells are vertically aligned to be in the middle by default. You need to use valign="top" in your table cells to push the content to the top. Re: Table css border help 17 Years Ago by stupidenator table { border-color: #cc3300; } td { border-color: #cc3300; } or you can combine the two commands into one: table { border: 1px dashed #cc3300; } Hope this helps. Nick table 10 Years Ago by davy_yg …$result = mysql_query($sqlstr) or die(mysql_error()); ?> <table id="admintable" border="1" cellpadding="…$result = mysql_query($sqlstr) or die(mysql_error()); ?> <table id="admintable" border="1" cellpadding="… Re: table 10 Years Ago by BenWard What exactly is your issue? Is the table not giving you any rows or is your alternating background not working? I normally assign attributes to the cell not the row, but I do this with CSS not old-school attributes eg style="backgound-color: white;" table help 14 Years Ago by tcollins412 … need some help. I am writing a table, here is the code:[CODE]<table style='float: left;'> <tr>…;<br /> </td></tr> </table>[/CODE] now, i want the link to align to… the top of the the table. here is the css for the link [CODE] <style… table 9 Years Ago by COKEDUDE How would I go about making this table? ID Type Value X int 4 Y int 4 Z …;, "0"}; return 0; } Is this considered a symbol table? Whats the difference between a… Re: table 9 Years Ago by rubberman As for the difference between a table like this and a symbol table is that a symbol table would contain symbols. You can use… Re: table 17 Years Ago by Ancient Dragon … 3 4 5 6 7 [/code] To print the above table you need two [b]for[/b] loops, one inside the… the columns. >>to find the table of any number To find a table of what? Is it supposed to be… a multiplication table ? Addition table ? you need to clarify the problem before you can begin … Table 16 Years Ago by akira_shinizaki How we can make a nice table in C++ ? I always use "|" and "___" to manually create a a table, but it often messed up. Please give me some tutorial and if possible table's screenshot. Thank you as always^^. Re: table help 14 Years Ago by untitledking … add more coding to suit you. Hope this helps :) <table style='float: left;'> <tr><td style…;<br /> </td></tr> </table> Re: table help 14 Years Ago by untitledking [CODE] <table style='float: left;'> <tr><td style='…;<br /> </td></tr> </table> [/CODE] srry about that, forgot to add the code…