mysql NULl value in perl problem

2002-12-05 Thread David Wu
Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef in perl?.. As there is no the word NULL i

Re: DATETIME function to be used...

2002-11-28 Thread David Wu
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of -MM-DD HH:MM:SS. Is this value in a form of string?? If I have a column described as DATETIME data type I should be able to do: INSERT INTO tablename VALUES ("id#", "1997-10-10 24:45:32"), right? but if I do SELECT *

newbie really need help > mysql binary installation problem

2002-11-18 Thread David Wu
Hi guys, I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess in the documentation in the mysql.com web site. I am using bash shell, here is the list of commands i went through: shell> groupadd mysql s

Re: Mysql seg faults on remote connections

2002-11-04 Thread David Wu
Whats the workaround?? How should I start with mysql with defualt setting in a command line??? Thanks guys On Monday, November 4, 2002, at 01:33 PM, Chris West wrote: [EMAIL PROTECTED] - Before posting, please check: http:/

(beginner) mysql connection problem!

2002-11-04 Thread David Wu
Hi everyone, On my local machine I had mysql installed, and I was able to log in and doing a test on it. but today as I am trying to login using >mysql or >mysql -u root -p, I got the error message saying; ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), I h