1SQL::Translator::ProducUesre:r:MCyoSnQtLr(i3b)uted PerlSDQoLc:u:mTernatnastliaotnor::Producer::MySQL(3)
2
3
4

NAME

6       SQL::Translator::Producer::MySQL - MySQL-specific producer for
7       SQL::Translator
8

SYNOPSIS

10       Use via SQL::Translator:
11
12         use SQL::Translator;
13
14         my $t = SQL::Translator->new( parser => '...', producer => 'MySQL', '...' );
15         $t->translate;
16

DESCRIPTION

18       This module will produce text output of the schema suitable for MySQL.
19       There are still some issues to be worked out with syntax differences
20       between MySQL versions 3 and 4 ("SET foreign_key_checks," character
21       sets for fields, etc.).
22
23       Table Types
24
25       Normally the tables will be created without any explicit table type
26       given and so will use the MySQL default.
27
28       Any tables involved in foreign key constraints automatically get a ta‐
29       ble type of InnoDB, unless this is overridden by setting the "mysql_ta‐
30       ble_type" extra attribute explicitly on the table.
31
32       Extra attributes.
33
34       The producer recognises the following extra attributes on the Schema
35       objects.
36
37       field.list
38           Set the list of allowed values for Enum fields.
39
40       field.binary, field.unsigned, field.zerofill
41           Set the MySQL field options of the same name.
42
43       table.mysql_table_type
44           Set the type of the table e.g. 'InnoDB', 'MyISAM'. This will be
45           automatically set for tables involved in foreign key constraints if
46           it is not already set explicitly. See "Table Types".
47
48       mysql_character_set
49           MySql-4.1+. Set the tables character set.  Run SHOW CHARACTER SET
50           to see list.
51
52       mysql_collate
53           MySql-4.1+. Set the tables colation order.
54
55       table.mysql_charset, table.mysql_collate
56           Set the tables default charater set and collation order.
57
58       field.mysql_charset, field.mysql_collate
59           Set the fields charater set and collation order.
60

SEE ALSO

62       SQL::Translator, http://www.mysql.com/.
63

AUTHORS

65       darren chamberlain <darren@cpan.org>, Ken Y. Clark <kclark@cpan.org>.
66
67
68
69perl v5.8.8                       2007-10-24SQL::Translator::Producer::MySQL(3)
Impressum