* 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
