2006/4/14, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> Hi,
>
> I have one table :
> CREATE TABLE `ressources_summary` (
> `res_type` tinyint(3) unsigned NOT NULL default '0',
> `res_id` int(10) unsigned NOT NULL default '0',
> `comment_count` smallint(5) unsigned NOT NULL default '0',
> `com
Hi,
I have one table :
CREATE TABLE `ressources_summary` (
`res_type` tinyint(3) unsigned NOT NULL default '0',
`res_id` int(10) unsigned NOT NULL default '0',
`comment_count` smallint(5) unsigned NOT NULL default '0',
`comment_last_timestamp` timestamp NOT NULL default '-00-00 00:00:0
some more).
Greetings
François
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: mardi, 20. septembre 2005 21:29
> To: RAPPAZ Francois
> Cc: mysql@lists.mysql.com
> Subject: Re: SQL to use left join and find missing values
>
> If you w
, 2005, at 2:40 AM, RAPPAZ Francois wrote:
Hi all
with Mysql 3.23 I would like to find missing values in the
following situation:
1) table boxes: describes kind of boxes differing by how many items
I can put in.
Primary key is BoxID
boxID + Places
A + 1
B + 3
C + 5
2
Hi all
with Mysql 3.23 I would like to find missing values in the following situation:
1) table boxes: describes kind of boxes differing by how many items I can put
in.
Primary key is BoxID
boxID + Places
A + 1
B + 3
C + 5
2) table car describes how I can put some boxes on
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 ou
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
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 DATA
INFILE, MySql writes the mi
;
> - Original Message -
> From: "Neil Silvester" <[EMAIL PROTECTED]>
>
> > I hope this doesn't sound like a stupid question.
> >
> > Is there anyway of finding missing values in an INT column type?
> > Say I have a telephone extension guide. Usin
ld give you a good start in
mysql.
Dave
On Fri, Feb 01, 2002 at 10:03:08AM +1000, Neil Silvester wrote:
> I hope this doesn't sound like a stupid question.
>
> Is there anyway of finding missing values in an INT column type?
> Say I have a telephone extension guide. Using the MI
ect * from static_extension_table a left join your_table b
on a.ext_column = b.ext_column
and a.ext_column is null;
- Original Message -
From: "Neil Silvester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 7:03 PM
Subject: Missing values in an
I hope this doesn't sound like a stupid question.
Is there anyway of finding missing values in an INT column type?
Say I have a telephone extension guide. Using the MIN() and MAX() functions
I am able to find the start and end ranges. But what about finding the
extensions that are not allo
12 matches
Mail list logo
