Re: row count inconsistency

2007-02-21 Thread Marty Landman
T\n` if not $cur % 10 } print $line,"100537311\n" On 2/20/07, Steve Edberg <[EMAIL PROTECTED]> wrote: At 6:23 PM -0500 2/19/07, Marty Landman wrote: >Hi, > >I've got a very large table set up and have defined the id as >auto_increment. No r

row count inconsistency

2007-02-19 Thread Marty Landman
Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since mysql> describe fidcid; ++---+--+-+-+-

Re: Mass upload

2001-04-12 Thread Marty Landman
At Thursday 4/12/01 08:56 AM, [EMAIL PROTECTED] wrote: > I need to take a flat file (currently in excell) and upload it into a MYSQL > database via the web using PHP. This will happen every week so what is the > best way to do this drop the table then re-create it with the info. from the >

Re: "Memo" Fields

2001-04-11 Thread Marty Landman
At Wednesday 4/11/01 10:32 AM, Frank Schmuck, CFO wrote: >I have a database of e-mail messages, the body of which is currently a >"memo" field. I want to convert these to MySQL (or to create a new one in >MySQL). Frank, for potentially large variable length strings Mysql provides the 'blob' dat