Mysql® Databases Checking Database

Hello,

when i do a MySQL® Databases, Checking Database on cpanel, in the last lines appears:

[perolado_perol5.phinxlog1454328945] status: OK
[perolado_perol5.phinxlog1454329051] status: OK
[perolado_perol5.phinxlog1454396573] status: OK
[perolado_perol5.phinxlog1457116453] status: OK
[perolado_perol5.phinxlog1465659386] status: OK
[perolado_perol5.phinxlog1465659571] status: OK
[perolado_perol5.phinxlog1474376855] status: OK
[perolado_perol5.phinxlog1474377008] status: OK
[perolado_perol5.phinxlog1480415456] status: OK
[perolado_perol5.phinxlog1481290382] status: OK
[perolado_perol5.phinxlog1481291143] status: OK

Could i delete this lines from MySQL?

Best Regards,

Marco Campos

Hi

Try here http://forum.cs-cart.com/topic/42351-database/

Hello,

when i do a MySQL® Databases, Checking Database on cpanel, in the last lines appears:

[perolado_perol5.phinxlog1454328945] status: OK
[perolado_perol5.phinxlog1454329051] status: OK
[perolado_perol5.phinxlog1454396573] status: OK
[perolado_perol5.phinxlog1457116453] status: OK
[perolado_perol5.phinxlog1465659386] status: OK
[perolado_perol5.phinxlog1465659571] status: OK
[perolado_perol5.phinxlog1474376855] status: OK
[perolado_perol5.phinxlog1474377008] status: OK
[perolado_perol5.phinxlog1480415456] status: OK
[perolado_perol5.phinxlog1481290382] status: OK
[perolado_perol5.phinxlog1481291143] status: OK

Could i delete this lines from MySQL?

Best Regards,

Marco Campos

Yes, these extra tables can be deleted

Thanks for the help.

Best Regards

can anyone suggest me the query to fetch all values from one column in a table????

Thanks in advance!

can anyone suggest me the query to fetch all values from one column in a table????

Thanks in advance!

How will you call this query? In php file or phpMyAdmin or server terminal?

In php file..

I got one solution as

$var = db_get_array("SELECT column FROM table");

it gives solution as

Array
(
[0] => Array
(
[carrier] => value1
)

[1] => Array
(
[carrier] => value2
)

[2] => Array
(
[carrier] => value3
)

[3] => Array
(
[carrier] => value4
)

[4] => Array
(
[carrier] => value5
)

)

But i dont was this result.

i just want the list as

value1

value2

value3

value4 and so on

Try

$var = db_get_fields("SELECT column FROM table");

yes.. it work

Thank you