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: http://lists.mysql.c

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 clues

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 - 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 '/var/lib/mysql/mys

Re: Outputting text in a

2006-08-23 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:http://li