Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 embedded dash in col name

Author  Topic 

ronzim
Starting Member

1 Post

Posted - 2014-06-19 : 23:32:40
I have been asked to do some MySQL work for a database, and it turns out that the tables commonly have dashes in the column names. When I try to reference this with MySQL commands, it fails. There are other scripts working with this, but I haven't been given access (yet). Anyone know how to work with column names that have embedded dashes? (kind of like where you would normally use an underscore) or why they might have used the dashes?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-06-20 : 04:27:22
In MySQL you need to wrap it by `

select columns from `your-table`

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -