RE: facing problem with NOT NULL fields

2002-01-07 Thread 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't want to insert the fourth

facing problem with NOT NULL fields

2002-01-05 Thread Manjeet
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

Question on Indexing

2001-11-21 Thread Manjeet Singh
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

Design,Performance and Speed of MySQL

2001-11-02 Thread Manjeet Singh
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