Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads the time zone tables in a mysql database?

Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads
the time zone tables in a mysql database?

Which of the following scripts is used to convert Unix-type zone files into SQL statements, and loads
the time zone tables in a mysql database?

A.
mysql_tzinfo_to_sql

B.
mysql_time_to_sql

C.
mysql_timezone_to_sql

D.
mysql_tz_to_sql

Explanation:
mysql_tzinfo_to_sql script converts the Unix-type zone files into SQL statements and loads time
zone tables in the mysql database. It is used
on systems that have a zoneinfo database. A zoneinfo database is a set of files describing time zones.
Answer C, D, and B are incorrect. No such scripts are available in a MySQL database.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


warren

warren

The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database.