NAME

SQL::ReservedWords::MySQL - Reserved SQL words by MySQL

SYNOPSIS

if ( SQL::ReservedWords::MySQL->is_reserved("accessible") ) {
    die "Don't use reserved words in column names!";
}

# or

use SQL::ReservedWords::MySQL 'is_reserved';

if ( is_reserved("group") ) {
    die "Don't use reserved words in column names!";
}

DESCRIPTION

Determine if words are reserved by MySQL.

METHODS

is_reserved( $word )

Returns a boolean indicating if $word is reserved by either MySQL 3.2, 4.0, 4.1, 5.0 or 5.1.

is_reserved_by_mysql3( $word )

Returns a boolean indicating if $word is reserved by MySQL 3.2.

is_reserved_by_mysql4( $word )

Returns a boolean indicating if $word is reserved by MySQL 4.0 or 4.1.

is_reserved_by_mysql5( $word )

Returns a boolean indicating if $word is reserved by MySQL 5.0 or 5.1.

words

Returns a list with all reserved words.

EXPORTS

Nothing by default. Following subroutines can be exported:

is_reserved

is_reserved_by_mysql3

is_reserved_by_mysql4

is_reserved_by_mysql5

words

SEE ALSO

http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

AUTHOR

Christian Hansen ch@ngmedia.com

COPYRIGHT

This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.