Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Mysql® Databases Checking Database Rate Topic   - - - - -

 
  • mpfcampos
  • Junior Member
  • Members
  • Join Date: 28-May 07
  • 19 posts

Posted 10 December 2016 - 12:45 PM #1

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



 
  • BarryH
  • Senior Member
  • Members
  • Join Date: 03-Sep 07
  • 1459 posts

Posted 10 December 2016 - 04:23 PM #2

Hi

 

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


BarryH

 

CS-Cart v4.4.3 (Plus one being developed v4.5.2 SP2)
UK User


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19768 posts

Posted 12 December 2016 - 08:03 AM #3

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • mpfcampos
  • Junior Member
  • Members
  • Join Date: 28-May 07
  • 19 posts

Posted 12 December 2016 - 10:46 AM #4

Thanks for the help.

Best Regards



 
  • abcd
  • Advanced Member
  • Trial users
  • Join Date: 10-Sep 16
  • 52 posts

Posted 16 December 2016 - 06:37 AM #5

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

 

Thanks in advance!



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19768 posts

Posted 16 December 2016 - 08:06 AM #6

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?


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • abcd
  • Advanced Member
  • Trial users
  • Join Date: 10-Sep 16
  • 52 posts

Posted 16 December 2016 - 08:14 AM #7

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



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19768 posts

Posted 16 December 2016 - 08:18 AM #8

Try

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

GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • abcd
  • Advanced Member
  • Trial users
  • Join Date: 10-Sep 16
  • 52 posts

Posted 16 December 2016 - 08:36 AM #9

yes.. it work

 

Thank you