List:General Discussion« Previous MessageNext Message »
From:Joe Kosinski Date:April 5 2013 6:25pm
Subject:Fwd: mysql_tzinfo_to_sql
View as plain text  
I tried the use mysql; for my session.  Here is the result:

			

Joe

Begin forwarded message:

> From: shawn green <shawn.l.green@stripped>
> Subject: Re: Fwd: mysql_tzinfo_to_sql
> Date: April 5, 2013 1:58:01 PM EDT
> To: Joe Kosinski <jojako@stripped>
> 
> Hi Joe,
> 
> On 4/5/2013 1:58 PM, Joe Kosinski wrote:
>> The commands didn't work and the time zone tables are not loaded.
>>  Whenever I ran the queries mysql> SELECT * FROM time_zone;
>>> mysql> SELECT * FROM time_zone_name;
>> I got an error message stating no database was selected.  I think when I
>> tried to locate the path to the mysql_tzinfo_to_sql previously nothing
>> worked.
>> 
> 
> All tables are organized into databases. The timezone tables are in the `mysql`
> database. To change your active database, use the 'use' command in your session
> 
> use mysql;
> 
> -- 
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
> Office: Blountville, TN


Attachment: [text/html]
Attachment: [application/octet-stream] Terminal Saved Output 7
Attachment: [text/html]
Attachment: [text/html]
Thread
Fwd: mysql_tzinfo_to_sqlJoe Kosinski5 Apr
  • Fwd: mysql_tzinfo_to_sqlJoe Kosinski5 Apr
    • Fwd: mysql_tzinfo_to_sqlJoe Kosinski5 Apr
      • Re: Fwd: mysql_tzinfo_to_sqlWm Mussatto5 Apr
        • Fwd: mysql_tzinfo_to_sqlJoe Kosinski6 Apr
          • Re: mysql_tzinfo_to_sqlReindl Harald6 Apr
            • Re: mysql_tzinfo_to_sqlReindl Harald6 Apr
              • Fwd: mysql_tzinfo_to_sqlJoseph Kosinski6 Apr
                • Re: mysql_tzinfo_to_sqlReindl Harald6 Apr