DBD/DBI datetime insert

2006-09-03 Thread Hal Wigoda
anyone have the code that will insert the current time into a  
datetime field in a table

while using perl DBI/DBD::mysql?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: DBD/DBI datetime insert

2006-09-03 Thread Paul DuBois

At 7:23 PM -0500 9/3/06, Hal Wigoda wrote:
anyone have the code that will insert the current time into a 
datetime field in a table

while using perl DBI/DBD::mysql?


Something like this:

$dbh-do(INSERT INTO t (col_name) VALUES(NOW()));

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: DBD/DBI datetime insert

2006-09-03 Thread Hal Wigoda

that looks very good.



On Sep 3, 2006, at 7:26 PM, Paul DuBois wrote:


At 7:23 PM -0500 9/3/06, Hal Wigoda wrote:
anyone have the code that will insert the current time into a  
datetime field in a table

while using perl DBI/DBD::mysql?


Something like this:

$dbh-do(INSERT INTO t (col_name) VALUES(NOW()));

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]