search

ANumbersGame / anumbersgame

Automatically exported from code.google.com/p/anumbersgame
0 stars 0 forks source link

Extraction from MS Access to MySQL munges every "Div" #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Since "Div" is a reserved word in MySQL, data/scripts/access2mysql.sh
changes it to "Diiv". It would be nice if this happened only when it is
used as a column name.

Right now, the replacement happens everywhere it is used. This includes
when it is just part of a column name ("Division" -> "Diivision") and when
it is just part of a value in a record ("Divide and conquer" -> "Diivide
and conquer").

[http://dev.mysql.com/doc/refman/5.0/en/identifiers.html It's not
impossible to have "Div" as a column name.]

Original issue reported on code.google.com by google.a...@gtempaccount.com on 28 Apr 2009 at 10:12