Hi!
- Original Message -
From: ""Martijn Tonies"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 8:59 PM
Subject: Re: NULL columns
When doing an insert using NULL in the insert request,
what really is being wri
> When doing an insert using NULL in the insert request,
> what really is being written in the column?
> Is the word NULL being written?
> Is any real space being consumed?
In the cases that you really want to store NULL ;-)
No, it's not the word "null".
Of course space is consumed.
How m
When doing an insert using NULL in the insert request,
what really is being written in the column?
Is the word NULL being written?
Is any real space being consumed?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Hello.
Remove coma from 'POINT(1,1)', instead use 'POINT(1 1)';
See:
http://dev.mysql.com/doc/mysql/en/Populating_spatial_columns.html
>I installed mySQL server from Wizard and then i create table:
>create table geom ( g POINT) ENGINE = MYISAM;
>but i can't add any object to the table
In article <[EMAIL PROTECTED]>,
"Rafal K." <[EMAIL PROTECTED]> writes:
> I installed mySQL server from Wizard and then i create table:
> create table geom ( g POINT) ENGINE = MYISAM;
> but i can't add any object to the table. I wrote:
> insert into geom values(PointFromText('POINT(1,1)'));
> and t
I installed mySQL server from Wizard and then i create table:
create table geom ( g POINT) ENGINE = MYISAM;
but i can't add any object to the table. I wrote:
insert into geom values(PointFromText('POINT(1,1)'));
and then i saw in the table NULL values:
SELECT AsText(g) FROM geom;
| g
nt of dirty data between different systems.
Be careful when not including NOT NULL columns in your inserts...
To get around the problem and get more background info, read:
http://dev.mysql.com/doc/mysql/en/constraint_NOT_NULL.html
Regards,
Thomas Lundström, Ongame E-Solutions AB
-Ori
Hi folks:
I have an InnoDB database, the tables created using MySQL Control Center
0.9.4-beta (winXP pro platform).
Each table has some columns which I have checked as Nulls Allowed.
I am building a pure Java GUI to the database. Got the SQL statements
working fine, but have
discovered that I c
GUYOT Carole writes:
> I'm trying to insert records from a file. These records are separated
> with pipes.
>
> load data local infile "aid.exp" into table aid;
How is MySQL supposed to know that you're using a
non-standard way of separating your records if you don't
tell it? :-O
You need to sp
I'm trying to insert records from a file. These records are separated
with pipes.
use crous;
load data local infile "aid.exp" into table aid;
When I do "select * from aid" , the first column is OK but the
second and third columns are nulls for all rows.
It's weird!
Has anyone experienced t
No, I'm looking for the average of all not NULL columns inside a certain
_record/row_. There are other columns in the each row.
Right now I have to do this: (these are survey questions, which don't
necessarily need to be answered)
SELECT
IF(q1a,@cnt:=1,@cnt:=0),
IF(q1b,@cnt:=@cnt+1,
MAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, May 22, 2001 11:29 AM
> Subject: Average of all NON-NULL columns in a ROW?
>
>
> > Is there a way to get the AVG of all specified NON-NULL columns in one
> row?
> > Right now I am doing this in a litt
Select avg(id1) from where id1 is not null; ?
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 22, 2001 11:29 AM
Subject: Average of all NON-NULL columns in a ROW?
> Is there a way to get the AVG
On Tue, May 22, 2001 at 12:29:35PM -0400, Graeme B. Davis wrote:
> Is there a way to get the AVG of all specified NON-NULL columns in one row?
> Right now I am doing this in a little script, but it would be nice if I
> could do something like this:
>
> DATA
> -
&g
Is there a way to get the AVG of all specified NON-NULL columns in one row?
Right now I am doing this in a little script, but it would be nice if I
could do something like this:
DATA
-
id1044NULL3NULL
I want the average of 0,4,4,3 ie (0+4+4+3)/4
is there a way
Hello john,
Thursday, March 08, 2001, 12:19:22 AM, you wrote:
jrd> with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
jrd> values still reject rows that are the same? this isn't working (it allows
jrd> duplicate rows to be included if one of the columns is NULL). this seem
with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
values still reject rows that are the same? this isn't working (it allows
duplicate rows to be included if one of the columns is NULL). this seems wrong.
here's an example:
mysql> create table n (
i
17 matches
Mail list logo
