table

Speed of mysql update / set statement. Multiplying a column

I have 1 million rows in MySql table "temp" and wish to multiply column "t" (int unsigned, indexed) by 1000. mysql> update temp set t=1000*t; This process takes 25 seconds. The same statement on not-indexed column takes 10 seconds; Any ideas how to make this process faster? I have to apply this on over 1e5 tables. ...

Is there a PHP script that can convert HTML table data to various formats?

Using PHP, I can convert MySQL data or static table data to csv, Excel, JSON, MySQL etc but is there a useful conversion script or tool that can convert table data into other formatted/styled formats such as PDF and/or JPG/PNG using the PHP GD Library or other? ...

Opacity in web pages?

I keep seeing 60-80% opacity on tables on websites. They look really cool, but I'm not sure why they are doing it. Is it Javascript, or is it an image? How do I change the opacity of a table? ...

How to format multiple tables for vertical alignment

I have inherited some HTML code and have been asked to align the two tables so the text lines up between the two columns. There is an outer table that provides a two-column look to this thing, then two inner tables (one for each column). Each inner table contains boxes that hold text. It is these boxes of text that the client wants alig...

CakePHP Accessing Dynamically Created Tables?

As part of a web application users can upload files of data, which generates a new table in a dedicated MySQL database to store the data in. They can then manipulate this data in various ways. The next version of this app is being written in CakePHP, and at the moment I can't figure out how to dynamically assign these tables at runtime...

Database speed optimization: few tables with many rows, or many tables with few rows?

Hi guys, i have a doubt (big). Lets take as example a database for, dunno, a whatever company's orders. Lets say that this company make around 2000 orders per month, so, around 24K order per year, and they dont ant to delete any order, even if 5 years old (hey, this is an example, numbers dont mean anything:) In the meaning of have a ...

want to add padding to a td with jquery

I need to find td within a div and add a class to all the td's within that div, how can I do that with jquery? ...

Is BIT field faster than int field in SQL Server?

I have table with some fields that the value will be 1 0. This tables will be extremely large overtime. Is it good to use bit datatype or its better to use different type for performance? Ofcource all fields should be indexed. ...

html table syntax validation

This should be an easy one. I have a table like so: <table> <tr> <td></td><td></td><td></td><td></td> </tr> <tr> <td></td> </tr> </table> My firefox 3 validator says this is acceptable code. It just seems wrong to me, are there any possible issues leaving the table rows uneven like this? It works in IE7 too. ...

How to apply padding to a column using <col> and CSS in Firefox?

Example: <style type="text/css"> table { border: 1px solid red; border-collapse: collapse; text-align: left; } #col-1 { padding-left: 20px; background-color: tan; } #specific-cell { padding-left: 20px; } </style> <table> <col id="col-1"> <col id="col-2"> ...

Outlook 2007 Html table td elements

I try to make newsletter compitable wiht Outlook 2007, but Outlook rendering engine isn't very logical. Following code is not making borders as width of 1 pixel like in Firefox and other rendering engines, but it adds some extra space between some of these td-elements. Is there a workaround for this issue ? <table> <tr> <td width="0" s...

Is there an Automated way to convert a Table based HTML page to purely CSS based page ?

I have a Web Site thats designed using traditional tags but I need to convert to CSS based tags. Is there a better way (Free Software / Tool) to do this rather than taking one tag at a time and converting it ? Thanks Rahul ...

JQuery TableSorter Comma-Digit Parser not working

Here's my problem, I am currently using the JQuery Table Sorter and I found a Comma-Digit parser on the web. The problem I am having is it doesn't seem to be working. So here is what the column is sorted as: 4,666 141,666 293 341,666 346 461,676 This should be sorted as 293 346 4,666 141,666 341,666 461,676 The parser I am usi...

Quickest way to delete enormous MySQL table

I have an enormous MySQL (InnoDB) database with millions of rows in the sessions table that were created by an unrelated, malfunctioning crawler running on the same server as ours. Unfortunately, I have to fix the mess now. If I try to truncate table sessions; it seems to take an inordinately long time (upwards of 30 minutes). I don't c...

Database tables for entries of another table?

I'm designing a new revision of my Java application (using an embedded H2 database) around a redesign of the way I'll be handling my data. Here's how I have it planned: Entries table- Entry ID Entry name Properties table- Property ID Property name (Individual property) value table- Value ID Entry ID (Value columns...) (Individua...

How to design DB table / schema with ease?

Is there a simple method to decide on what fields and indexes are needed for each table in an app you design? For example, if it is a webapp that simply lets people create lists (any number of lists, and users can create "things to do" list or "shopping" list), and the user can assign other users to edit the list, and whether the list i...

jQuery - Hiding a dynamically created table row on click

I'm currently trying to hide a dynamically created table row after a button has been pressed. So far I have managed to handle part of the dynamic functions. Each dynamic row has a "Cancel" and "Save" button, I have managed to respond to these with ease. My problem is actually working with the row itself. $(function() { $(".add").cl...

SQL Server: Writing a proper Table Description

I am, for the first time, writing descriptions for my SQL Server tables (from the Description field in the Properties Window), and I started thinking about what to exactly write in such a field. For examples, some tables are self-explanatory according to their titles...like a table called Albums in a "Music System". What description wo...

Does dropping a table in MySQL also drop the indexes?

It's not explicitly mentioned in the documentation (http://dev.mysql.com/doc/refman/6.0/en/drop-table.html). I ask because I just saw a curious database migration in a Rails project where the developer was removing all the indexes before dropping the table, and that seemed unnecessary. ...

jQuery - Reload table

I'm trying to reload a table which was also generated by PHP. The table has an ID: #bookmarks After the user pressed a button, the table should reload the content + the data they have just added. I'm a bit confused because I don't know how to send all of the data from a PHP result. Thanks, James ...