Baron Schwartz wrote:
Hi Ed,
On Thu, Apr 3, 2008 at 3:32 PM, Ed W <[EMAIL PROTECTED]> wrote:
Hi
Up until version 5.0.44 (on linux) it appeared that you could do stuff like
deliberately insert a NULL into a NOT NULL varchar field and it would be
silently converted to an empty string. Simil
Hi Ed,
On Thu, Apr 3, 2008 at 3:32 PM, Ed W <[EMAIL PROTECTED]> wrote:
> Hi
>
> Up until version 5.0.44 (on linux) it appeared that you could do stuff like
> deliberately insert a NULL into a NOT NULL varchar field and it would be
> silently converted to an empty string. Similarly if you didn't
Hi
Up until version 5.0.44 (on linux) it appeared that you could do stuff
like deliberately insert a NULL into a NOT NULL varchar field and it
would be silently converted to an empty string. Similarly if you didn't
specify a value it appeared to use what is describe in the docs as the
"DEFAU
* Donal Murtagh
> My DB consists of INNODB tables, such as...
>
>
> CREATE TABLE user
> (
> name VARCHAR(255) NOT NULL
>
> ) TYPE = INNODB;
>
>
> The NOT NULL qualifier doesn't have the effect I expected. Although I
> can't do this...
>
> INSERT user VALUES (null);
>
>
> I can do this:
>
> INSERT u
Greetings,
My DB consists of INNODB tables, such as...
CREATE TABLE user
(
name VARCHAR(255) NOT NULL
) TYPE = INNODB;
The NOT NULL qualifier doesn't have the effect I expected. Although I
can't do this...
INSERT user VALUES (null);
I can do this:
INSERT user VALUES ("");
I appreciate
On Fri, Feb 07, 2003 at 04:33:15PM -0700, [EMAIL PROTECTED] wrote:
> Hi "Doug Beyer" <[EMAIL PROTECTED]>,
>
> I'm not sure if you have checked the manual yet, but following
> links seem to be somewhat related to your query:
Please could these stop. Already I have noticed various people
reposting
Doug,
> create table t1 ( id varchar(5) not null, name varchar(5) not null );
> insert into t1 ( id ) values ( "1234" );
> select count(*) from t1 where name = "";--> Result = 1
> 1) Why did the insert succeed since the "name" field is not null and I didn't
>provide a value?
> 2)
On Thu, 6 Feb 2003 12:05:03 -0500, Doug Beyer wrote:
>
>I create the following table:
>
>create table t1 ( id varchar(5) not null, name varchar(5) not null );
>
>I insert the following row:
>
>insert into t1 ( id ) values ( "1234" );
>
>I do the following selects:
>
>select count(*) from t1 where n
On 2/6/03 9:05 AM, "Doug Beyer" <[EMAIL PROTECTED]> wrote:
> I attempted to search various places for my answer but with no luck. So I'm
> posting here.
>
>
>
> I create the following table:
>
> create table t1 ( id varchar(5) not null, name varchar(5) not null );
>
>
> I insert the followin
Doug Beyer wrote:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
insert into t1 ( id ) values ( "1234" );
select count(*) from t1 where name is null; --> Result = 0
select count(*) from t1 where name = ""; --> Result = 1
Questions:
1) Why did the insert succeed sinc
E.html
* http://www.mysql.com/doc/en/SHOW.html
* http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html
* http://www.mysql.com/doc/en/ODBC_administrator.html
This was an automated response to your email 'CREATE TABLE, NOT NULL fields, and empty
strings'.
Final search keyword used
I attempted to search various places for my answer but with no luck. So I'm posting
here.
I create the following table:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
I insert the following row:
insert into t1 ( id ) values ( "1234" );
I do the following selects:
s
On Wednesday 22 January 2003 19:24, Valdir Stiebe Junior wrote:
> Creating a table with a not null field, and then trying to insert it
> doesn't raise an error 'Column XXX cannot be null'
> Well, this was the steps (sql to bypass filter) i did:
>
> 1. create table TEST ( id_test integer, name varc
Hi,
Creating a table with a not null field, and then trying to insert it doesn't
raise an error 'Column XXX cannot be null'
Well, this was the steps (sql to bypass filter) i did:
1. create table TEST ( id_test integer, name varchar(50) not null );
2. insert into TEST (id_test, name) values (1, 'pp
* Manjeet
> I am inserting user details from a file. The file has users seperated by
> commas(,)
>
> example of file
>
> manjeet,tom,tim,,john,alexander
>
>
> Using perl script i am reading the file and seperating user info at commas
> and inserting into database.
>
> Now my problem is that i don'
njeet
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 05, 2002 7:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: facing problem with NOT NULL fields
Manjeet writes:
> I created table using following syntax,
>
> create table
* Manjeet
> create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
> NULL, PRIMARY KEY (Login_ID));
>
> The above table should not take any null values.
> I tryed inserting some null values eg:
>
> INSERT INTO user (Login_Id,Location) values ("","");
>
> According to me this st
Manjeet writes:
> I created table using following syntax,
>
> create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
> NULL, PRIMARY KEY (Login_ID));
>
> The above table should not take any null values.
> I tryed inserting some null values eg:
>
> INSERT INTO user (Login_Id,
I created table using following syntax,
create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
NULL, PRIMARY KEY (Login_ID));
The above table should not take any null values.
I tryed inserting some null values eg:
INSERT INTO user (Login_Id,Location) values ("","");
Accordi
"is NOT NULL" in the whare close
26/12/2001 16:46:44, Gilles Missonnier <[EMAIL PROTECTED]> wrote:
>Hi !
>
>I need a help on the syntax.
>
>My table has over 100 different fields: I want to display only the
>"NOT NULL" fields and also the names
Hi !
I need a help on the syntax.
My table has over 100 different fields: I want to display only the
"NOT NULL" fields and also the names of these "NOT NULL" fields.
so the simple mysql command :
mysql> select * from tabID where tabID.login='john';
return
21 matches
Mail list logo
