On Thu, Feb 9, 2012 at 3:03 PM, Rakesh Kumar <[email protected]> wrote:
> > > On Thu, Feb 9, 2012 at 3:01 PM, Rakesh Kumar <[email protected]> wrote: > >> >> >> On Thu, Feb 9, 2012 at 2:49 PM, Gaurav Paliwal < >> [email protected]> wrote: >> >>> hi, >>> which engine you are currently using ? >>> >>> On 2/9/12, Rakesh Kumar <[email protected]> wrote: >>> > Hi All, >>> > I am facing a problem in MySql that even if i set 'NOT NULL' constraint >>> > while creating a table, mysql allows null values in the database. Is it >>> > true with every mysql distribution or is an error in my server? I have >>> > searched on internet and found that many people have reported this >>> thing as >>> > a bug. Can somebody suggest me something fruitful? >>> > >>> > -- >>> > Thanks and Regards >>> > RAKESH KUMAR >>> > http://raakeshkumar.wordpress.com >>> > _______________________________________________ >>> > Ilugd mailing list >>> > [email protected] >>> > http://frodo.hserus.net/mailman/listinfo/ilugd >>> > >>> >>> >>> -- >>> With Regards, >>> Gaurav Paliwal >>> http://gauravpaliwal.com >>> >> >> >> InnoDb Engine.. and version is 5.5.8... >> -- >> Regards >> RAKESH KUMAR >> http://raakeshkumar.wordpress.com >> >> >> > Sorry i forgot to send it to group... > Engine is InnoDb Engine.. and version is 5.5.8... > > -- > Regards > RAKESH KUMAR > http://raakeshkumar.wordpress.com > > > And I am using phpMyAdmin for this though i have a separate java program to do this... Ok now at this point i wanna ask that is it that if i use different engines then syntax of query also change accordingly? I have facing a problem here that is i have set few fields which can be blank and used innodb engine then i wrote a query to select which was- SELECT * from tablename WHERE field IS NULL then when i imported this database to other system with MyIsam engine this query didn't work and i had to change the query which was: SELECT * from tablename WHERE field = ""; Please guide me.. -- Regards RAKESH KUMAR http://raakeshkumar.wordpress.com _______________________________________________ Ilugd mailing list [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd
