User Information from MySQL

Picture of Mertech Mertech : Feb 25, 2008 3:50:00 PM

Databases

This example returns user information from MySQL:

// Begin of Example

Use Mertech.inc

String sID sUser sHost sDB sCommand sTime sState sInfo

Login "localhost" "root" "mertech" "MDSMYSQL"

SQL_SET_STMT TO "show processlist" SQL_PREPARE_STMT SQL_EXECUTE_STMT

Repeat

  SQL_FETCH_NEXT_ROW into sID sUser sHost sDB sCommand sTime sState sInfo

  [ Found ] Begin

     Showln "ID     : "sID

     Showln "User   : "sUser

     Showln "Host   : "sHost

     Showln "DB     : "sDB

     Showln "Command: "sCommand

     Showln "Time   : "sTime

     Showln "State  : "sState

     Showln "Info   : "sInfo

     Showln

     Showln "Presse any key ..."

     Showln

     Inkey Pageend

  End

Until [ Not Found ]

Showln Showln "Ok ...." Inkey Pageend

// End of Example

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...