mysql - URL as a table name -
i have table in jdbc mysql database has records unique string field, string url. each url needs have table named exact url.
the issue: url consist of more 64 characters, exceeds maximum length of table identifier (mysql reference). url contains non permitted characters.
how should handle this? thought find or create kind of encoder follow limitations , deed bijection function. ideas?
naming tables urls horrible idea. not run max name length issues, encoding issues , escape issues.
a improve approach generate automatic names (table1, table2 etc) , have index table maps url table created it
mysql
No comments:
Post a Comment