Data type conver in mysql

#1

Hi! Dose anyone know how to conver (Oct 11 2003 12:30:11:000AM) into
datetime in MYSQL?

Thanks

Brian
----- Original Message -----
From: "brantzdr" <brantzdr (AT) appstate (DOT) edu>
To: <msql-mysql-modules (AT) lists (DOT) mysql.com>
Sent: Monday, December 15, 2003 8:48 AM
Subject: Success with DBD::mysql Install

Quote:

Greetings:

I have installed DBD::mysql on RHEL AS 3 with no problems.

I re-installed the OS without the web server and mysql.

Ran up2date for RedHat, then installed perl 5.8.2. - rebooted.
Installed Apache2 web server and Mysql 4.0 from binary.
Installed DBI and DBD::mysql with no problems all tests passed.
Installed PHP 4.3.4 with axps and mysql.

Everything seems to be working I even got webalizer to work - very cool.

Thanks for all your help.

Douglas

--
Douglas R. Brantz
Computer Consultant
College of Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6549 (phone)
828-262-6312 (fax)

-----Original Message-----
From: news [mailto:news (AT) sea (DOT) gmane.org] On Behalf Of Kermit Tensmeyer
Sent: Saturday, December 13, 2003 11:14 PM
To: msql-mysql-modules (AT) lists (DOT) mysql.com
Subject: module install

how do I set up the grant privledges for the test dbs?
When I install any mysql related module,( DBD::mysql ) make test runs a
test that connects to the database using default parameters.

Normally MySql allows any anoymous user to connect to the test database
with a null password. But the root user (the primary user to install
Perl
modules) is never anonymous, and it's password should not be left null.

Is there a way to execute an explict 'grant all' on test to
'root@localhost' identified with a null password?

----
kermit tensmeyer

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=br...tate (DOT) edu

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/perl?unsub=ls... gsfc.nasa.gov

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data type conver in mysql

mailing.database.msql-mysql-modules mailing.database.msql-mysql-modules

Data type conver in mysql - 12-15-2003 , 08:31 AM