Menu ▾ ▴

#2312 MySQL + Reserved Words + EXPORT

2.9.0-rc1
invalid
nobody
Data Export (251)
5
2013-06-11
2006-11-30
Adam Schroeder
No

phpMyAdmin Version: 2.9.0-rc1
MySQL Version: 4.1.16
PHP Version 5.1.6

It appears as if when exporting table data with column names such as 'order' and 'group' (mysql reserved words) -- the resulting SQL (insert statements) become broken.

I searched the bug tracker and could not find a report of any similar bugs. Maybe this is something that has been fixed in later versions. In any event...

Definitely, not a major bug. Great product and great job guys!

-Adam

Discussion

  • Michal Čihař

    Michal Čihař - 2006-12-05

    Logged In: YES
    user_id=192186
    Originator: NO

    You should not uncheck "Enclose table and field names with backquotes" if you use reserved words.

     

  • Michal Čihař

    Michal Čihař - 2006-12-05
    • status: open --> closed-invalid
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-invalid --> invalid