Re: [ilugd] MySql Bug
have you checked with their bug list? Which version. On Thu, Feb 9, 2012 at 11:58 AM, Rakesh Kumar kumar3...@gmail.com 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 Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd -- Srikrishna Das (krish at irc.freenode.net) ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] MySql Bug
On Thu, Feb 9, 2012 at 11:58 AM, Rakesh Kumar kumar3...@gmail.com 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? Perhaps this list (http://sql-info.de/mysql/gotchas.html) of mysql gotchas will help. -- Anupam ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] MySql Bug
On Thu, Feb 9, 2012 at 3:01 PM, Rakesh Kumar kumar3...@gmail.com wrote: On Thu, Feb 9, 2012 at 2:49 PM, Gaurav Paliwal gaurav.paliwal1...@gmail.com wrote: hi, which engine you are currently using ? On 2/9/12, Rakesh Kumar kumar3...@gmail.com 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 Ilugd@lists.linux-delhi.org 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 ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] MySql Bug
On Thu, Feb 9, 2012 at 3:03 PM, Rakesh Kumar kumar3...@gmail.com wrote: On Thu, Feb 9, 2012 at 3:01 PM, Rakesh Kumar kumar3...@gmail.com wrote: On Thu, Feb 9, 2012 at 2:49 PM, Gaurav Paliwal gaurav.paliwal1...@gmail.com wrote: hi, which engine you are currently using ? On 2/9/12, Rakesh Kumar kumar3...@gmail.com 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 Ilugd@lists.linux-delhi.org 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 Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
[ilugd] MySql Bug
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 Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd