How to Access MySQL Columns with Hyphens from Java?

Handling Hyphens in MySQL Column Names for Java Applications

When working with MySQL databases that contain column names with hyphens, accessing these columns from Java code can present challenges. Hyphens are treated as field separators in Java, leading to names being broken down at the hyphen.

To overcome this issue, consider the following solutions:

1. Enclose Column Names in Backticks:

   MySQL allows column names to be enclosed in backticks (). This ensures that hyphens are treated as part of the name rather than separators. For example, to access a column named air_port, use backticks around it:

   String columnName = "`air_port`";

   Copy after login

2. Use Escape Character:

   In Java, you can use the escape character to escape hyphens. This allows you to preserve hyphens without triggering the separator logic. For example:

   String columnName = "air\-port";

   Copy after login

3. Modify Database Structure:

   If possible, consider modifying the database structure to replace hyphens with underscores or another separator that is compatible with Java conventions.

4. Check Character Set:

   Verify that the character set used by the database is compatible with UTF-8, which supports hyphens in column names. If necessary, adjust the character set accordingly.

By following these solutions, you can successfully access MySQL columns with hyphens in their names from Java applications.

The above is the detailed content of How to Access MySQL Columns with Hyphens from Java?. For more information, please follow other related articles on the PHP Chinese website!