#14 alter export a enum

2.2.1
closed-fixed
Common (150)
5
2009-11-06
2009-09-22
asdf asdf
No

Ahoj Jakube, zkousel jsem create+alter na jedne tabulce a vyhodilo mi to error, ktery je zpusoben nejspis opomenutym slashovanim hodnot v enumu.

Chyba v dotazu: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Registrace','Registrace a platby')' OR _extra != '' OR _column_comment != 'Odesl' at line 79

IF NOT (_column_default <=> NULL) OR _is_nullable != 'NO' OR _collation_name != 'utf8_czech_ci' OR _column_type != 'enum('Registrace','Registrace a platby')' OR _extra != '' OR _column_comment != 'Odeslat emailem potvrzení týkající se' OR after != 'termin' THEN
SET @alter_table = CONCAT(@alter_table, ', MODIFY `potvrzeni` enum(\'Registrace\',\'Registrace a platby\') COLLATE utf8_czech_ci NOT NULL COMMENT \'Odeslat emailem potvrzení týkající se\' AFTER `termin`');
END IF;

Discussion

  • Jakub Vrána

    Jakub Vrána - 2009-09-23

    Díky za upozornění, opravil jsem to v SVN.

     
  • Jakub Vrána

    Jakub Vrána - 2009-09-23
    • status: open --> closed
     
  • Jakub Vrána

    Jakub Vrána - 2009-11-06
    • status: closed --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks