Re: use of regex in mysql

On 17/02/17 06:08, J.O. Aho wrote:
> 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
>
>
  A staggering example of the right answer to an entirely different question????

-- 
"Women actually are capable of being far more than the feminists will 
let them."