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>


[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

-- 

 //Aho
Received on Fri Feb 17 2017 - 07:08:27 CET

Original text of this message