Re: use of regex in mysql
From: J.O. Aho <user_at_example.net>
Date: Fri, 17 Feb 2017 07:08:27 +0100
Message-ID: <egniarF2eglU1_at_mid.individual.net>
Date: Fri, 17 Feb 2017 07:08:27 +0100
Message-ID: <egniarF2eglU1_at_mid.individual.net>
[Quoted] On 02/17/17 05:29, kushal bhattacharya wrote:
> please tell me how to do that
>
Instead of having
column
sense/humidity/pressure
you could have
column1 column2 column3 sense humidity pressure
or having multiple tables
table1
id name 1 sense 2 humidity 3 pressure table2 id measure_time 1 2012-01-02 12:11:21 2 2013-02-02 11:11:11 table3 table1_id table2_id data 1 1 12 2 1 58 3 1 1201 1 2 13 2 2 61 3 2 1000
You can read more about normalization at the wikipedia, so you get the
basic understanding about it:
https://en.wikipedia.org/wiki/Database_normalization
-- //AhoReceived on Fri Feb 17 2017 - 07:08:27 CET