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't want to insert the fourth
to me this statement should give error and not work. But still it
inserts null values in to the table.
When the same insert statement is run again, it gives error 1062.
Plz... suggest how to see that my table does not have any NULL value and
should i acheive this.
Or is this a bug.
Thanks
Manjeet
body tyed this and would share his experience.
Thanks a lot
Manjeet
*NEW* over 2200 active jobs at Yahoo! Careers *NEW*
Visit http://in.careers.yahoo.com
Hi Group,
I am new to mysql, and would like you all to give some time
in resolving my trouble. I am stuck up with a problem of
designing stores database for a big company.The company is
located in different places and wants web-based insertion,
retrival and maintaining of data and records in the