First, I’m going to link to this discussion where your question first appeared, because I believe it’s important to note my assumption that you’re probably using an AdoOutputAdapter to push data into MySQL.
I would recommend against changing the SignalID. Many of the associations in the database and across systems use this as a globally unique identifier for the measurement, so changing it may cause some issues. Furthermore, changing it to something other than a GUID would outright break the openPDC.
That said, the intent behind the SignalID was to provide a unique identifier which could be used reliably by automated processes, but not necessarily so it could be used by humans. There may be better ways to handle your data than to query the SQL database directly using the SignalID as your criterion. As an example, consider the following query to get the 50 most recent frequency values.
Measurement ON TimeSeriesMeasurement.SignalID = Measurement.SignalID
WHERE SignalReference LIKE '%-FQ'
ORDER BY Timestamp DESC
If your TimeSeriesMeasurement table is in a separate database from your Measurement table, you may need to craft cross-database queries or replicate your Measurement table in both databases.
If you need some help writing SQL queries, you can ask about it on these discussion boards.