Search found 2 matches
- Tue Feb 12, 2019 2:51 pm
- Forum: Advanced Topics
- Topic: human readable in MySQL
- Replies: 5
- Views: 9473
Re: human readable in MySQL
Thanks guys, to clarify for appointment status and insplan.PlanNum there are no tables to join. For appointment status I'd just have to hand code the statuses from the appointment table, and for insplan.planNum I would have to maybe look it up within the software?
- Mon Feb 11, 2019 2:08 pm
- Forum: Advanced Topics
- Topic: human readable in MySQL
- Replies: 5
- Views: 9473
human readable in MySQL
When I run a query within OD, appointment status, and insplan.PlanNum show as words not numbers. Toggling between human readable and raw changes this. I’m building queries in MySQL workbench… is there a way to know where these are coming from and/or display them as words in the MySQL code?