Comments for Scripting MySQLhttps://scriptingmysql.wordpress.com
- the world's most popular open source database.Wed, 18 Feb 2015 15:07:37 +0000hourly1http://wordpress.com/Comment on Using Perl to send tweets stored in a MySQL database to twitter by realdavorghttps://scriptingmysql.wordpress.com/2015/01/07/using-perl-to-sent-tweets-stored-in-a-mysql-database-to-twitter/#comment-5644
Wed, 18 Feb 2015 15:07:37 +0000http://scriptingmysql.wordpress.com/?p=1392#comment-5644If you’re using Perl 5.10 (or greater) then it’s even easier with the newly-standard Time::Piece module.

use Time::Piece;

my $DateTime = localtime->strftime(“%Y-%m-%d %H:%M:%S”);

]]>Comment on Using Perl to send tweets stored in a MySQL database to twitter by Tony Darnellhttps://scriptingmysql.wordpress.com/2015/01/07/using-perl-to-sent-tweets-stored-in-a-mysql-database-to-twitter/#comment-5643
Wed, 18 Feb 2015 14:52:19 +0000http://scriptingmysql.wordpress.com/?p=1392#comment-5643Thanks for the tip. I have been using my “convoluted way” of getting the time for years, and never bothered to see how to do it better.
]]>Comment on Using Perl to send tweets stored in a MySQL database to twitter by realdavorghttps://scriptingmysql.wordpress.com/2015/01/07/using-perl-to-sent-tweets-stored-in-a-mysql-database-to-twitter/#comment-5642
Wed, 18 Feb 2015 11:55:12 +0000http://scriptingmysql.wordpress.com/?p=1392#comment-5642use POSIX ‘strftime';

Excellent post – we’re using more or less the same method but written in PHP. We are tweeting posts when posts are saved, so we have an auxiliary table where we store the ID of the successfully tweeted post in order not to tweet it again.

]]>Comment on Retrieving Data from MySQL with Perl, Print in HTML Table by dbernalohttps://scriptingmysql.wordpress.com/2011/08/18/retrieving-data-from-mysql-with-perl-print-in-html-table/#comment-5499
Thu, 08 Jan 2015 18:31:29 +0000http://scriptingmysql.wordpress.com/?p=117#comment-5499Thanks this help me a lot :)
]]>Comment on Using Perl to send tweets stored in a MySQL database to twitter by Jeremy Colehttps://scriptingmysql.wordpress.com/2015/01/07/using-perl-to-sent-tweets-stored-in-a-mysql-database-to-twitter/#comment-5496
Wed, 07 Jan 2015 19:18:24 +0000http://scriptingmysql.wordpress.com/?p=1392#comment-5496“How to send spam with MySQL”
]]>Comment on Retrieving Data from MySQL with Perl, Print in HTML Table by sathishhttps://scriptingmysql.wordpress.com/2011/08/18/retrieving-data-from-mysql-with-perl-print-in-html-table/#comment-5248
Thu, 06 Nov 2014 15:02:06 +0000http://scriptingmysql.wordpress.com/?p=117#comment-5248Thanks Tony for the reply. Much appreciated!
]]>Comment on Retrieving Data from MySQL with Perl, Print in HTML Table by Tony Darnellhttps://scriptingmysql.wordpress.com/2011/08/18/retrieving-data-from-mysql-with-perl-print-in-html-table/#comment-5247
Thu, 06 Nov 2014 14:39:22 +0000http://scriptingmysql.wordpress.com/?p=117#comment-5247In this part of the script, you could create one variable that contains all of the variables, separated by a delimiter. I will use a tilde (~). This is assuming that you are only retrieving one row.