TIMESTAMP null value help
I am trying to get my TIMESTAMPE field to auto update (use the current time for inserts). However it keeps going to all 00, I read the documentation and it says that is because it is getting an invalid input. However it also states if you put null in it will work, it does on the server, but when I use perl/dbi it goes to 00 Here is the code my $sth1 = $dbh-prepare(insert into CONTACT values (?,?,?,?,?,?,?,?)); $sth1-execute($query-param(NAME), $query-param(COMPANY), $query-param(EMAIL), $query-param(PHONE), $quer y-param(ADDRESS), $query-param(SUBJECT), $query-param(MESSAGE), null) or die Can't execute SQL statement: $ DBI::errstr\n; and the results for the ones using the form about have all zeros, if I do insert into CONTACT (NAME,COMPANY,EMAIL,PHONE,ADDRESS,SUBJECT,MESSAGE,DATE) values (Ron Petty, asdfasdf, [EMAIL PROTECTED], asdfddd, sdfsadfasdfsad, Testing contact, Hey did this thing work?, null); It works, any ideas? Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with LOAD DATA LOCAL INFILE
I just tried the following and got ysql load data local infile /home/repett0/contact.data into table CONTACT; ERROR 1148: The used command is not allowed with this MySQL version mysql I too use perl and dbi What is going on? Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make error
I cannot find a fix for this (only a couple of mentions on upgrading glibc, i think i have the latest). I get this during make mkdir .libs gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHA REDIR=\/usr/local/share/mysql\ -DUNDEF_ THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O 3 -DDBUG_OFF -c libmysql.c -fPIC -DPIC - o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1324: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1324: too few arguments to function `gethostbyname_r' libmysql.c:1324: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 [repett0@unigeek mysql-3.23.52]$ rpm -aq | grep glib glib2-2.0.1-2 glibc-kernheaders-2.4-7.16 glibc-2.2.5-39 glib-1.2.10-5 glibc-common-2.2.5-39 glibc-devel-2.2.5-34 [mysql-3.23.52]$ uname -a Linux unigeek.com 2.4.18-53um #1 Thu Aug 22 08:54:36 CDT 2002 i686 unknown [ mysql-3.23.52]$ Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php