Strange insert: ERROR 1172 (42000)

2006-09-26 Thread Wai-Sun Chia
This is so weird! I'm getting a: ERROR 1172 (42000): Result consisted of more than one row I've setup 2 machines. Same table (dbsetup.sql) , same insert statement (foo.sql), same version (5.0.24a). Only difference is: One is my laptop on FC5-i386, the other is a server on RHEL4u4-i386 Any

Re: transitioning from ms sql

2006-09-26 Thread Wai-Sun Chia
On 9/27/06, Arjun Bhandari [EMAIL PROTECTED] wrote: Hi, I have been using MS SQL for the last one year, however would not like to Huh? If you would NOT like to transition to MySQL, then why are you asking all these stuff? -- MySQL General Mailing List For list archives:

Re: CentOS 4.3 - MySQL - NIS user issue

2006-09-04 Thread Wai-Sun Chia
On 8/31/06, Tom Brown [EMAIL PROTECTED] wrote: Hi I have what i think is a strange issue - snip now when a NIS user tries to use the db [EMAIL PROTECTED] su - bugzilla [EMAIL PROTECTED] mysql -u bugs -p bugs ERROR 2002: Can't connect to local MySQL server through socket

Re: Outputting text in a

2006-08-24 Thread Wai-Sun Chia
On 8/24/06, Dan Buettner [EMAIL PROTECTED] wrote: Sure - in your sql script, put in SELECT text to the screen; Then you'll get 2 copies... Try this: SELECT text to the screen AS ''; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: