Search DaniWeb - table

Re: Web Services using ASP.NET 4 Days Ago by natashasturrock … the password, and checks for a match in the Users table. In your ASP.NET Core API, create a POST endpoint… Re: Web Services using ASP.NET 2 Weeks Ago by rajshah85412 …Step Process Step 1: Create a Database Table Start by designing a table in SQL Server where user data will… be stored. This table should include fields like: Username Password (you can …later add encryption) Email address This table will be used to store and retrieve user credentials. … Re: Delete unused MySQL indexes 1 Month Ago by toneewa … performance_schema.setup_instruments SET enabled = 'YES' WHERE name = 'wait/io/table/sql/handler'; Verify the settings: SELECT * FROM performance_schema.setup_consumers WHERE…= 'events_waits_current'; SELECT * FROM performance_schema.setup_instruments WHERE name = 'wait/io/table/sql/handler'; Wait for a period of time to collect… Re: Delete unused MySQL indexes 1 Month Ago by Dani … as others might, and having too many indexes on a table can slow down inserts and updates to a drag. Having…, it takes 12+ hours to add an index to a table, during which for most of that time we need to…'s too resource intensive to add an index to a table that is concurrently being hit with requests. Removing an index… Delete unused MySQL indexes 1 Month 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 1 Month 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: Delete unused MySQL indexes 1 Month Ago by Dani I can see your rationale, but I don't necessarily agree with a separate table in the database for every month. There are much more elegant ways of handling that use case these days, especially in MySQL. You didn't specify how long ago this was. Either way, still hoping a MySQL expert can come along and answer my question here. Re: Is the Vision Pro worth it? 1 Month 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: Question/Answering over SQL Data Using LangGraph Framework 2 Months 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: Delete unused MySQL indexes 1 Month 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 1 Month 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 ... ;) Re: Delete unused MySQL indexes 1 Month Ago by Reverend Jim See [performance-schema-consumer-filtering](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-filtering.html) Re: Delete unused MySQL indexes 1 Month Ago by Dani I already read that article, as well as related ones such as [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html) and [this](https://dev.mysql.com/doc/refman/8.4/en/performance-schema-event-tables.html) but it all went above my head and didn’t seem to directly answer my question. For example, when I currently run … Re: Delete unused MySQL indexes 1 Month Ago by Reverend Jim >Is that list incomplete or straight-up wrong? I have no way of knowing. If I add a bunch of numbers and get an answer, is it right or wrong? Again, as a guess, if you have enabled the correct flags and let the system run through typical processing, the returned list should be, according to the docs, a list of unused indexes. Worst case … Re: Delete unused MySQL indexes 1 Month Ago by Reverend Jim I faced a similar problem when I created and maintained the corporate side databases to mirror the EMS (AGC/SCADA) real time data. One month of data was roughly 300 meg and it was critical that this be available 24x7. Sometimes databases break and it is important to recover them as quickly as possible. Knowing that around 90% of the queries were on… Re: Delete unused MySQL indexes 1 Month Ago by Reverend Jim >You didn't specify how long ago this was. 1998-1999 Re: Delete unused MySQL indexes 1 Month Ago by Dani > Your data wouldn't be accurate and incomplete, if either one of the performance schemas were off. Do you mean `!(accurate && incomplete)` or do you mean `!accurate && incomplete`? But I gotcha. Thank you for the explanation. 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 18 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…