List:General Discussion« Previous MessageNext Message »
From:Timothy Sehn Date:February 17 2005 8:00pm
Subject:Weird "@" in column name
View as plain text  
I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the strangest error:

mysql> use devmail
Reading table information for completion of table and column names You can turn off this
feature to get a quicker startup with -A

Database changed
mysql> select type_name from faq_type;
+----------------------------+
| @                         |
+----------------------------+
| Build/Compile/Link Errors  |
| ContactUs System           |
| Continuous Build System    |
| DevServices Scripts Issues |
| General Package Issues     |
| General Tools Issue        |
| Other                      |
| PackageBuilder Issue       |
| Perforce License Request   |
| Perforce Usage             |
| Third-Party Request        |
| Versionset Creation/Update |
| WebTools                   |
+----------------------------+
13 rows in set (0.00 sec)

mysql> use ssimail
Reading table information for completion of table and column names You can turn off this
feature to get a quicker startup with -A

Database changed
mysql> select type_name from faq_type;
+---------------------------------------------------+
| type_name                                         |
+---------------------------------------------------+
| Merchant Integration Compliance Evaluation (MICE) |
| Merchant Integration Test Environment (MITE)      |
| Other SSI Projects                                |
| Pro Merchant Self Service Integration Projects    |
+---------------------------------------------------+
4 rows in set (0.01 sec)

Notice how the column anme is returned as "@". Has anyone ever seen anything like this
before. Those tables are exaclty equivalent. They were created from the same .ddl file.

--Tim
Thread
Weird "@" in column nameTimothy Sehn17 Feb
  • Re: Weird "@" in column nameGleb Paharenko18 Feb