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 *


Lena

Lena

mysql_tzinfo_to_sql is a utility that is used to load time zones on systems that have a zoneinfo database