At 11:01 +0100 12/19/02, Gianluca Carnabuci wrote:
Hi,
I've been trying to import a huge .txt file into a MySql table. In
the .txt file, missing values are recorded as empty cells (it might
be that there's some hidden character instead, but I wouldn't know
how to figure that out). When I LOAD
replace missing value (NULL) as \N in your .txt file
--- Gianluca Carnabuci <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been trying to import a huge .txt file into a
> MySql table. In the .txt file, missing values are
> recorded as empty cells (it might be that there's
> some hidden character inste
Neil,
Let's extend Kalok's suggestion:
A well-designed database is supposed to contain data that reflects/represents a
'reality'. The telephone
extension guide describes a 'reality' of the PBX as viewed by the users - a telephone
list by any other name -
built to answer the question "how do I p
MAX_EXTENSION=
select a.id + 1 from dude a left join dude b on a.id +1 = b.id where b.id is null and
a.id < MAX_EXTENSION;
You'll have to have one record in the table for this to work. I've done a better job
of this
in Oracle because of nested queries, but I think this could give you a go
you could possibly do this.
well first, is there a fix size for the extension ? i.e 3 digit or 4
digits.
if so, you could easily fill a table with a script with all the ranges of
extensions, say that table is called static_extension
then you can do the "not in" join
select * from static_extens
