<div>
this is not possible for distinguish between the records.... as there is <b>no unique identifier </b>if you just having columns: Power State and date while all your records contain same values. when you update the records with values, you will all get the same values.<br />
<br />
you need at least one unique identifier in this case.
</div>


this is not possible for distinguish between the records.... as there is no unique identifier if you just having columns: Power State and date while all your records contain same values. when you update the records with values, you will all get the same values.

you need at least one unique identifier in this case.

<div>
If i add 1 more column put as Name .. so i can put the value like that?
</div>


If i add 1 more column put as Name .. so i can put the value like that?

<div>
<div class="content wysiwyg-content">
May I know whether ANY mysql code can just we insert the data like row 1 until row 19 i put date as '2017-11-01' and then on row 20 until row 40 i put date as '2017-11-02' etc .. something like this.<a href="https://filedb.experts-exchange.com/incoming/2017/12_w51/1216168/Capture.PNG" target="_blank" title="Capture.PNG (57 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 384px;" data-src="https://filedb.experts-exchange.com/incoming/2017/12_w51/1216168/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

May I know whether ANY mysql code can just we insert the data like row 1 until row 19 i put date as '2017-11-01' and then on row 20 until row 40 i put date as '2017-11-02' etc .. something like this.

Insert row question into table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.